Hi:
I am having a unique problem. Hi:
I am having a unique problem. This has to do with 0PROFIT_CTR which has a componding char 0CONTROLLING_AREA.
This is what i have in the Cube:
Controlling Area/Profit Center Amount
0001/100000 1000.00
0001/200000 1000.00
0002/100000 2000.00
0002/200000 2000.00
#/1000000 3000.00
#/2000000 3000.00
This is what i require as the output in the query:
Profit Center Amount
100000 6000.00
200000 6000.00
but this is what i am getting in the query:
100000 1000.00
100000 2000.00
100000 3000.00
200000 1000.00
200000 2000.00
200000 3000.00
I have brought in Controlling Area into the query marked it "No Display".
Can anyone let me know how to get the desired result without having to modify the Cube,
Thanks
EmJay