Download
1 / 5
50 likes | 185 Views
This chapter provides an in-depth look at deploying and processing your definitions in Analysis Services. Key tools such as MSDT and SSMS are essential for deployment and checking results, respectively. The Analysis Services Deployment Wizard facilitates automated production deployment. Learn how to define time intelligence, handle currency conversion, and create KPIs within your cubes. Explore advanced features like partitions for improved performance, aggregation design options, and the use of perspectives and translations to enhance your data models and user experiences.
E N D
Deploying and Processing • Deploying • Send your definitions to the Analysis Services • Processing • Perform the all prescribed calculations • Tools are • MSDT – to deploy and process (trigger these activities) • SSMS – to check the results • Analysis Services Deployment Wizard – a more advanced tool that generate script for automated deployment to production -- skip
Other Bells and Whistles • Linked Object – especially linked measures • Allowed to combine other cubes to an existing one • BI wizard • A tool allows you to do a number of capability easily • Define time intelligence • Period to date calculation, rolling average, period-over-period growth • Define currency conversion • A lot more (page 384)
Other Bells and Whistles • KPI • The dashboard to indicate how things are going • Actions • Making cube even fancier by allowing other activities such as following a URL, allowing drill-through, or launching a Reporting Service report • Partitions • Break one cube to several cubes for concurrent processing to improve performance • Partitions and storage options MOLAP, ROLAP
Other Bells and Whistles • Aggregation Design • How much aggregation is performed • Two approaches: usage based or manual • Usage based is determined by checking the usage log • Manual is where the developers specify • Perspectives – very much like views • Translations – at metadata level
