Active-Passive Model https://docs.oracle.com/middleware/bi12214/biee/BIESG/GUID-261C278C-EA9E-4BE5-9216-FEFED1418FE6.htm#BIESG3457

Quick way would be in the Admin Tool and in the Physical Layer, to right click on the physical schema for example and click on copy. Paste the content into your editor of choice and then search for the "TABLE TYPE SELECT DATABASE MAP" string. The SELECT statement should follow after this string.

Try BI Archive files - https://support.oracle.com/knowledge/Enterprise%20Performance%20Management%20and%20Business%20Intelligence/2067513_1.html

I may be missing something glaringly obvious but if all you need is OOTB prompts, why do you have to recreate these as ADF objects in JDeveloper?

@Gianni Ceresabeat me to it. What is your exact use case. Are you trying to do something above and beyond the OOTB OBIEE functionality?

The steps you need to follow in order to migrate your RCU can be found in this thread.

No worries. Happy to help!

Try the tool in the My Oracle Support portal

Take a look at this thread from yesterday although I would strongly suggest that a row limit of 1000000 is a bit excessive and I would think a discussion about the actual requirement might be something that needs to happen.

In 11.1.1.9, the save column formula as functionality was introduced: This screenshot from Peak Indicators shows you where to call it from

+1 to @Gianni Ceresa BI MAD has a subset of the functionality and as mentioned earlier, OBIEE is responsive and therefore the HTML5 pages are rendered correctly across all devices.

Take a look at this: https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=204681011861609&parent=EXTERNAL_SEARCH&sourceId=PROBLEM&… Although it is an 11g article, the same principle applies to 12g.

You should just be able to see the analysis on mobile without any rework as the pages are responsive and render properly on either device. Have you tried that?

Whar version are you running and also what do you mean by "clone"? Do you just need to make a copy?

Did you scan your catalog prior to creating your BAR file?

You'll need to create level-based measures.

I can see this: [nQSError: 17001] Oracle Error code: 942, message: ORA-00942: table or view does not exist at OCI call OCIStmtExecute. [nQSError: 43119] Query Failed: It looks like the DB user used to run this is missing permissions on some tables. What happens when you run this from your log directly in SQL Developer or…

You'll need to be a bit more specific. Have you looked at the query logs to see the error. Does the query run when run directly on the underlying RCU database?

I don't think @Christian Berg, @Robert Angel @Gianni Ceresa & @Thomas Dodds could be any clearer. Your first port of call should be the underlying data source as well as understanding the actual use case for the OBIEE analysis. It could well be that a data extract is what they're after

Thanks @Gianni Ceresa. You beat me to it again!