Multivalued Dimension or Multiple facts w/conformed dimensions
2 posters
Page 1 of 1
Multivalued Dimension or Multiple facts w/conformed dimensions
I am trying to model for insurance industry, with data as follows:
We have data at different levels:
Policy level with related facts. ((Premium , face amount, mode etc)
Policy Fund level (combination with related fact values.)
Policy Rider level (combination with related fact values.)
Now, should I create:
1. Policy dim, policy status dim, product dim etc... along with policy fact.
2. Policy dim, Fund dim, Policy Fund Details Fact
3. Policy dim, Rider dim, Policy Rider Fact.
How would I build a multivalued dimension for the above combination? Is there pros/cons in using either of these two approaches.
Please let me know.
We have data at different levels:
Policy level with related facts. ((Premium , face amount, mode etc)
Policy Fund level (combination with related fact values.)
Policy Rider level (combination with related fact values.)
Now, should I create:
1. Policy dim, policy status dim, product dim etc... along with policy fact.
2. Policy dim, Fund dim, Policy Fund Details Fact
3. Policy dim, Rider dim, Policy Rider Fact.
How would I build a multivalued dimension for the above combination? Is there pros/cons in using either of these two approaches.
Please let me know.
sr_da- Posts : 14
Join date : 2009-10-19
Re: Multivalued Dimension or Multiple facts w/conformed dimensions
If you have the three fact tables, why would you need a multivalued dimension?
Similar topics
» Modeling multiple multivalued dimensions and other design questions
» Multiple Fact table with different grain w/conformed dimensions - BO Challenge
» Facts Tables linking to different granularity of a Conformed Dimension
» Actual and Plan Facts at different granularity - one conformed dimension?
» Conformed Dimension Processing Multiple Data Marts
» Multiple Fact table with different grain w/conformed dimensions - BO Challenge
» Facts Tables linking to different granularity of a Conformed Dimension
» Actual and Plan Facts at different granularity - one conformed dimension?
» Conformed Dimension Processing Multiple Data Marts
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum