Question:
Hi all,
In query, I want to get the TOTAL result like below, how to do that ? Please help.
Char1 Char2 Char3 KF1
C1 1 O1 10
C1 2 O1 10
C1 3 O2 30
------
TOTAL 40
C2 1 O1 10
C2 2 O2 10
C2 3 O3 30
------
TOTAL 30
C3 1 O1 10
C3 2 O1 10
C3 3 O1 30
------
TOTAL 10
Thanks.
Answer:
Correction :
Char3 only summarized once for the same value.
Char1 Char2 Char3 KF1
C1 1 O1 10
2 O1 10
3 O2 30
------
TOTAL 40
C2 1 O1 10
2 O2 10
3 O3 10
------
TOTAL 30
C3 1 O1 10
2 O1 10
3 O1 10
------
TOTAL 10
Answer:
Just 1 question before trying to answer :
Are you sure that for, for instance, O1 value will always be 10 for all Char2 ?
Can it be :
C1 1 O1 10
2 O1 20
??
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.
Tuly Idiot's fan club active member.
Answer:
First watch point is maybe to create an exception aggregation on the char3 at KF level if possible, or on a calculated KF in the cube.
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.
Tuly Idiot's fan club active member.
Answer:
Hi, thanks for reply.
Yes, for your question O1 always be 10 for all Char2. We have tried to use aggregation on Char3, it works for C2 and C3, but not for C1.
Pls advise.
Answer:
Hi,
What we need is a summation with exception aggregation. However the exception aggregation only works for the non summation, such as counting all values, etc.
Fred, What do you mean by calculated KF in the Cube ?
I still wait for any idea,input, or solution...
Pls help.