Dimension Guidelines

Here are guidelines to keep in mind when working with dimensions in Advanced Relational Access:

Advanced Relational Access does not support recursive dimensions/hierarchies.
Alternate hierarchies in standard dimensions are not allowed.
Attribute dimensions are ignored.
User-defined dimensions are not supported.
When a dimension is enabled for relational storage, Integration Server builds only to the dimension level. All members of the dimension are accessed directly from the relational data source.
Accounts dimension must be created from the fact table.
For the accounts dimension, no hierarchy is supported. All members should be of generation 2.
Aliases are not supported.