General discussion

Locked

Implementing one to many relationship with Analysis Services

By bhagya.joshi ·
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

This conversation is currently closed to new comments.

0 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Back to Software Forum
0 total posts (Page 1 of 1)  

Related Discussions

Related Forums