3 Replies Latest reply: Nov 16, 2012 12:26 PM by 950654 RSS

    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
        • 1. Re: SUMARIZACION THE ACCOUNTS THE DIFERENTS CUBES
          950654
          Please Helpme
          • 2. Re: SUMARIZACION THE ACCOUNTS THE DIFERENTS CUBES
            Nasar-Oracle
            I don't fully understand your question.

            What is the dimensionality of MT_GL_STORED, MT_DD_GL_STORED and MT_IND_GL_MET_STORED ?

            You can do FULLDSC command for each one and paste it here. Maybe then we can understand it better.
            • 3. Re: SUMARIZACION THE ACCOUNTS THE DIFERENTS CUBES
              950654
              Hello good day

              The two cubes are dimensionality account. What are mt_gl_stored and mt_dd_gl_stored

              Each cube has different value.

              I have a third cube called MT_IND_GL_MET there where I want it this the result of the sum of these two accounts.

              example:

              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


              As you would do to extract the account value '111000000000 'the cube of MT_GL_STORED and account value '112000000000' the cube of MT_DD_GL_STORED and that the sum of the values are in my indicator 1.