Analysis Using Last_Aggregate Returns Diffferent Results After Upgrade To Oracle Analytics Server (OAS)
(Doc ID 2902685.1)
Last updated on OCTOBER 14, 2022
Applies to:Oracle Analytics Server - Version 18.104.22.168.211223 and later
Oracle Analytics Server on OCI Marketplace - Version 5.9.0 and later
Information in this document applies to any platform.
After migrating a snaphost from Oracle Business Intelligence (OBI/OBIEE) 22.214.171.124 to Oracle Anallytics Server (OAS) the SQL that is now generated is different between versions and thus it is leading to different results
More specifically the OAS BI server is ignoring the aggregation rule last_Period as defined in the data model repository (RPD) for the date dimension and this causes a different query output.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document