Skip to Content
avatar image
Former Member

Incorrect data retrievel in Query Panel with extra column on left most side

Hi All,

Can any one help me out in solving wrong data retrieval while executing.

Problem Description:

I have 8 dimension and 1 measure in Query Panel  Result Object and filter having Value Date prompt.

While executing this query. result shows wrong data. I mean data got duplicated not necessary all column cell contains record.

Universe level query shows exactly what I want but while putting dimension and measure of same query shows duplicate record in Webi due to which report shows wrong calculation.

I am using environment.

SAP BusinessObjects BI Platform 4.1 Support Pack 2 Patch 10

Version: 14.1.2.1435

Please help me out in solving this.

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 01, 2015 at 01:45 PM

    Hi,

    Check if "retrieve duplicate rows" option is selected in the webi query properties?

    Also recheck if "avoid duplicate row aggregation" option is checked in the right click->format table.

    Amit

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks Amit for your Reply. Just to update you that I was able to get solution by changing projection function in IDT for that measures which is used in report query. Default projection function was "Delegated" so I change it to "Sum"