When you validate or publish a schema, a warning displays if you do not have a Time dimension type. Although most cubes have a Time dimension type, it is not required and you can still publish the schema.
Additionally, a warning displays if the cube has more than one Time dimension type. For best results with multiple Time dimension types, create a separate hierarchy for each, with levels consisting of Time types.
For more information on foreign keys in fact tables, see Modeling Dimensions and Hierarchies.
- From the Schema Tree View, right-click the Dimension folder, and select New Dimension. An empty Dimension icon displays within the folder, and the Dimension page appears in the Schema Elements Properties view.
- In the Name box, type a name for the new dimension.
- Click the Caption box. The Caption box automatically fills the same name as the dimension. The caption is a name that is displayed and can be localized to different languages in the BI client application. See Cube Schema Localization.
- Select a dimension type from the Dimension Type menu. For more about dimension types, search “available dimension types” in the MS Developer Network Library at http://msdn.microsoft.com/library/.
- From the Leaf Members table, select the table associated with the dimension.
-
Take time now to add dimension hierarchies.
See Creating a Hierarchy for a Dimension.
This populates the Default Hierarchy menu in the dimension Schema Elements Properties.
-
Select the new dimension in Schema Tree View, and select an option from the Default Hierarchy menu.