High lights:
1) Create a template
2) Create a report based on Analysis Services
3) Create a Drillthrough report
4) Create a Pie chart
1) Report showing Annual payroll, Total establishments by Year
1) Create a template
2) Create a report based on Analysis Services
3) Create a Drillthrough report
4) Create a Pie chart
1) Report showing Annual payroll, Total establishments by Year
2) Drillthrough after clicking on Total Establishments for CA:
3) Pie Chart in Design mode:
4) Pie Chart showing the top 20 states with Number of establishments:
Take-Away: How to create the parameters to pass for a drill through report based on Analysis Services - Cube
We need to pass the parameters in MDX format. This is the query for the main report.
See the query "WITH" and we are using "yearuniquename" and "StateUniquename" values.
Ex: Yearuniquename:
[DimYear].[Year SK].&[2011]
StateUniqueName:
[DimCounty].[State Name].&[MD]
We are passing these values to the drillthrough report as parameters...
5) Key highlights are in the video:
No comments:
Post a Comment