This would indicate ("taking a lot of time") exactly what it says here: Action : Alter database to turn on the READ_COMMITTED_SNAPSHOT option. Ensure you have DBA priviliges. Also the DBA should not have multiple logins on this database - else it will result in a lock error. Ensure that there are no other active DBA logins…

So not a data volume issue then. Have you tried clearing browser cache? Have you tried this on another browser?

As mentioned, can you create an analysis with this column only? How many records does this return in the analysis? The rationale behind this is to see if OBIEE actually returns the data properly before delving into the issues with the prompt.

Can you create a test analysis with just this column that you're using for the dashboard prompt to see what happens? How many rows does it return? How many distinct rows?

You can get rid of all these issues by properly modelling your repository. Dates will need to be setup as dates and measures will need to be setup with aggregation as a starting point as well as logical dimensions with hierarchies etc. Once all of that has been done then all the issues you’ve highlighted will be resolved.

OAS is likely to be released by the end of the year. These are the Oracle migration steps here: https://docs.oracle.com/middleware/1221/core/BIMIG/GUID-73D55C46-A09A-4A0F-994B-0CCE9C0342F6.htm#BIMIG-GUID-73D55C46-A09…

I would suggest looking at all the logs.

Can you check your services to see if all components are up and running? The error indicates an issue with the obis BI Server component. 

Have there been any changes made recently in your OBIEE domain? have you looked at the log files to see if there are any errors logged?

Are you referring to BI Publisher Reports or an OBIEE Analyses?

Yes, that worked for me when I encountered this issue.

It won’t work on Windows 10. See @Christian Berg‘s blog - https://dimensionality.ch/2017/05/06/installing-oracle-bi-on-windows-7-8-10/

Which operating system and version are you installing OBIEE onto?

You’ll need to switch off your network proxy/VPN.

Have you used a result column to calculate the delta? @Gianni Ceresa As @Gianni Ceresa mentioned, it may be a better option to federate the data in the repository so that you get all the data from a single logical fact and dimension and therefore, a single analyses without any set operation required.

In the bug, you'll notice that it was created on 16-Sep-2015 (almost 4 years ago) which would indicate that the request has been around for a while..

There's an outstanding Enhancement Request for this feature OOTB. This might give you some guidance in getting it done in OBIEE - https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=379332587024192&parent=EXTERNAL_SEARCH&sourceId=HOWTO&id…

Have you considered BI Publisher reports for this as it provides this functionality out of the box. You could attempt this in OBIEE but it would be something that you’d have to put together yourself. https://docs.oracle.com/middleware/12211/bip/BIPAD/GUID-52398FBA-CB92-4A8D-9187-770A98C657E4.htm#BIPAD306

Silly question (I might have missed this in your thread) but why can't you modify the presentation services configuration settings in the instanceconfig.xml file? That would sort your problems out immediately.

As @Gianni Ceresa mentioned, your WLS will work as normal with or without this patch but you leave yourself open to security vulnerabilities. You'd need to apply the latest PSU (Patch Set Update) as you rightly pointed out - Patch 29204678 (10.3.6.0.190416).before you apply the security patch.