When specifying dimensional information in FM it is important to understand the
following.
• What are the levels in your dimension?
• What is the order and combination of levels that form hierarchies.
• How do you uniquely identify the members of a level, is it unique (one
query item) or does it require multiple query items?
• Association of levels with attributes and measures.
• At what level of granularity is your fact data, do you have more than one
level of granularity? Ie. Is some of your data recorded monthly and some
daily, this would mean that you would have a fact tables relating to your
time dimension table at the month and day levels.
• Are there surrogate keys defined in your data source?
