Relationship between dimension and measures

• ElviraD

  Old Hand

  Points: 331

  More actions

  December 10, 2023 at 9:21 am

  #4343219

  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.

  

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

  For example

  

  I figured out where my mistake was

  In the Cube, the Dimension Usage partition was not linked

  

  • This topic was modified 1 year ago by  ElviraD.
  • This topic was modified 1 year ago by  ElviraD.

• Site Owners

  SSC Guru

  Points: 80325

  More actions

  December 11, 2023 at 10:10 am

  #4343806

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.