wlfv rq 0'; 5hvxowv
Post on 04-Feb-2022
6 Views
Preview:
TRANSCRIPT
Lab3 Guide for
Set Up to Build a Cube and Data Analytics on MDX Results
CIS 611
Sunnie Chung
1. Design and build Cube:
Source View:
New Cube:
2. Deploy and process Cube:
Deploy Project:
Process Project:
Process Dimension: By default all dimensions contains only key but we are using country in our MDX. So we have to edit our dimension in such a way it contains the fields that we are using in the mdx query.
Reprocess Cube:
Execute Query: SELECT NON EMPTY {[Dim Sales Territory].[Sales Territory Country].children } on rows, [Measures].[Sales Amount] ON COLUMNS FROM [Adventure Works DW2012]
top related