Folks,
We are facing this typical problem with the cube design. we have the sample design as follows
Fact Table
fact1
——-
contentkey
monthkey
views
Contentdim
———–
contentkey
Title
Confidentiality
Keyworddim
————–
Keywordkey
Name
Contentkeyworddim: one to may bridge table for contentdim and keyworddim. That is contentkey might have multiple keys.
——————
contentkey
keywordkey
Views column in fact table is a measure and when selected a criteria it should show the correct sum. But in case of all selection, it doubles the sum, because we have multiple contentkeys in contentkeyworddim. So how to deal with this. We want only one dimension for keywords, on selection of which it should calculate the correct value. What is the ideal solution
Is there any option in Microsoft Analysis Services using which we may get the solution