Wednesday, February 13, 2013 6:55 PM
I'm new to the Analysis Services product but my first cube (and reports using Reporting Services) have been created. I am at the moment somewhat lost trying to find some samples illustrating a scenario like this:
- a Facts table which has Fiscal Year,Qtr,Mth,Week, Customer, OrderAmount among others
- a Time Dimension, a Customer Dimension (Customers can be grouped by BusinessModel) etc.
- I have a SQL table which has Customer, Fiscal Year, Fiscal Qtr, GoalAmount (4 Qtrs a year, sum(Goal QTRs)=Year goal).
What I want is to display/report for a given Fiscal Year/Qtr the revenue realized and the Goal for a (group of ) customer (s).
Any help or link to an example would be appreciated.
Monday, February 18, 2013 4:42 AMModerator
I would recommend you refer to the following articles to create a SSRS report which use SSAS cube as the data source. Please see:
Creating Report Datasets from SQL Server Analysis Services: http://technet.microsoft.com/en-us/library/ms156334(v=sql.100).aspx
In SSRS, we can create a group for a report. For more information, please see:
TechNet Community Support
- Marked As Answer by Elvis LongMicrosoft Contingent Staff, Moderator Monday, February 25, 2013 2:36 AM