3 Replies Latest reply on Nov 16, 2012 6:26 PM by 950654

    SUMARIZACION THE ACCOUNTS THE DIFERENTS CUBES

    950654
      hello good day

      I have a script that olap charge with the following:

      MT_DIM_CUENTA LIMIT TO '111000000000 '
      MT_DIM_CUENTA LIMIT TO BOTTOMDESCENDANTS
      MT_IND_GL_MET_STORED (MT_DIM_INDICADORES '1 ') = MT_GL_STORED

      MT_GL_STORED cube extract the account value '111000000000 'and step the value to my indicator 1.

      Now my problem is when I need to extract another account and add them to this indicator.

      ie:

      MT_DIM_CUENTA LIMIT TO '111000000000 '
      MT_DIM_CUENTA LIMIT TO BOTTOMDESCENDANTS
      MT_IND_GL_MET_STORED (MT_DIM_INDICADORES '1 ') = MT_GL_STORED

      MT_DIM_CUENTA LIMIT TO '112000000000 '
      MT_DIM_CUENTA LIMIT TO BOTTOMDESCENDANTS
      MT_IND_GL_MET_STORED (MT_DIM_INDICADORES '1 ') = MT_DD_GL_STORED

      If the script also run in the example of arriva, my indicator '1 'only brings the value of the account '112000000000'.


      How do I run the scrip with the two accounts together and if I make the sum of the accounts of two different cubes to my indicator '1 '


      Please helpme

      Edited by: 947651 on 15-nov-2012 11:17