You need to use the fully qualified connection pool name. Quick tip, right click your connection pool and copy. Paste into a text editor and you should see the name there amongst other metadata.

Do you have a TNSNAMES.ORA file on your OBIEE server? IT should be in <DOMAIN_HOME>/config/fmwconfig/bienv/core

Hi @Adam Wickes Probably best to post this in the BI Publisher (MOSC) forum

Which version of OBIEE 12c? Which OS? There are a number of different 12c versions which each have their own certification matrix. This is the matrix for 12.2.1.4 (the latest version of 12c). - https://www.oracle.com/technetwork/middleware/obiee-122140-certmatrix-4472983.xlsx without looking at the matrix, I don’t think…

What is the formula that you're using to calculate your average? You'll need to use something like this: AVG(measure BY month)

Could you take a look at your RCU schemas and ensure they’ve been properly upgraded. Follo w the instructions here to verify that the RCU schemas have been upgraded to 12.2.1.4: https://docs.oracle.com/middleware/bi12214/lcm/OBIUP/GUID-93B3A0DC-7546-4ABB-946E-593B3AAE444D.htm#OBIUP-GUID-27DF9569-B…

by suppressing, do you mean remove the column from the analysis? Have you tried moving the field over to sections or table prompts?

Gianni Ceresa wrote:4122460 wrote:When customer click on action link...Where is the link they click exactly? If it's on the values, the one which is clicked is sent as context... Could you provide an answer to @Gianni Ceresa's question? Also, could you check the column formula of the fields used in the is prompted…

OBIEE web pages use responsive web design principles to automatically resize a page based on the screen resolution. As @Christian Berg asked, how much content do you have on your dashboard?

Are you using is prompted filters on the country and industry columns on the detail analysis?

What is the exact command that you're executing? Have you looked at log files to see if there are any exceptions logged there?

You need to point the OAC connection to a local truststore which is used as part of the authentication process between your client and the OAC server.

Did you follow these instructions? https://support.oracle.com/knowledge/Oracle%20Cloud/2432176_1.html

Everything works exactly as it did with OBIEE. You can use the scripts in the bitools directory to upload an rpd, you can use a bar file or (not recommended), you can post online changes via the Admin tool

From the expansive detail that you've provided, it sounds like this is a "papering over the cracks" solution and as this has proven, you honestly can't eat your cake and have it as your users seem to be asking for. I don't believe the filtered column needs to be in the SELECT but if that works for you then go for it.

What you could do is to look at the logical query that the analysis generates and remove the WHERE clause from it and seed that query in cache. This will mean that the seeded query will apply to all scenarios. If there are any filters that are common to all requests then you can include them in the seeded logical query to…

Alternatively, you can enforce this on the database side by having a single schema/user that has access to the tables across all schemas and this can be controlled by creating synonyms in the schema that you can use for your connection pool.

Can you share the exact command and parameters that you're using.

You don't have to do anything. As @Gianni Ceresa said, OBIEE does not really care what the data source is. It's main usage is to abstract that complexity from end users.

Taking a step back, what do you need to achieve by doing doing this?