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 (ключ)

     

    DimStructura

    Dimension

    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

    For example

    TableAndDepartment

    I figured out where my mistake was

    In the Cube, the Dimension Usage partition was not linked

    DimStructura

    • This topic was modified 2 months, 3 weeks ago by  ElviraD.
    • This topic was modified 2 months, 3 weeks ago by  ElviraD.
  • Thanks for posting your issue and hopefully someone will answer soon.

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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply