none
Performance calculated measure

    Question

  • hello, I created an accounting cube with two calculated fields to the accounting statement of accounts:

    Account Balance - Field Name = ([Measures].[Saldo])
    ([Measures].[Saldo Anterior] + [Measures].[Debito] - [Measures].[Credito])

    Previous Account Balance - Field Name = ([Measures].[Saldo Anterior])
    ([Measures].[Saldo], [Calendario].[Data Calendario].CurrentMember.PREVMEMBER)

    to do the following query, the performance accounts for 70 per annual period, destroys the performance.

     SELECT NON EMPTY 
     { 
    [Measures].[Saldo Anterior], 
    [Measures].[Debito], 
    [Measures].[Credito],
    [Measures].[Saldo]
     } ON COLUMNS, 
     NON EMPTY 
     { ([Calendario].[Data Calendario].[Mes].ALLMEMBERS * [Grupo Contabil].[Grupo Conta].[Level3ID].ALLMEMBERS * 
    [Conta Contabil].[Conta Contabil].[Conta Contabil].ALLMEMBERS * [Conta Contabil].[Id Conta].[Id Conta].ALLMEMBERS * 
    [Plano Conta].[Plano Cod].[Plano Cod].ALLMEMBERS ) 
     } 
     ON ROWS 
    FROM [BIPORTALDW_Contabil]

    I would like some help for this issue?

    • Edited by Suburbio Thursday, September 04, 2014 6:56 PM
    Thursday, September 04, 2014 6:41 PM

Answers

All replies