November 7, 2008 at 2:16 pm
I can't seem to identify what is likely a configuration option somewhere. Searching is like wading through an ocean of "almost, but not what I'm looking for" results.
I have a whole bunch of pretty technical end users, and here's what I want Reporting Services to do:
When querying an SSAS data cube for, say, revenue by country by date, I want Reporting Services to return essentially a table of data that includes a date for every line. Right now, it returns a date in just one row and shows all the countries and their respective revenues for that date in several rows below that date. When viewing it, it's easy to read human-wise, but when the end users want to then take that data and dump it into Excel for further processing they are having to write formulas to fill in the relevent date for every row. Since our business is doing a whole lot of exploratory stuff, we need to be able to fully manipulate data in Excel. At the moment, Reporting Services is actually hampering our ability to do that, since if we continue down this path, I effectively become a bottleneck, since any further processing/research that the end user could do in Excel is instead something only I can do.
So, I want Reporting Services to return a solid table of data when an end user uses the Report Build mini-app. I do not want the date for many rows of data for that date to be displayed only on the top-most row of that block of rows.
I will continue to search for a solution, and if I find one, I will be sure to post it here.
November 8, 2008 at 11:20 am
When using SSAS as a data source for SSRS you should be getting a row for each record, so you should be seeing a date and country record for each measure that you are evaluating. Within SSRS the data for SSAS is going to get flattened out and it won't be displaying one date for a group of countries. I am assuming it must be how you are using the data in the designer withing a table or matrix and how you are grouping the data. If you are using a matrix then you are not going to get a detail record for each date and country combination because of the grouping on the columns. If you use a table to display the data then you should be getting the results that you are after for the end-users to export and analyze.
If you are still having issues getting at the results you want then provide more detail how you are using it in SSRS and provide the generated MDX out of the editor. If these are power users then you could simply have them connect directly to the cube through Excel. Excel 2007 works really good with SSAS now and has great conditional formatting options that you can utilize too.
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply