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

  • MenuId
  • OptionId2 (ключ)

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

Table Menu

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

In the Cube, the Dimension Usage partition was not linked