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

Upgraded from OBIEE 11.1.1.5 to 11.1.1.9

Received Response
1
Views
1
Comments
5cc80da0-88f8-407d-8234-913f2de0293e
5cc80da0-88f8-407d-8234-913f2de0293e Rank 1 - Community Starter
edited Aug 13, 2024 6:11PM in Oracle Analytics Cloud and Server

One of the issue we are facing post the upgrade that different physical queries are getting generated in both the version causing the data mismatch. What can be possible difference that Server is generating different logical columns. These are happening in aggregation dervied columns.

Answers

  • rmoff
    rmoff Rank 6 - Analytics Lead

    Either:

    1) Your RPD is not modelling sufficiently robustly, and the change in version has caused OBIEE to pick a different execution path for your queries that results in different data

    2) Your RPD is perfect, but you have hit a bug in the newer version of OBIEE. In which case, raise an SR to Oracle.

    In the clear majority of cases, it's number (1). Your RPD worked beforehand, but only because you were lucky. Take a look at the differences in the SQL being generated, and work it back from there. Work it back to the logical model and understand why the BI Server would be behaving how it is; and then modify the RPD to rectify that.