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

SUMARIZACION THE ACCOUNTS THE DIFERENTS CUBES

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 '

Edited by: 947651 on 15-nov-2012 11:17
• 2. Re: SUMARIZACION THE ACCOUNTS THE DIFERENTS CUBES
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
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.