OBIEE 12.2.1.3 and OAS 5.9, same report in both environments but giving diff no of records

Question

Hi Gurus,

we have a simple tabular report with some filter conditions.  Originally report was built in OBIEE 12c , recently we built separate OAS 5.9 environments and this report is again built in OAS (everything between OBIEE and OAS versions like filters etc.  are same),   both are hitting same data source.  But when user runs the report,  in OBIEE shows count as 15,  and in OAS count we see is 22.   These counts are number of persons, so not a decimal value round up issue etc.

Wondering why OBIEE is filtering 7 people out when "everything" is same between both environments.

Any inputs please.

Thanks in advance.

Federico Venturin - Oracle · Answer

Hi @Joe_obieeoas ,

I would check whether logical and physical SQL are the same on both environments.

I suspect they are not the same, but once we know the difference it will be easier to find out a solution. Even if the analyses and the filters are the same, there could be small differences in the database features (RPD) or different configuration settings that affect query generation.