Add Existing Dimension
If you want to provide additional context to facts, you can create your own dimension and join to an existing available column in a fact.
For example, if you want to report on invoice categories, create a dimension
called "Invoice Category" and join to a column in the fact that has that information. It
is important to remember that one dimension record must join to one or more fact
records; it should be a 1-many join. You shouldn't have many to one or many to many
joins between a dimension and fact table.
- On the Logical Star – Fact page, click Manage Dimension, and select Add Existing Dimension.
- In Add Table, select the dimensions to add.