webi report not matching the BEX query results

building reports webintelligence
1

Hi

I am facing the issue webi report results displaying wrong when
compare with BEX Query.I created webi report on top of BEX.
I am using xir4/I did not use any filters in webi report.I check connection name is also right.

Please suggest where it went wrong.

Thanks in advance

send2440 (BOB member since 2012-03-03)

2

Please give more details on “wrong”. Wrong can mean so many things.

3

Hi, I’m facing the same issue where Webi results do not match the BEx query results. The Webi report is built off the same BEx query.
The result in BEx is only showing one “PO Release Date” for this PO Number and PO Item No. In Webi there are two PO Release Dates for this same PO Number/PO Item No. The correct PO Release Date is 10/14/15 according to ERP system. However, the 09/24/15 was the old value. I am on BO4 SP9.1 [/img][/url]
10-26-2015 3-54-33 PM.png
webi results.png
webi query.png

iam757 (BOB member since 2011-08-17)

4

Right click, format table.

Uncheck:
Show rows for which all measure values = 0
Show rows for which the sum of measure values = 0

5

I’ve unchecked the boxes however, the row with the 09/24 Release Date still appears.

iam757 (BOB member since 2011-08-17)

6

That will be because you’ve got Net Price as a measure. It should be a Dimension. :slight_smile:

7

I removed Net Price from the query and kept the two boxes unchecked
(Show rows for which all measure values = 0 and Show rows for which the sum of measure values = 0). Now it is only showing one row with the 10/14 PO Release Date. Why should Net Price be a dimension if it’s a dollar value?

iam757 (BOB member since 2011-08-17)

8

Price is always a dimension as it means nothing when aggregated.

Mak 1 :uk: (BOB member since 2005-01-06)

9

Net Price is the Unit Cost and is used in calculations. The Order Value is the Net Price * PO Item QTY. If Net Price was a dimension then it would be an invalid data type to use in a variable.

iam757 (BOB member since 2011-08-17)

10

No it wouldn’t.

You can multiply a dimension by a measure as long as they are both numeric objects.
A measure * A dimension = A measure

20 items @ 10p = £2

15 items @ $4 = $60

Works fine, try it.

11

With all due respect, do you think I would have stated that if I hadn’t faced the issue, myself, before :roll_eyes:.

You are not the first person to work with Quantities and Prices :wink:

Mak 1 :uk: (BOB member since 2005-01-06)

12

Thanks. I’ll take this to the BW guys and ask them to change the Net Price.

It was strange to me because this is how this field has been in our environment for years and was never questioned before.

iam757 (BOB member since 2011-08-17)

13

People unfortunately assume all numeric fields are measures.

It would be the universe designer that changes the qualification, not the BW guys btw.

14

I’m not using a universe. This is a Webi report directly against a BEx query.

Does anyone know why Webi is showing more records than the BEx query? I’m trying to understand why Webi would show the 9/24 PO Release date when 1) It’s an old value 2) It’s not shown in BEx. Please help to explain this behavior for me. Thanks.

iam757 (BOB member since 2011-08-17)

15

In that case, ask your BEx developer to change the object qualification to a characteristic or an attribute.

Ask your Bex development team, they’ll know better than we will about the query at hand - there may be underlying SAP filtering taking place :slight_smile: