You can probably achieve this using a mechanism from Linux like rsync as you mentioned to identify if any catalog changes have been made. See - Oracle Support Document 2067527.1 (OBIEE 12c: Quick Reference For Architecture, Lifecycle Management and File Locations) can be found at:…

you could use Data Visualisation and data mashup on the UT data and the extended UT data

You our can take a look at @Gianni Ceresa’s blog for guidance - https://gianniceresa.com/2016/12/deploy-custom-folder-obiee-12c-analyticsres/ Having said that, the blog is based on on premise OBIEE and there are a number of restrictions on OAC including limited server access as well as the likelihood of changes made on the…

Have you taken a look at the Oracle documentation - https://docs.oracle.com/middleware/bi12214/biee/BIEUG/GUID-1AE2825E-E5F1-461F-B5D8-EC4B74649015.htm#biee0137

What is your question? also, what version of OBIEE?

All OBIEE installations need to be on a server OS

Look at @Christian Berg's blog - https://dimensionality.ch/2017/05/06/installing-oracle-bi-on-windows-7-8-10/ Windows 10 is a Client OS and OBIEE is enterprise software which works with server architecture and therefore requires a server OS.

Yes. It’s standard practice to create logical dimensions and hierarchies for every dimension even if you only have a total and detail level. client and account dimensions should have content level of total in the payment fact.

Quickest way would be to enable OBIEE Usage Tracking and you can pick up DDR easily from there. https://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/bi1116/ut/ut.html

https://docs.oracle.com/middleware/1221/core/BIEIG/GUID-A51F5F97-5EA3-4D11-B5E0-9230F7EE2EA6.htm#INSOA468

Do you have logical dimensions with hierarchies defined? Your Client & Account dimensions are non conformed dimensions with the Payment fact and you need to set the logical level of these 2 dimensions accordingly in the Payment fact.

The article that @Robert Angel refers to mentions that you should check the job id via the catalog manager (look at the XML) and compare it with the job id in the RCU tables - S_NQ_JOB & S_NQ_JOB_PARAM

it looks like there is an inconsistency between the agents and the metadata in the DB RCU tables. Quickest way to resolve this would be to delete the jobs and recreate them. Alternatively, you could look at job ids and ensure via the job manager and update the RCU tables but this isn't a straightforward task as there are…

+1 @Gianni Ceresa. Add a SQL statement and you'll be up and running.

Do your BI Server log files have any errors that may assist in pinpointing the root cause of the crash?

I would suggest looking at the catalog in offline mode and checking the permissions there and ensuring all is OK.

posted the wrong URL above - should have been: Oracle Support Document 2473789.1 (OBIEE 12c: Reports Failed With Error ORA-03113 Intermittently) can be found at: https://support.oracle.com/epmos/faces/DocumentDisplay?id=2473789.1 instead of https://community.oracle.com/message/15021434?et=watches.email.thread#15021434 If…

Have you tried creating a new WebLogic user with Admin rights? Are you sure that there isn't an "overlap" of granted roles? As it sounds like you've granted the original user with all permissions possible. I'd suggest creating a new user and just granting the new user with the top level WebLogic admin roles and see if this…

Take a look at these links: https://community.oracle.com/message/15021434?et=watches.email.thread#15021434 https://support.oracle.com/epmos/faces/DocumentDisplay?id=2139888.1