Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 42 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 277 Oracle Analytics and AI News
- 54 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 19 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Upgraded from OBIEE 11.1.1.5 to 11.1.1.9
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
-
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.
0