Choose measures and hierarchies whether you are creating or editing a cube schema.
To choose measures and hierarchies in the Cube Schema Wizard:
In Choose Measures and Hierarchies, enter a Cube Schema Name.
Drag hierarchies that you want to include in this cube schema from the Available Dimension Elements list and drop them in the Hierarchies box on the right.
You cannot add the same hierarchy more than once.
Alternatively, you may add hierarchies by selecting them in the Available Dimension Elements list and clicking the Add selected hierarchies button.
Note:
To remove hierarchies from the Hierarchies list, select the hierarchies in the Hierarchies list and click the Remove selected hierarchies button.
Drag one or more measures or a single measures hierarchy from the Available Dimension Elements list and drop them in the Measures/Measures Hierarchy box on the right.
You cannot add the same measure or measure hierarchy more than once.
Alternatively, you may add measures or a measure hierarchy by selecting them in the Available Dimension Elements list and clicking the Add selected measures or measure hierarchy button.
Note:
You may add only one measure hierarchy to the cube schema, but you may add one or more measures. When you add one or more individual measures that are not organized into a hierarchy, these are referred to as “loose” measures. You must add either a single measure hierarchy or one or more loose measures.
Note:
To remove measures or a measure hierarchy from the Measures/Measure Hierarchy list, select the measures or measure hierarchy in the Measures/Measures Hierarchy list and click the Remove selected measures or measure hierarchies button.
Optional: Click Preview Hierarchies to view the structure of the hierarchies that you have chosen for this cube schema, as described in Previewing Hierarchies.
When you are finished viewing hierarchies, click OK.
Click Next to open the next page of the wizard, Cube Schema options, as described in Setting Cube Schema Options.