Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

One to many Relationship Issue in Cube

Status
Not open for further replies.

bhags

IS-IT--Management
Apr 5, 2004
8
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top