INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...I have tons of books, have book marked tons of tutorials, which have helped, but this forum has answered those "impossible to find" solutions. I am thrilled with this site..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Project and Data Management > Data Management Programming issues > Data warehousing general discussion Forum

Mlutiple level facts help

Read More Threads Like This One

rayishome (Programmer)

20 Oct 11 10:54

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

RiverGuy (Programmer)

25 Oct 11 8:43

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.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To Data warehousing general discussion