When you are developing your fact groups, it is critical that you make sure you have clean, single grain fact groups. This means that there is only one level of detail represented from each dimension that is applicable to these facts. If you will have fact table rows that represent different levels of detail, such as daily and weekly, you need to split these into separate fact groups.

One situation that you may come across is that you have some fact rows in which one or more dimensions do not have corresponding values. This is a violation of the referential integrity between the dimension and the fact table. Your first response should be to conduct further detailed research. Ask the following questions:

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access