I have a built a BEX query, in which the standard InfoObject 0COSTELMNT (cost element) is displayed in the rows. 0COSTELMNT is obviously compounded with 0CO_AREA (Controlling Area).
Now when I execute the query, the cost element is displayed in the report showing the combination of 0CO_AREA & 0COSTELMNT. For e.g. the report displays the cost element 100000 as "1000/100000" where 1000 is the controlling area & 100000 is the cost element.
However I would like to display JUST "100000" & NOT "1000/100000".
Does anybody know how to achieve this???
Strangely, I have queries running out of another cube using the same InfoObject 0COSTELMNT and in these queries the cost elements are displayed just the way I would like to see it i.e. "100000".
So I am a little confused why BW displays the same InfoObject differently in different queries.
Thank you in advance for your answers.