Hi,
Sorry for my bad english.
I need your help with case when in olap package
When im using a rolap package and i want to make a new value, i can do this :
CASE
When [COUNTRY]='USA' THEN '01'
When [COUNTRY]='FRANCE' THEN '02'
ELSE 'OTHERS'
END
If i make a list with this value and quantity i have the sum of quantity for each 01, 02 and 'others'
It's fine !
But if i do the same thing in olap package (cube) the result is wrong.
I have only on value for 01, 02 and 'others' not the sum. (probably the last value)
How can i do to have the same résult like rolap ?
Thanks for your help.
Hi Vincent,
How is this being used? Is it to generate row/column values in a crosstab (or chart)?
If so, just drag in the first two members from the package tree (USA and France), and add a query calculation for the Others with the following expression:
aggregate(currentMeasure within set except([Your Country Level],set([USA member],[France member])))
Regards,
MF.
Thanks for your help.
I solve my problem more simply.
I made à new value with the mesure i need and change the aggregate function to sum.
Vince.