1 / 5

Chapters 10

Chapters 10. 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

pomona
Download Presentation

Chapters 10

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Chapters 10

  2. 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

  3. 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)

  4. 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

  5. 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

More Related