multi to multi relationship with multiple business view.

View previous topic View next topic Go down

multi to multi relationship with multiple business view.

Post  abyss on Mon May 27, 2013 4:40 am

Hi
i am new for dimensional modeling. we have a problem for our survey dimensional model design:

each question we have category, theme and sub-category.

each themes can only belong to one category, and different sub-categories can belong to more than one themes and vice versa (multi to multi relationship). the problems is different department can have different 'theme to sub-category' mapping rule.
for example:
for dep1 the theme - sub-category mapping is like this
theme1 subcat1
theme1 subcat2
theme2 subcat1

for dep 2 the theme - sub-category mapping is like this
theme1 subcat1
theme1 subcat2
theme3 subcat1

the dimension model should provide different 'theme - sub-category mapping' views to different departments. so in dep1's view, subcat1 belongs to theme1 and theme2 and for dep2 the subcat1 belongs to theme1 and theme3
we have at least 10 different departments they may all have different mapping rules on this.

i know we need to fix the multi to multi relationship in fact table, but i just don't know how to do it.

any help?
thanks
Howard

abyss

Posts : 8
Join date : 2013-05-27

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum