Skip to Content
0

Difference in Report and SQl

Nov 03, 2016 at 03:04 PM

68

avatar image

Hi all ,

I had created the universe and I used the Query from the universe in the SQL

report is getting 6999 Rows but when I run the same in SQL it is getting 7500 rows

please advise why there is difference in the report query and SQL

Thanks

Krishna

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Kuldeep Ghosh Nov 03, 2016 at 03:38 PM
0

is there any filter applied in the report which you are not applying on the SQL directly?

Show 3 Share
10 |10000 characters needed characters left characters exceeded

No i am not applying any filters to report it is the same universe SQL i had Pasted in SQL

i am getting different results Please advise

Thanks

Krishna

0
Mohan Krishna Seemakurthi

Can you check the properties of the query to see what is the value set on "Max Rows Retrieved"? Or there there is any limitation on the universe level?

0

the problem is with the data foundation layer when I copied the data foundation layer to new data foundation again it is normal now

thank you for your time

0
AMIT KUMAR
Nov 03, 2016 at 04:27 PM
0

how are you checking count in webi which is 6999?

count function on any object?

check with this formula in webi.

=NumberOfRows([Query 2]) (replace query 2 with your webi query name)

Show 1 Share
10 |10000 characters needed characters left characters exceeded

the problem is with the data foundation layer when I copied the data foundation layer to new data foundation again it is normal now

thank you for your time

0