Forum Discussion

maserr's avatar
maserr
Helper IV
6 years ago

SSAS measures with a master table

Hi there,

 

I have created some measures with SSAS and I have like a master table with these indicators that these measures are calculating. I want them to be related with its master table in SSAS so I could be able to have more information about this measure using this master table. What I find is that I am not able to put the measures in a table and then creating a relationship 1 to 1. Could this be possible?

 

Thanks

Need Help

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    Are you saying you want to create a relationship between tables using measures? If that is the case, you can't do that. You can only relate tables to one another using columns. Hopefully I have misunderstood.

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    The information you have provided is not making the problem clear to me. Can you please explain with an example.

  • maserr's avatar
    maserr
    Helper IV
    6 years ago

    Sorry, it is clear I have not explained myself enough. The question is that I have a dimension in the cube with some measures, that I want to identify with a code. At the same time I have a master table with those codes that provides me more information. Could it be possible to create this identifier and to relate it with the master table in order to access to the other columns I have on it?

     

    Thanks