Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Mlutiple level facts help

Status
Not open for further replies.

rayishome

Programmer
Oct 20, 2011
1
US
Have a fact table i'm building that 95% of the facts roll up from the lowest level, but I have a few facts that can not be obtained the the lowest level. For example I have System and Sub System dimensions. All facts are at the Sub System level and roll up to the System. However, I have a few rare facts that are only avaible at the System Level. Past designs we have added a fact record for the system and added the fact, this way when we build a cube we can have all of the data in one spot. Is this ok and if not how should this handled?

Thanks
 
I assume System and SubSystem are in a single dimension called System. For each System, add a dimension member for "No SubSystem." Connect your facts at the System level to these.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top