Learning about basic dimension processing
You can process dimensions using SSMS processing dialog or XMLA script. Alternatively, you could use the ascmd.exe
command line utility to schedule a dimension processing. While developing the solution, you could also process dimensions using SSDT.
Getting ready
Launch SSMS and connect to the existing AdventureWorks_Sample
database, which has been previously deployed on your instance of Analysis Services. Expand the Dimensions
folder within the current database.
How to do it...
To process a dimension, perform the following steps:
- Right-click on any dimension and choose Process; doing so opens the Process Dimension dialog.
- Choose any of the dimension processing options except
ProcessAdd
. This option is not available ...
Get SQL Server Analysis Services 2012 Cube Development Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.