Below are some proven practices to follow when Specifying Dimensional
Information in Framework Manager
1. Ensure that keys and other identifiers have their usage specified as identifier.
2. When a surrogate key is available for a level use it as the level key and treat
the business key as an attribute.
3. Use the item you would use in reporting as the level and the id (forms one
end of a relationship) as the key for the level (remember to reflect this in the
prompt info for the sake of query efficiency).
4. For each level associate any query items whose granularity is specific to that
level.
