A schema must contain the following before creating a new cube:
- At least one dimension, containing
- At least one hierarchy, containing
- At least one level
- At least one hierarchy, containing
- At least one measure group
- Expand the schema on the Schema Tree View.
-
Right-click the Cubes folder, then click New Cube.
The Schema Element Properties pane displays the Cube Properties tab with blank settings.
-
In the Name box, type a name for the new measure group, then click the Caption box.
The caption automatically fills with the same name as the level. The caption is a name that is displayed and can be localized to different languages in the BI client application. See Cube Schema Localization.The cube name can be up to 100 characters in length. The following punctuation and special characters are not allowed in cube names:
. , ; ' ` : / \ * | ? " & % $ ! + = ( ) [ ] { } < >
- Click the Measure Groups tab. Available Measure Groups display measure group names, captions, and source fact tables.
-
To associate a measure group with this cube, check the boxes in the Use column.
You can click the Check All or Uncheck All button to select or deselect all listed measure groups.
- Click the Cube Properties tab, then select options to define the default measure from the Group and Measure lists. When an OLAP tool, such as MS Excel, sends MDX without a specified measure, Teradata OLAP Connector uses the default measure.
-
Modify additional properties as needed:
- For best results, leave Enabled and Cache cell values check boxes active.
The Enabled check box indicates whether or not this cube is enabled (when published) for BI clients such as Excel. This allows you to publish a schema with usable new aspects, but hide defined and validated cubes from the Excel client user.
-
Drill-Through Settings are active by default. See Drill-Through.
- For best results, leave Enabled and Cache cell values check boxes active.