This is the Oracle documentation with the detailed steps needed to set up SSO inOBIEE 12c: https://blogs.oracle.com/cealteam/obiee-12c%3a-configuring-kerberos-sso-for-obiee-12c

I believe that @Christian Berg point is that in this case, you should consider managing user security in your corporate LDAP and integrate this into your OBIEE with SSO. This will mean that user security will be managed externally and users won't have the need for yet another user account.

Could be the dreaded session variables bug if this is an old 12c version.

Which version of OBIEE is this?

Something like this if you have an Oracle data source: SELECT CASE ... FROM DUAL

very possible that indexes on this column will be ignored but we are speculating on the volume of data in OP's data source and if at all the column is indexed...

the "trick" I'd use in this scenario if I understand your requirement correctly would be to edit the column formula on the "analysis" which you don't want to change on the dashboard by adding a space for example: "Finance Facts"."Revenue"||' ' This would ensure that the is prompted filters on the dashboard won't be…

First thing you need to be aware of is that you’ll need to have some backup strategy that ensures that your changes of the ORACLE_HOME/bi/bifoundation/jee/analytics.earfile are backed up. Many updates and patches make changes to files within the ear file and as a result, your changes will be overwritten. These posts below…

I might be missing something here but in my very humble opinion, shouldn't you be looking at the underlying issue of the query performance in your database? A query taking over 10 minutes doesn't sound right.

What I've done in order to have SSO and non SSO authentication working on the same OBIEE instance is to have a copy of the analytics deployment in WebLogic. One which can be configured for the SSO access and the other to use the standard non SSO authentication.

My suggestion would be to look at the OBIEE performance tuning guide as a starting point. It highlights all parameters which can be modified in order to improve performance of the underlying OBIEE components. Oracle Support Document 2106183.1 (OBIEE 12c: Best Practices Guide for Infrastructure Tuning Oracle® Business…

That list is controlled by columns that you’ve included in your criteria tab of your Analysis. If these are columns that you simply don’t require then simply removing them from the criteria tab will remove them from this list.

The best option and the only option in my opinion is to fix the data issues at source. Fixing this in the Analytics layer is just masking the issues you've highlighted with your data. There are things that can be done but that's just "hiding" the data issues. What happens if you uncover further data quality issues?

in addition to @Gianni Ceresa & @Christian Berg, your UNIX guys should be able to trace who did what and when.

Additionally, you only need a single connection pool to a single data source so if all 4 domains are all from the same data source, then a single connection pool is sufficient. You may have a scenario where you may need separate connection pools even if the domains are from the same source if there are some security…

I'm not sure what version of OBIEE you're using but have you looked at: https://docs.oracle.com/middleware/bi12214/biee/BIEMG/GUID-444C99AC-62F8-4658-B2D3-57E617E4EEB3.htm#conn_pool you can use the list connection pool & list rpd variables to generate .json files with rpd variables and connection pools and these can be…

If you have the possibility of stopping and starting the OBIEE services, this will close all sessions and then you can try editing the object afterwards

Then in that case now that your actual requirement is now clear, all you need to do is to use the AGO time function https://docs.oracle.com/middleware/bi12214/biee/BIEMG/GUID-DB4D9819-BF7D-4750-9C71-DDFA2ACE1CDB.htm#GUID-D474E224-DFBB-4… You just pass the measure, time dimension hierarchical level (in your case, the month…

I haven't tried that and wouldn't recommend that approach.Thinking out aloud, you could create a python script (or any other programming language of your choice) which scans your catalog on the file system to detect any changes objects (possible looking at the timestamp?). You can then use the runcat.sh utility to create…

Have you tried something like this: TIMESTAMPADD(SQL_TSI_MONTH, -1,CURRENT_DATE) you'll need to replace the CURRENT_DATE with whatever date it is that you're working with.