📄️ About the Dimension Editor Canvas
The dimension editor Canvas is where you work on the hierarchies, levels, secondary attributes, and secondary/snowflake relationships for a particular dimension.
📄️ Edit a Dimension
After creating a dimension, you can edit it to change its name, type, and other properties. You can also model additional hierarchies, levels, and secondary attributes.
📄️ Edit a Hierarchy
Once a dimension is created, you can edit its hierarchies to change their names and other properties.
📄️ Edit a Level
You can edit dimension levels to change their names and otherproperties.
📄️ Edit a Secondary Dimensional Attribute
You can edit secondary dimensional attributes to change their names and other properties.
📄️ Add a Level Alias
Level aliases enable the creation of tabular reports that select hierarchical expressions without forcing the user to drill down a hierarchy. For more information on how level aliases work, see About Dimension Attributes.
📄️ Using Custom Empty Members for Levels and Attributes
The Custom Empty Member functionality allows fact data with NULL or invalid foreign key values to be isolated and independently aggregated from fact records with valid foreign key values. Because fact records with invalid foreign keys are aggregated separately from records referencing valid dimension members, analysts can easily spot data integrity problems and further investigate them.
📄️ Working with Slowly Changing Dimensions
Slowly changing dimensions (SCDs) are used in business intelligence to track how dimension data (like a customer’s address or a product's category) changes over time. Instead of overwriting old values, SCDs keep historical records. This allows analysts to see what data was available at the time of the transaction, which is critical for audit trails, machine learning, and accurate reporting.