Skip to Content
0
Jan 15, 2008 at 09:32 PM

Compounding Characteristics

29 Views

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