0
Feb 20, 2013 at 08:26 PM

# Webi: Bex Query with Structure not displayed correct in Webi (through BICS)

235 Views

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.2012
03.2012 Period ..... Revenue 100 150 ... ... Costs 50 60 ... ... EBIT 10 12 ... ... ....

See 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.

1. Horizontal Axis in Cross table:
1. Uses the Dimension object of “Fiscal year/period”
2. Vertical Axis in Cross table:
1. Uses the Dimension object of “PL Structure for Webi” --> This is my Structure in BEx that is displaying the different Reveues, Costs etc
3. Body Axis in Cross table:
1. Uses the Dimension object of the Measure “Acutal PL”

Result:

Data in Webi report is displayed in a strange format:

• Strange and different format is used for the Measures figures:
• 3.504454949E7 à Should be 35 044 540 NOK
• 5485219.86 à is 5 485 220 NOK

See attached picture (Webi - First Attempt) for result in Webi

Second Attempt

I'm using a Cross Table to display data.

1. Horizontal Axis in Cross table:
1. Uses the Dimension object of “Fiscal year/period”
2. Vertical Axis in Cross table:
1. Uses the Dimension object of “PL Structure for Webi” --> This is my Structure in BEx that is displaying the different Reveues, Costs etc
3. Body Axis in Cross table:
1. Uses the Formatted Value of the Measure “Acutal PL”

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

Attachments

Bex Query.jpg (68.0 kB)