Pretty sure that's a documented & known limitation in the current release. Have you checked the docs/MoS? Out of (genuine) interest, do you have many XSA sources that are created prior to Production and need to be moved through? I guess my assumption was that most XSAs would be created either in non-production for…

This would be my starting point: https://www.rittmanmead.com/blog/2016/10/all-you-ever-wanted-to-know-about-obiee-performance-but-were-too-afraid-to-ask/

Out of interest, what research have you done so far into the error? On the forum we love to help people out, but it cuts both ways - you need to show you've put in some leg work already. That error is a massively common one. Have you gone to My Oracle Support, for example, to look it up? Or searched the forum history to…

http://catb.org/~esr/faqs/smart-questions.html#beprecise Expand the error message - what's the detailed error message? Check the Presentation Services and BI Server logs. You'll find the error, and probably the cause, directly there.

If you want closer to an answer, ask a more specific question and we'll try and help (unless it's about licensing, in which case ask Oracle ;) )

Do you just want to compare objects within a schema or the whole database? Or do just want to compare the differences between Oracle 11g/12c databases? @Gbenga Ajakaye BVT is an OBIEE tool. You can read more about it here:…

1) Can you use the tool to compare between 2 11g environments instead of between 2 12c or between an 11g and 12c environment? Yes, you can. 2) Do you need a specific licence to use the tool. eg.: Can it be used if you don't have a 12c licence but only a 11g licence? Good question. Probably one for your Oracle account…

You didn't answer my question (1) above. To your answer to my second question, the 'workaround' would be to use OBIEE as it's generally intended and build your data model such that analyses can be built automatically through the Answers interface. If you're having to resort to hacking together logical SQL you're either…

* How are you trying to execute it? * What's your use case? Why can't you build an analysis using the RPD as normal?

So for that I'd just use exportServiceInstance/importServiceInstance to switch back and forth between your deployment and the SR one.

The BAR file *doesn't* include config files. It's just security (policy store), RPD, and catalog. When you import the BAR manually (importServiceInstance) you can specify flags to include one or all of these content in the import. The BAR file can be unarchived using zip, so you can see for yourself what's in it.

Why? Why would you want to do this?

The obvious route is consultancy - you need both very business & communication skills, as well as very good technical knowledge. Other than that, probably systems design/architecture specialising with specific areas of tools, or industry-specific and broader toolsets. Caveat: 1. I've met great coders with 2 years…

Holding internal application data, including Usage Tracking, job scheduling metadata, and a lot more. They are not optional; even if analyses are running, your system will break/be unstable if the RCU schemas are unavailable.

Is there any way, when adding a dimension, to default all LTS to a specific logical level? Nope. As Gianni and Christian have said, a model this size is probably not the best approach in an ideal world. The only option you have is to look at a script-based approach. There is a supported API for modifying the RPD metadata:…

Just look in your database, e.g. Real time SQL monitoring https://oracle-base.com/articles/11g/real-time-sql-monitoring-11gr1 If you configure your OBIEE RPD you can see in Oracle which OBIEE users and dashboards account for what SQL being run on the database:…

Define it as a logical column in the BMM. https://lmgtfy.com/?q=obiee+unix+epoch First hit: https://thinkbi.wordpress.com/2009/01/09/converting-unix-epcoh-time-in-to-date-using-obiee/

WebLogic (which OBIEE installs against by default) performs both the roles of application server, and web server.

https://www.jamescoyle.net/how-to/1907-javascript-to-refresh-all-obiee-dashboard-analysis

what can be done? One or all of: - 1. Raise an SR to Oracle 2. Patch your installation to a more recent patchset for 11.1.1.7 3. Consider upgrading to 11.1.1.9 4. Use IE