I have a report that runs off a direct database request SQL. The report contains a pivot table with 5 measures, I find that the pivot table is generating an extra 13 records but when I run the query from nquery log in the backend database the 13 records do not appear. I was expecting the same output in the report as the database.
The report also contains 3 presentation variables that are passed in a dashboard prompt.
Can anyone help understand the possible causes of the extra records?