Hi all,
I have created a BEx query that uses a PL structure to display Revenue, Costs, Margins, EBITA, etc.
I want to display the PL structure in Rows, Fisical Period in Columns with Key Figure Actual.
PL structure 01.2012 02.2012See attached picture (Bex Query) for how query is built up.
When using this query in Webi (through BICS), I'm not able to display the desired results.
The problem is as follows:
First Attemp:
I'm using a Cross Table to display data.
Result:
Data in Webi report is displayed in a strange format:
See attached picture (Webi - First Attempt) for result in Webi
Second Attempt
I'm using a Cross Table to display data.
Result:
The same numbers is displayed for all periods (this is the sum of all periods)
See attached picture (Webi - Second Attempt) for result in Webi
Please also see attached document for screen shot of the results in the Webi report:
"Question regaring BEX Structure in Webi"
Does anybody know why this happens and why the Key Figures from the Query is not displayed correct in Webi?
regards
Oddmar