Can you check if these users have been setup as WebLogic users? Check the WebLogic Admin console to verify that there are users there.

There are some patches which have just been released which contain a fix for this according to the bundle patch documentation. https://support.oracle.com/rs?type=patch&id=27329720 * OBIEE 12.2.1.2.180717 - Patch 27916905: * OBIEE 12.2.1.3.180717 - Patch 27329720:

If you are referring to OBIEE analyses, then these are just XML files stored in the catalog. The XML provides information to the presentation services OBIEE component and then in turn to the BI server component which dynamically generates the query against the data source and then returns the results in your web browser…

You could do this using the Oracle Enterprise Manager BI Management pack (licensed separately) https://docs.oracle.com/cd/E73210_01/OEMLI/GUID-B18CF291-36C3-43A5-A900-F17CD99F65EB.htm#OEMLI130 You'll need to install a Management agent on the OBIEE server plus some configuration to point your OBIEE server to the EM…

Take a look at this more detailed document: Oracle Support Document 1539971.1 (OBIEE 11g: How To Set Up Usage Tracking and Create Usage Reports To Monitor Queries ) can be found at: https://support.oracle.com/epmos/faces/DocumentDisplay?id=1539971.1 It is probably to do with the fully qualified naming of the connection…

It’s quite possible that you need to modify some Java parameters which could speed this up for you. Take a look at this as a starting point - https://docs.oracle.com/middleware/12212/biee/BIESG/GUID-124A77A6-150C-46B9-9145-4A994C46C679.htm#BIESG9140

As it works in other browsers then you have confirmed that it is an IE issue. try clearing browser cache in IE.

This approach of OP completely rules out any form of trend analysi (amongst other things). How can you determine that your business is improving when you are not comparing like for like?

was about to say that OP just requires a single dashboard with a dashboard prompt to control the year. Maybe I've misinterpreted the use case here.

As everyone has said, using DDR bypasses the OOTB OBIEE functionality. It has been mentioned how to get conditional formatting working in a DDR but that will have it's limitations as you've found out with the pdf exporting. You can either manage it as it is or add the data source to your repository and do it the right way…

A very vague question. Could you provide some context? What are you actually trying to achieve here?

Ideally, what you’d need is to have a properly structured Data Warehouse with type 2 slowly changimg dimension for your help desk tickets data and this functionlaity is available straigh away.

You haven't provided the specific version numbers of SQL Server & OBIEE. Also, can you check your BI server log file and presentation server log for some clues.

Your question is not very clear I'm afraid. What do you mean by metadata in the context of the Administration tool and the OBIEE repository?

You can't share RCU tables across OBIEE instances. You'll need to create a new set of schemas for your instance B.

Where are you installing the Administration Tool? Can you try installing on another machine and verify that you don’t get the same issue?

Maybe OP needs to look at BI Publisher.

As @Robert Angel mentioned above, check your logs, see if there are any pointers in there and if all else fails, sounds like a justification for a backup policy. I think you should retrieve a backed up rpd and verify if the same issue occurs.

Some specific information like exact OBIEE versions would be useful as well as the exact error in the log file. Do do you have more than one Oracle home on this server? You may want to check what your Oracle home environment variable is set to and to verify that it is pointing to the right path for your OBIEE instance.

you say it's not working but you'll need to provide a bit more information than that. Do you get errors, OBIEE version, does the variable work in standalone? etc etc