wlfv rq 0'; 5hvxowv
TRANSCRIPT
![Page 1: WLFV RQ 0'; 5HVXOWV](https://reader031.vdocuments.us/reader031/viewer/2022020706/61fc75c11804dc35505a4d6f/html5/thumbnails/1.jpg)
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:
![Page 2: WLFV RQ 0'; 5HVXOWV](https://reader031.vdocuments.us/reader031/viewer/2022020706/61fc75c11804dc35505a4d6f/html5/thumbnails/2.jpg)
2. Deploy and process Cube:
Deploy Project:
Process Project:
![Page 3: WLFV RQ 0'; 5HVXOWV](https://reader031.vdocuments.us/reader031/viewer/2022020706/61fc75c11804dc35505a4d6f/html5/thumbnails/3.jpg)
![Page 4: WLFV RQ 0'; 5HVXOWV](https://reader031.vdocuments.us/reader031/viewer/2022020706/61fc75c11804dc35505a4d6f/html5/thumbnails/4.jpg)
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]
![Page 5: WLFV RQ 0'; 5HVXOWV](https://reader031.vdocuments.us/reader031/viewer/2022020706/61fc75c11804dc35505a4d6f/html5/thumbnails/5.jpg)