Forum Discussion

UHS's avatar
UHS
Helper I
1 year ago
Solved

Need help with relationship between two tables

Hi All, I am having two tables between which there is no relation plus there is no unique key to identify unique records. COls from table A to be used Year-Quarter Cost Centre OP_expense_Sub_...
Need Help
  • UHS's avatar
    UHS
    1 year ago

    Hi Everyone, 
    Thanks so much for your replies.
    I found the solution to my problem and here is what i did.
    I created a bridge table between these two tables and added al lth eunique cost centres there and then indivisually joined tables by oneto many relationship as
    Table A many to one relation with Bridge table and Table B many to one relation with Table A and make it active and also filter direction to be selected as both.
    Then createe 2 measures in the table 2 where i wanted to have the logic updated
     Following all these steps my issue gor resolved.

UHS's avatar
UHS
Helper I
1 year ago

Hi Everyone, 
Thanks so much for your replies.
I found the solution to my problem and here is what i did.
I created a bridge table between these two tables and added al lth eunique cost centres there and then indivisually joined tables by oneto many relationship as
Table A many to one relation with Bridge table and Table B many to one relation with Table A and make it active and also filter direction to be selected as both.
Then createe 2 measures in the table 2 where i wanted to have the logic updated
 Following all these steps my issue gor resolved.

  • v-dineshya's avatar
    v-dineshya
    Community Support
    1 year ago

    Hi UHS ,

    Thanks for the update and happy to know you have found a solution. Mark it 'Accept as Solution'. It may help others who may be in similar scenarios.

     

    Thank you.