Skip to Content
avatar image
Former Member

WebI report returns incorrect data...

Hello Experts,

I have created an OLAP Universe on top of the BEx query and no issues with the Universe. However when I build the webi query on top of the universe, it's returning incorrect data. Looks like it's doing cartesian join.

For example I created a BEx query on the following fields...

. Course Code

. Course Comp Date

. Course Taken By

. Status

For a given course BEx query returning the data correct when run it via BEx analyzer. However when I try to reproduce the same query it's returning course code data for all the dates and for all people.

It's kind of cartesian join between "course taken by" and "Course comp date".

I would greatly appreciate any help. And also detailed information L00 and L01 stuff also would be appreciated.

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    May 27, 2009 at 03:48 AM

    Hi Padma,

    Usually it not supposed ti be happen.

    Please let me know you are fetching which objects. In webi you should fetch the L00 objects ?

    Basically L00 and L01 represent the hierarchies level.

    try with the L00 object and let me know the result.

    thanks

    Add comment
    10|10000 characters needed characters exceeded

  • May 27, 2009 at 02:16 PM

    Hi Padma,

    are you including any keyfigures into the query panel for Web Intelligence ?

    thanks

    Ingo

    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      when you including a measure you asking for the data from the cube that also has a measure.

      when you do not include a measure you basically asking the cube to return the data without having to worry about the measure - which means you kind of running a report that shows master data

      Ingo

  • avatar image
    Former Member
    Jul 22, 2009 at 04:28 PM

    Has this issue been resolved? We have a similar problem.

    Background: BOE XI 3.1 FixPack 1.5

    Universe based on BEx query over a Multiprovider

    BEx query returns correct results

    WebI results are inflated (in our case 11x).

    Interesting note. All our universes are built based on BEx queries over Multiproviders, but this doesn't problem isn't consistent. Also interesting is that the WebI results are correct in WebI Rich Client on a pc that has not yet had Fix Pack 1.5 applied.

    Any thoughts would be greatly appreciated!

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Please check the SAP BW/BI systems Support pack level, There are a set of SAP notes to be applied to the BW/BI system

      after which the issue may get resolved.

      For further details please go through OSS note: 1478176

      Regards

      Dhiraj Wamanacharya

  • avatar image
    Former Member
    Nov 03, 2009 at 09:03 AM

    I am also facing the similar issue . My data in Bobj report is getting multipleid by 11 in every record.

    I check the data in Bex with same objects and filters same as in report, the output is coming correct.

    Did anyone able to solve the similar problem ? Please suggest..

    Thanks,

    Mohit Garg

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Eric,

      This sounds like the bug ADAPT01234509, where the first digit of any key figure is being duplicated in Web Intelligence if it comes from a BW data source. Please see Note 1363136 for further information.

      In short, you'll have to apply a patch on your Business Objects installation to resolve this bug.

      Regards,

      Ilse