Skip to Content

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

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Feb 21, 2013 at 11:05 AM

    Hi,

    what is the InfoObject data type of Actual PL?

    regarding your first attempt:

    I believe BW is calculating "Actual PL" with high precision, that would explain the scientific notation. In a first step, format this number in Webi to display with less decimals. In a second step after you are happy with the results, concatenate with the currency.

    regarding your second attempt:

    The formatted value is a Text which will not always aggregate correctly.

    Best regards,

    Victor

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 22, 2013 at 02:06 PM

    hi Oddmar

    my suggestion wud be"

    1> right click on the cell body where you have the keyfigure values..then you will get an option called as "Format Number" ..

    2>click on "Format Number" and go to "Number" option and select you type you want to see in your report.

    3> Do one more thing right click on the cell and go to "Format Cell" make it "AutoFit Width" and "Autofit Height".

    Hope this will make it work...

    Cheers

    Jammy Z

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Oddmar Lid

      Hello Oddmar,

      go ahead and copy the query, in this new test, start with only one key figure in the charachteristics structure, you will see that the number is coming as a number then. After this, start adding key figure one after another until you find the one that damages the numbers and turns them to strings.

      Im quite confident that this will help you forward. Please post your findings after doing those steps.

      Best regards,

      Victor

  • Posted on Jun 09, 2014 at 08:17 PM

    Hi Victor,

    I am not sure if that will be the case. My webi report is over a BEx query where in there is a structure in the BEx query. And I am getting the exact same issue. In my case if I go to the edit query and look at the measure data type then I find that their data type is string and the aggregation is set to delegated.

    I have never come across this issue before.

    Oddmar,


    How did you manage to resolve this issue?

    I have worked with BEx queries with structures before but never faced this issue. I am using BO 4.1 SP03

    Regards,

    Tanisha

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.