Create cubes based on dimension views sample
This script creates four dimension views, creates
four PowerCubes based on the dimension views, and then creates the
.mdc files. Each cube relates to one region, except for
All
Regions
which has a drill through to all regions.
OpenMDL "c:\Outdoors.mdl"
ViewMake "Region Summary" Dimension "Locations" LevelSummary
Dimension "Locations" Drill "By Region" Levels "Region"Apex
"Region"
ViewMake "North America" Dimension "Locations"
Apex "Region"Summary "Europe"Summary "Far East"
ViewMake "Far East" Dimension "Locations"
Apex "Region"Summary "Europe"Summary "North America"
ViewMake "Europe" Dimension "Locations"
Apex "Region" Summary" Far East" Summary "North
America"
CubeMake "All Regions" MdcFile "c:\All Regions.mdc"
DrillThrough True "c:\NorthAmerica.mdc"
"" "c:\europe.mdc" "" "c:\fareast.mdc" "" EndList
DimensionView "Locations""Region Summary"
CubeMake "North America" MdcFile "c:\North America.mdc"
DimensionView "Locations""North America"
CubeMake "Far East" MdcFile "c:\Far East.mdc"
DimensionView "Locations" "Far East"
CubeMake "Europe" MdcFile "c:\Europe.mdc"
DimensionView "Locations" "Europe"
CreateFiles