none
Parent-child Hierarchy in many to many relationship RRS feed

  • Question

  • Hi!

    As the custom rollup is not available in tabular I was trying to build a hierarchy to see some data at least. My table structure is:

     

    Dim.Account Schedule<-------Fact.bridge_AccountSchedule----->Dim.Accounts<---------Fact.G/LEntry

     Here is an image (in spanish) if what I just explained:

    I think the result as you can see doesn’t work (see picture), it shows the blank values when browsing the hierarchy (I did for another dimension and it worked) so I think its because the fact.brid_accountSchedule, probably is not working because of that.

     

    Here are the measures (I translated to English so you can understand it better):

     

    Mindepth:=MIN(Esquema_Cuentas[PathDepth])

    Navigated:=IF(ISFILTERED('Esquema_Cuentas'[Nivel10]);10;

    IF(ISFILTERED('Esquema_Cuentas'[Nivel9]);9;

    IF(ISFILTERED('Esquema_Cuentas'[Nivel8]);8;

    IF(ISFILTERED('Esquema_Cuentas'[Nivel7]);7;

    IF(ISFILTERED('Esquema_Cuentas'[Nivel6]);6;

    IF(ISFILTERED('Esquema_Cuentas'[Nivel5]);5;

    IF(ISFILTERED('Esquema_Cuentas'[Nivel4]);4;

    IF(ISFILTERED('Esquema_Cuentas'[Nivel3]);3;

    IF(ISFILTERED('Esquema_Cuentas'[Nivel2]);2;

    IF(ISFILTERED('Esquema_Cuentas'[Nivel1]);1))))))))))

     

    Amounts:=IF([Navigated]>[Mindepth];BLANK();[AcSums])

    AcSums:=CALCULATE(SUM([Amount]);SUMMARIZE(Bridge_AccountSchedule;Accounts[TableID]))

    Thanks for your help!






    • Edited by the_txeriff Thursday, November 22, 2012 2:30 PM
    Thursday, November 22, 2012 2:23 PM

Answers

All replies