Skip to Content
0

Difference in Report and SQl

Nov 03, 2016 at 03:04 PM

69

avatar image
Former Member

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
Former Member

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

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
Former Member
Kuldeep Ghosh

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
Former Member

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