Webi report show different data than query returns

[former_member585177]

Hi!

I never had a situation like this. I build simple report with 1 measure.

I ran the report and after 3 min, Webi returned result, but with a really strange values.

For each row, report show value 1 on measure column.

I copied the query and I ran it in Toad. Toad returns different data than Webi, but it is correctly.

I noticed very strange thing in Webi. Please look on attached image (1.jpg). Image shows result on "Read" tab. But when change tab to "Data" tab (2.jpg) then I see correctly result. (the same like Toad)

Can somebody tell me, where did this difference come from?

1.jpg2.jpg

[amitrathi239]

it's look like measure column is based on the report variable? if yes then share the details of variables..

[former_member585177]

Nope. I haven't created any report variable. I just drag and drop dimensions and measure from business layer directly.

[mhmohammed]

How many pages of data do you see in the report? We see a measure value of 7691 in the 2nd image, do you have sum() function used on the measure object in the Universe and do you also have its projection set to Aggregation?

I'd suggest you to filter the data you're bringing in the report, for 1 specific product and start working. And, please try to explain the issue better, it's really hard to figure what's the issue.