Database Reference
In-Depth Information
Learning about basic dimension
processing
You can process dimensions using SSMS processing dialog or XMLA script. Altern-
atively, 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:
1. Right-click on any dimension and choose
Process
; doing so opens the
Pro-
cess Dimension
dialog.
2. Choose any of the dimension processing options except
ProcessAdd
. This
option is not available in the dialog.
3. Click on the
Script
button in the top-left corner of the dialog and choose
Script
Action to New Query Editor Window
. The sample XMLA command for pro-
cessing the
Geography
dimension is as follows:
<Batch xmlns =
"http://schemas.microsoft.com/
analysisservices/2003/engine">
<Parallel>
<Process xmlns:xsd =
"http://www.w3.org/2001/XMLSchema"
xmlns:xsi =
"http://www.w3.org/2001/XMLSchema-instance"
xmlns:ddl2 =
"http://schemas.microsoft.com/
Search WWH ::
Custom Search