Skip to main content

Add Dimensions to Models

This section explains how to add the different kinds of dimensions in AtScale, and create the relationships needed to include them in a model. The process is slightly different depending on the type of dimension you are modeling.

When modeling dimensions, consider the following:

  • Unhandled NULL values in key columns will result in incomplete aggregate tables and unexpected query results. See the Custom Empty Member feature for more details.
  • Once you have modeled a dimension in any model, that dimension is saved in the repository and can be reused in other models, or in other contexts in the same model. For example, you may model a common Date dimension that is reused in many different contexts.
  • A dimension is not included in a model until it has a relationship to the fact dataset of the model (either directly or indirectly). For details, see Modeling Relationships.