Use biserverxmlexec - see more info in this article here: https://www.rittmanmead.com/blog/2016/12/source-control-and-automated-code-deployment-options-for-obiee/

Fusion Middleware Migration Guide for Oracle Business Intelligence: https://docs.oracle.com/middleware/1221/core/BIMIG/toc.htm (via http://lmgtfy.com/?q=obiee+12c+migration, top hit)

They're separate product versions. Either you're on 11g, or you're on 12c. If you're on 12c, you migrate your 11g RPD to 12c, and then work with it there.

I'd use Agents, like @Gianni Ceresa says, but I would trigger them not on a schedule but directly from your ETL. You can read more in an answer I wrote to a SO post a while ago: oracle11g - Event/ETL based Agent in OBIEE 11g - Stack Overflow

Take the Logical SQL from the report, and you can parameterise it to your heart's content. Then run it through nqcmd, or indeed any automation interface that supports ODBC or JDBC calls into the BI server. Or there are also Web Services as well.

I tried to idnetify and tune long running jobs, And what was the result? Did you identify the stages that were taking the longest to run? the data has grown so large that it takes weeks to complete the load. Yes, you mentioned that already. I don't see the relation to profiling the load steps though. we have to add extra…

Have you tried profiling the execution to identify which steps are taking the longest to complete? From there you can start to identify the reasons. Without that, it could be anything really.

What's your question? How to implement security in OBIEE? Use Application Roles, and assign permissions to the subject area and dashboards accordingly.

Did you check the docs, https://docs.oracle.com/middleware/1221/biee/BIEIT/bi_server_web_services.htm#BIEIT3253 Maybe run NQSQueryMetadataObjects first and base your call to NQSModifyMetadata on the response from that? Share what you've tried so far, and we can help out

Have you configured your RPD to read from the correct DB & Schema that you loaded the data to?

That's strange that the physical query should take much longer. Are you using the same DB user? Running the comparison SQL*Plus from the same machine as OBIEE? What kind of load is your BI Server under at the time? How much data are you pulling back in the query? You mention "which is hit multiple times" -- how many…

Are you using BI Server caching? If so, have you purged the cache since your data load?

If you've a specific question, please ask. Otherwise, here are the docs for you to go and find out the step by step info: https://docs.oracle.com/middleware/11119/biee/docs.htm

Are you talking about BI Publisher data model? If so, try forum

OBIEE 12c no longer pre-creates the LDAP group/application role mapppings. AFAIK BIConsumer is still present in the Starter and SampleAppLite BAR deployments. Have you created/mapped the LDAP group of your desired read-only user to the application role in EM?

No. It's either consistent, or it's not.

+1 to @Gianni Ceresa -- SampleApp is awesome, having the whole VM is only ever a benefit!

If you're setting up an Oracle BI DSN, you don't want to be putting the Oracle DB port in there - that *will* throw an error

Your OBIEE server isn't running, or you've not put the correct server details in for your DSN.

I continue receiving an error How To Ask Questions The Smart Way