Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
53
Views
1
Comments
Joe_obieeoas
Joe_obieeoas Rank 5 - Community Champion
edited Aug 13, 2024 7:21PM in Oracle Analytics Cloud and Server

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.

Answers

  • Federico Venturin - Oracle
    Federico Venturin - Oracle Mod

    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.