You can use a GO URL - https://docs.oracle.com/middleware/12213/biee/BIEIT/apiwebintegrate.htm#BIEIT355

Could you check you instanceconfig.xml file isn't corrupt and that the XML is well formed.If it looks OK, I would suggest rolling back the OPatch to see if your environment can properly come back up afterwards.

I know.

Hi @Christian Berg I think we're saying the same thing here and I totally agree with your summary which consolidates what @Gianni Ceresa and I originally posted and as you so eloquently described, the preferred option really does depend on what the OP's requirements are.

solution 2 is the way to go. you join the vehicle tables in the physical layer and create a Vehicle logical table with each of the 4 vehicle related tables as logical table sources.

You'll need to do something like this although I didn't quite get the rank ordering to work but this should help:

Have you seen this? Have you checked the certification matrix? Also, this systems requirements & specifications document specifies hardware requirements.

Try to reset the values in 12c and see if they reappear If they do, next thing is to understand why the setting is lost during the migration.

2 things: 1 - you say the answer isn't helpful but your response isn't either as you haven't given any information about what you've done and what actually doesn't work 2 - you marked this thread as answered so your best bet would be to create a new one.

Does the Analysis that your Agent runs work ok? When you run the Analysis, do you get any errors? How large (number of rows/columns) is this analysis?

Not sure you can reference a variable in a dashboard section title it appears. You can simulate the Section Title dependent on how your dashboard has been formatted. You could do something similar below displaying the narrative view as the "section title" with formatting of the section to align the text to the left etc. To…

Understood - use a Narrative view and format the text accordingly:

For a repository variable: 'Today - '||CAST(VALUEOF("curr_date_RT") AS CHAR(10))

Try something like: 'Today - '||CAST(CAST (VALUEOF(NQ_SESSION.curr_date_RT) AS DATE) AS CHAR(10))

Is it listed as a DATETIME type when you check the session manager in the Admin Tool?

Why don't you simple TO_DATE the column in your SELECT statement of your initialisation block for the curr_date_RT session variable? It's being treated as a string because it is a string and not a date

Have these reports been recently migrated from 11g to 12c? If so, how were they migrated?

As @Gianni Ceresamentioned, you'll need to check your log files: Starting specific servers ... Starting bi_server1 (Original State:SHUTDOWN) ... Received error message from Node Manager Server: [Server start command for WebLogic server 'bi_server1' failed due to: [Server failed to start up but Node Manager was not aware of…

Does the Analysis that your /shared/Agents/Daily SIK Call Reporting_test agent run OK? Which version of OBIEE? Which OS? Are the others that work running against the same underlying data source?

Which OS are you running the Admin Tool from? Is it 32-bit or 64-bit? If it's 32-bit, then OBIEE desktop tools only work on 64-bit machines.