Hi,
We have installed OAS 2023 but facing some issues and want to downgrade it to OAS 5.9.
Kindly suggest some steps to downgrade the RPD used in OAS 2023 to OAS 5.9
Thanks & Regards,
Lalit Bisht
You would require to Uninstalling and Reinstalling Oracle Analytics Server:
https://docs.oracle.com/en/middleware/bi/analytics-server/install-config-oas/uninstalling-or-reinstalling-product.html#GUID-3FC6A4E1-4684-4BAC-9760-DA308A114FE7
Hi @User_F707D ,
To downgrade the RPD you can use the nqgenoldverrpd.exe utility of the Model Administration Tool:
nqgenoldverrpd.exe -P RepositoryPassword -I PathToInputRepository -O PathToOutputRepository -V DesiredVersionNumber
The utility can be found in the following location:
%OA_CLIENT_HOME%\domains\bi\bitools\bin
@User_F707D ,
OAS 5.9 is out of support, why would you use that?
In another question you said :
We are doing one upgrade to OAS 2023 for OBIEE 11.1.1.7.0 to OAS 2023
Are you expecting OAS 5.9 to work with BVT? Still no, the tool is gone and wasn't developed for OAS at all.
You should look at fixing the issues, mostly because if you jumped from OBIEE 11.1.1.7 to OAS, there are more than 10 years of evolutions there inside and the tool changed a lot, mostly with RPD where developers took a lot of freedom at modelling things not in the correct way. The new versions got more and more strict and generate queries in a more predictable way (while with 11g it was possible to just be lucky that a weird model started generated the expected query).
Referencing your prior post
https://community.oracle.com/products/oracleanalytics/discussion/20699/bvt-tool-error-for-generating-result-for-oas-2023
Additionally, the starting point to migrate from OBI 11g is 11.1.1.9, not 11.1.1.7 ;-)
About the Starting Points for Migration and Upgrade -> Migrating from Oracle Business Intelligence 11g
Does Oracle Analytics Server 2026 include AI features such as a built-in chatbot or AI Assistant? If not, are there any plans or indications that these AI capabilities will be introduced in a future OAS release?
Here is my calculation CAST(COUNT(SAAR_ID) AS VARCHAR(50)) || ' SAARs pending as of: ' || CAST(CURRENT_TIMESTAMP(5) AS VARCHAR(50))
In OAC when I am creating a dataset, How can I pass a Filter from the "Dashboard filters to the SQL? I attached a image like it was don in BIP Publisher
How can you put a total number of records in your oracle OAC table footer
we have two seperate environments in air gap… 1- oas 2024 2- oas 2026 developers in both env, required extensions like push button, racing bar, guage…. where to download.
