Assignment of Dimensions to Models
You assign dimensions to models to make the data in those dimensions available in your model.
Each model must have at least one dimension of the required types: Account (A), Category (C), Entity (E), and Time (T). Additional dimensions may be required depending on the type of model.
Use caution when adding dimensions from a model that already contains data. Assign dimensions only to new models that do not contain data. If you do add a dimension to a model with data, the system finds the first base member alphabetically, and loads it into the Fact tables, therefore writing all of the data from the model to that member.
Activities
To assign a dimension to a model, you modify the model as follows:
-
Select the model and choose Edit.
-
Choose Add / Remove.
-
Select one or more available dimensions, then choose Add, then OK.
To remove a dimension from a model, you modify the model as follows:
-
Select the model and choose Edit.
-
Choose Add / Remove.
-
Select one or more selected dimensions, then choose Remove, then OK.