A snowflaked dimension removes
low-level cardinality
attributes from the dimension tables and places them in secondary
dimensions that are linked back to the original dimensions by artificial
keys.
To model a snowflaked dimension as a star dimension, do the following:
Procedure
-
Select the query subjects that are required
to access
the data, and put them in a new namespace Creating folders or namespaces.
-
Ensure
that all relationships are correct Relationships.
-
Handle multilingual metadata Multilingual metadata.
-
Create a model dimension for each snowflaked dimension:
- Select the query subjects you need.
- Click Actions, Merge
in New Regular
Dimension.
- Rename the new model dimension. By
default, its name is composed
of the concatenated names of the original objects.
-
If you require multiple levels, do one of
the following:
- Use the dimension map to define hierarchies and levels for the dimension. See Creating regular dimensions.
- Specify determinants if the levels are stored in a single query subject. See Determinants.