Search results for query: *

Thanks, Riverguy. The article is pretty indept and gives a strategy of sorts to attempt such a thing.... However, I guess I was looking for a short answer or "silver bullet" . The biggest factor comes down to data staging, which is what I suspected. SSIS does give far more flexibility than...

The company I work for deals with post-analytics... as I'm sure the vast majority of the analytics market does. We get data that is at least a day old, add it an existing OLAP Cube, then processs... then we look at that cube for analysis. However, I was recently asked if BI had a real-time...

Thanks, MDXer. Would you know anything about RadarCube? They seem to have some pretty impressive write-ups.

Hi guys. If I am posting this in the wrong forum, please let me know. I am looking for a pivot-table type control, similar to the one used by Excel 2007 OLAP Client, that would allow me to use to connect to an OLAP Cube. Does anyone have any suggestions? Thanks in advance.

Hi guys. If I am posting this in the wrong forum, please let me know. I am looking for a pivot-table type control, similar to the one used by Excel 2007 OLAP Client, that would allow me to use to connect to an OLAP Cube. Does anyone have any suggestions? Thanks in advance.

So here's the scenario: Say I have the following MDX Script SELECT [Measures].[Sales] ON COLUMNS, [DIM VEHICLE].[CARS].CURRENTMEMBER ON ROWS FROM [SALES_CUBE] But then my boss comes in and says, "Hey GrandMauler... we need the results put into terms of Corvettes and Non-Corvettes!" How do I...

I'm using SSRS 2005. I'm designing a report that will show week over week trends. These week columns will obviously be in my column group. However, the first column needs to be independent of the weekly column group. It will show some sort of percentage for the current week and does not need...

Thank you!

3 hours later, our semi-young hero makes a startling discovery... he needs Proclarity Analytics Server to publish his mdx reports.... ---------------------------------------------------------- Never truer words were spoken. Yes, this seems the only alternative left to me, if for no other...

It's Proclarity Desktop Professional. Is that all I need or do I need to purchase some thing else?

Flybridge - WOW! I'm very impressed with what I'm reading so far. Have you guys purchased it? If so, what strategy did you use to convince your company to make the investment? From what I'm seeing, it sells itself... provided you know something about BI. However, I'm dealing with people who...

Ok, I think I panicked too soon. I found a solution that I think will work: http://danmeyers.spaces.live.com/blog/cns!7B729558749C22DD!334.entry Basically, you have to use the OLE DB provider and write your own connection string. This allows you to use any MDX query you want to. So far, it...

This year, I managed to convince my bosses to invest in a BI platform. We purchased SQL 2k5, two high-end servers, and Proclarity Desktop proffesional. I have built a Cube for one of our clients and showed them how to access it via an Excel OLAP client. I built a very sophisticated SSIS pkg to...

Ok, some time ago, when I was first researching Reporting Services, I came across a tutorial that showed how to use an MDX data source. I remember the tutorial used a window different from the one on the data tab in Reporting Services platform. It wasn't the Design Mode window. I have...

I found the answer a while back but forgot to post the answer for people with a similar problem. Here it is: The problem is related to x64 systems. The solution is to uninstall the current 7z off the computer and install 7z442-x64.msi I forgot where I got it from, but it shouldn't be too...

I just thought of something: Is is possible to pass an actual Connection Object from the SSIS layer down to the VB Script? Assume the Connection Object is MSOLAP90 (in other words, an Analysis Services connnection). Let me know what you think.

This one is pretty staightforward: Here's the part of the code that fails: Dim oServer As New Microsoft.AnalysisServices.Server oServer.Connect("MyServer") Here's what you need to know: MyServer was removed from our company's domain and put on a separate network for security reasons. There...

Got it, thanks!

So I've managed to deploy a Report Server. And I've played aroudn with the Report Builder, which is a very cool ad-hoc reporting tool. But now I want to make Report Builder available to other users. I've created the roles for the specific users I want. I've given them "Content Manager"...

Ok, I found the answer in the following link: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1675815&SiteID=1 But the short of it is this: Change your TargertServerURL from http://servername/reports to http://servername/reportserver. After I did this, it deployed fine. I hope this...