I think @Christian Berg point is that you could generate the URL in a column formula. For example: and setting the data format accordingly as below: to give:

You could filter the report using the RANK function. For instance, RANK(eff date BY ID) = 1.

stop all OBIEE services and check the permissions on the cwallet.sso.lck file and make sure that the OBIEE OS user has full access to this file then restart OBIEE.

You create your dashboard prompt as a variable prompt and reference the presentation variable initialised bu the variable prompt in your filter where you can modify the operator as you require like this:

you need to change your prompt from a column prompt to a variable prompt and use the variable prompt to populate a presentation variable which you'll then use to file the parts of your union analysis

Is this a question or a statement? It isn't clear what your issue is. If you're asking whether internal SSL has to be enabled, it doesn't - it just makes your instance more secure. It can be enabled/disabled after your upgrade using the WLST scripts in the bitools/bin directory -…

then you need to look at @Christian Berg's response in your thread. Check your model as you're adding in the Region dimension attribute but you don't want to aggregate at the Region level so I'm personally confused with what it is that you're trying to achieve.

If I understand correctly, you want to divide 2 measures derived from a union report. If so, you add a result column and use the syntax saw_0/saw_1 where the number indicates the position of the column in the analysis - where 0 = position 1 and 1 = position 2 etc

This thread is closed. Open a new thread and your question will be addressed there.

you'll need to perform a number of tests to verify the root cause of your issue - that's why I suggested that you connect via SQL*Plus/ SQL Developer/ TOAD to verify that the RCU user can connect to the DB. Your DBAs will need to assist you with this as they have visibility of what might be causing the locks. They need to…

First of all, what do you mean by schema getting locked? Do you mean that the BI Platform schema is locked? When you connect directly as the BI Platform user on the Database do you encounter any of these locking issues?

Check this: https://support.oracle.com/knowledge/Enterprise%20Performance%20Management%20and%20Business%20Intelligence/2177562_1.html

Hi @Adam Wickes Is this of any use? OBIEE 12.2.1.3 Deprecated BAR file APIs - ELFFAR ANALYTICS

are you running WLST offline or online? Do both throw this exception? Try running it in online mode

The BAR file contains the web catalog, repository and security - https://docs.oracle.com/middleware/bi12214/biee/BIESG/GUID-7FCD90A3-E005-49BF-902F-30FBF9B41B07.htm#BIESG9295 You can specify which of these you want to import into your target instance.

Have you tried using BAR files for your migration? Welcome to OBIEE12c: Using BI Application Archive (BAR) files You didn't mention your 12c version as the APIs referred to in this article are deprecated in 12.2.1.3 and don't run in 12.2.1.4

You can do an XML search and replace in the catalog manager. Before you do this, i do strongly suggest backing up your catalog in case things go wrong.

You should push as much as possible to the underlying data source. This means everything will be pre calculated and you should get some performance benefits from this. This blog describes the process: http://www.rittmanmead.com/blog/2008/08/the-mystery-of-obiee-bridge-tables/amp/

A single logical table with LTSs for the header and detail tables. The logical dimension will have a hierarchy with at least 3 levels: * total * header * detail You’ll then need to set the levels correctly for the LTSs of your logical fact.

You’ll need to do this in 2 steps firstly, use the TIMESTAMPDIFF function to calculate days between the hire date and current date. Secondly, use a custom format mask to convert number of days to years months days as required. Also, see this thread - How to calculate the number of days/weeks/months between 2 dates?