Hi,
I'm having difficulty of calculating grand total of separated totals in crosstab based on DMR.
in the crosstab,
there are 3 groups in a hierarchy of [All-Region-Warehouse].
I've already created regional totals by using just dimensional edge summary for each region, children(A), children(B), and children(C).
but what i cannot go further is getting the grand total of children(A)+(B)+(C).
each total is dimensional edge summary and the dataitem is Total(children(A)) and etc.
i've tried the query calculation of Total(children(A)) + Total(children(B))+ Total(children(C)).
but, it failed with the error of "The dimensions on the edge are inconsistent. A dimension of valueSet="37" is not the leaf on the first path.".
Is there anyone who had faced the same issue and sorted out?
Please help me out of this problem.
Thanks in advance.
Hi,
Isn't it simply a matter of summing the A, B and C member measures? Or am I missing something?
You could try
A + B + C
Or alternatively
Aggregate(currentMeasure within set set(A,B,C))
MF