Semantic Modeler and RPD coexistence in OAS

Question

Hello everyone,

I would like to ask a few questions about the use of Semantic Modeler in Oracle Analytics Server (OAS):

* When working in the Semantic Modeler, does the data model use the same file extension (.rpd) as the data model created in the BI (Model) Administration Tool?
* We already have a data model created in the BI Administration Tool and published online. When we created another model using the Semantic Modeler and deployed it, it replaced the existing model. Is it not possible to have both models published online at the same time and choose which one to use for our reports?
* Since we recently migrated from OBIEE to OAS, we would like to explore how the Semantic Modeler works. However, if publishing a Semantic Model replaces the existing online RPD, what is the recommended approach to test a Semantic Model without affecting the currently deployed data model?

Thank you

Gianni Ceresa · Answer

You come from OBIEE, nothing changed in OAS on how the RPD/Semantic Model is handled. In OBIEE you had a single RPD at any point in time, it's the same with OAS.

You can create multiple semantic models with the web-based Semantic Modeler in your single OAS, that's not an issue, but you should not deploy any of them if you have a RPD that was migrated and deployed and that most of your content is based on that model.

How where you developing on your OBIEE? I hope you weren't all working directly online and change the production RPD in real time on the server. Excluding this approach, anything else you were doing can be used with OAS as well.

From a more generic point of view, an option to make your life easier, could be to import your migrated RPD in the Semantic Modeler. That will now be your base model, and on top of it your developers can start working and pushing changed to a git repository and use merges there to "deploy" features into a reference semantic model.

Each developer will need their own OAS environment if they want to test their models and build analyses or workbooks.

All in all, just do what you were doing with OBIEE assuming your were not all working online on the deployed RPD. OAS didn't change anything on the process.

Ram-Oracle · Answer

Hi @Themis As per current architecture ,oas holds one rpd file to be deployed on to oas bi server for queries.Even with oas model admin desktop tool ,multiple developers working on their individual rpds and finally merge it to master reposistory using 3 way merge or via patching xml and final rpd will be deployed on to the oas server during cut-over or migrations to prod.

If two or more developers are working on different subject areas ,each subject area represents one data model and probably you could try multi user development like integrating with git repository.

Also previous thread on the same subject and see if it helps.

https://forums.oracle.com/ords/apexds/post/can-i-have-multiple-data-model-active-at-a-time-in-oac-2486#comment_323523248055079081396907050484361749313

Themis · Answer

Hello @Ram-Oracle ,

Thank you for your response — it was very helpful.

One observation from our testing: if we create reports based on different data models (for example, one built using the BI Administration Tool and another built using the Semantic Modeler), it seems that we must switch back and forth between data models by redeploying the corresponding .rpd each time.

This behavior feels somewhat limiting, as it prevents users from working with reports based on multiple data models simultaneously within the same OAS environment.