Skip to Content
avatar image
Former Member

Difference in Report and SQl

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Nov 03, 2016 at 03:38 PM

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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • Nov 03, 2016 at 04:27 PM

    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)

    Add comment
    10|10000 characters needed 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