Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Multiple fact tables
0 views
Skip to first unread message
rdg0753
Oct 10, 2008, 5:19:44 PM10/10/08
to
Hi,I am new to Analysis services. I have to generate a cube with about
300 dimensions. Should I store all the dimension attributes in one
fact table or break it down in multiple fact tables since some of
them have a lot of nulls? In my example I have 300 different
attributes of a customer like age,gender,income etc....and the only
measure on the fact table is "Customer counts". I want the ability to
see a cross tab between any two attributes (example age vs gender
etc). If I do break the the 300 column fact table in multiple tables
then how will the relationships in dimension usage tab look like?
Please advise. Thanks in advance.
300 dimensions. Should I store all the dimension attributes in one
fact table or break it down in multiple fact tables since some of
them have a lot of nulls? In my example I have 300 different
attributes of a customer like age,gender,income etc....and the only
measure on the fact table is "Customer counts". I want the ability to
see a cross tab between any two attributes (example age vs gender
etc). If I do break the the 300 column fact table in multiple tables
then how will the relationships in dimension usage tab look like?
Please advise. Thanks in advance.
0 new messages