CODEWITHSUNDEEP
ssasolapmeasuredimension
Elvira Delman
Elvira Delman

Reputation: 11

Relationship between dimension and measures

There is a Fact Table (.....,MenuID, MOption, CallTime) There is also a Dimension "Menu" Table (MenuId,OptionID)

Relationship between these tables (MenuID and MOption)

In the Dimension table, I created another field - keyField (string(MenuID+MOption) as OptionId2)

when creating Dimension, I use the new key (OptionId2) and build the hierarchy accordingly

enter image description here enter image description here

but when I build a table with the Menu in the browser, my "Measures.CallTime" remains a constant number.

enter image description here

What am I doing wrong?

The Dimension Menu should work like any other Dimension in the cube

For example enter image description here

Upvotes: 0

Views: 34

Answers (1)

Elvira
Elvira

Reputation: 1

I figured out where my mistake was In the Cube, the Dimension Usage partition was not linked

enter image description here

Upvotes: 0

Related Questions