Show Sales Goals in cube
-
Wednesday, February 13, 2013 6:55 PM
Hi,
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.
Tia,
Martin
All Replies
-
Monday, February 18, 2013 4:42 AMModerator
Hi Martin,
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
http://www.youtube.com/watch?v=-edaNNVGb5AIn SSRS, we can create a group for a report. For more information, please see:
http://technet.microsoft.com/en-us/library/dd255263.aspxIf you have any feedback on our support, please click here.
Regards,
Elvis Long
TechNet Community Support
- Marked As Answer by Elvis LongMicrosoft Contingent Staff, Moderator Monday, February 25, 2013 2:36 AM
.png)
