Relationship between dimension and measures

Question

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

• MenuId
• OptionId2(key)

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

Answer 1

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

enter image description here