Loading members into a dimension is a metadata load. During member load, dimensional structures such as members, member attributes, hierarchies, and levels are created and populated. (This is metadata information.) As a result, it is important to do a member load in the shadow schema and then restructure to publish changes to the base schema.
The members of a dimension and how they relate to each other are important when creating the multidimensional space within which the system operates.
The following example loads members into dimensions and restructures the hierarchy:
# Set the schema to shadow in backend and clear any previous information. set schema shadow clear schema shadow # Load dimensions and restructure so dimensions and members are # in the base schema. The macro replace command replaces all dimensions. # The reference to model group name is from the stagemap definitions. # You can logically group the stagemaps using this name # and the macro command automatically invokes all the stagemaps # grouped under this name. You can create # different logical groups, put the stagemaps under different # groups, and invoke them separately. stage replace using modelgroup "Bootstrap-Dimension-Stagemaps" load replace dimensions # Push object definitions from shadow schema to base schema. alter system restructure