Have you checked if this is a caching issue? You also didn't mention which version of OBIEE you're using.

I totally agree with Robert. The OP needs to review the underlying data model and rather than doing these conversions at runtime, these should be derived, calculated as part of your data warehouse ETL process. This will definitely bring on some performance improvements.

Alternatively, you can achieve this with a single analysis by creating the CSV column and creating a new compound layout with only the CSV column: Edit the Analysis Properties and select the new Compound Layout as the view for Text Delivery:

You'll need to do this in 2 steps: * Create a Dashboard Variable Prompt: * In your analysis on the same page as your dashboard prompt, you can have a column/filter with formula similar to this that references the presentation variable which is populated via the dashboard variable prompt from above:

You'll need something like this: CASE WHEN DAYOFWEEK(CURRENT_DATE) = 2 THEN TIMESTAMPADD(SQL_TSI_DAY, -4, CURRENT_DATE) ELSE TIMESTAMPADD(SQL_TSI_DAY, -2, CURRENT_DATE) END

totally agree with @Robert Angel. it's a tip that I also use...

Have you seen this Oracle White paper?

Can you check that the Linux user/group have read permissions to this license file Does the directory containing the ODBC driver appear 1st in the library path?

Take a look at this document to ensure that you have correctly set up your ODBC.

Take a look at this article, it might be related to your issue: Oracle Support Document 1307503.1 (OBIEE 11g Purge Cache License Error: "You are not licensed to use this ODBC driver with the DataDirect ODBC Driver Manager under the license you have purchased....") can be found at:…

In my previous response, I asked for you to send over the exact code that you're using for the export. Without it, I'm afraid there's not much else that we can do unfortunately. Your error indicates that there's a missing argument in your code.

You haven't really provided enough information. What exactly are you trying to do? What commands were you actually running? What OBIEE versions? What OS?

Could you try using the SampleAppLite rpd and see if your OBIEE instance works? This will at least verify that the issue lies with your new rpd.

Your requirement isn't clear. Maybe use some kind of screenshot to show what you want to achieve

Your checkbox dashboard prompts will need to populate a presentation vaia. Each of your reports will will need to be placed in individual sections. Each of these sections will need to have a condition and this condition will be dependent on the presentation variable vale. This is will work if you’re only displaying a…

Oracle Support Document 2210291.1 (OBIEE 12c: After Moving | Changing The Server IP and Hostname, OBIEE Fails To Start) can be found at: https://support.oracle.com/epmos/faces/DocumentDisplay?id=2210291.1

These may all be related to this bug: BugProduct AreaBug IDLast UpdatedDYNAMIC REPOSITORY VARIABLES NOT WORKING IN 12.2.1.3.0Oracle Business Intelligence Enterprise Edition27019889Sun, 31 Dec 2017 00:00 GMT-08:00 I'm not sure if there is a patch for this but as usual, Oracle will be best placed to inform you if at all…

You could do this using the catalog manager command line interface (CLI) Run the below for some details of the runcat report CLI: runcat.sh -cmd report -help (unix) runcat.cmd -cmd report -help (windows) You'll just need to write a script that generates the report and then schedule the script on your server.

Can you show the SQL statement of the initialisation block?