Database Reference
In-Depth Information
5. Now you can create the new measure group. In the
Solution Explorer
,
double-click on the
Adventure Works DW2012.cube
cube. In the
Cube
Structure
tab, click on the
New Measure Group
button to create the new
measure group.
6. Select the
FactSalesQuota
table as the new measure group table and click
on
OK
.
7. Remove the newly created
Calendar Year
,
Calendar Quarter
, and the
Fact
Sales Quota Count
measures.
8. Click on the
Partitions
tab in the cube designer.
9. Under the
Fact Sales Quota
measure group, right-click on the
Fact Sales
Quota
partition and select
Writeback Settings
:
10. Leave the default selections for the write back tables and click on
OK
.
Search WWH ::
Custom Search