If you use the presentation variable like this in the report filters, you can set the prompt default to None: And UPPER("Column Name") like UPPER('%@{pres_var}{%}%') See if this helps .

Hi Sherry, Thanks for sharing your experience and the Bug details. The workaround helping you helped me as well.

Rebuilding the report didn't fix the issue, it comes back when the dashboard prompts are changed. Do you have any other suggestions?

HI Gianni, I will try building the analysis from scratch. This report was untouched when this issue started but probably could have saved something as you explained.

Is it for Analysis exports to Office 2016? The option shows exports to 2007+ which should inlude 2016 as well. Or are you looking for any BI Publisher or Smartview compatibility?

I rechecked to run the queries on Visual Analyzer, unfortunately I am still not able to see any sessions for the queries generated from VA. There might be some configuration or permissions that are restricting the logs from generating. I have a server with Sample Sales rpd and this is working fine as your screenshot…

Thanks Christian. I am on 12.2.1.2.0, on a Linux Server. Somehow the logs doesn't show up when tried from VA, I will take a deeper look again. Do you know if there would be some configuration which is disabled from generating these logs? like a log level or something else.

If you can, create a custom function on your database and you can use it in the reports. In PL/SQL i think the length can be up to 32767 bytes. Give it a try, Here is the link to the function: Stragg Distinct

You can use Connect By Level to display all the days within current week. you need to find the current week from your Day table in warehouse. refer these: List of days between two dates https://asktom.oracle.com/pls/apex/f?p=100:11:0::::p11_question_id:14582643282111

https://community.oracle.com/thread/3903099

My catalog seems to be corrupted with permissions. Call SAPurgeAllCache() used to work in the past and it doesn't work now. call NQSQueryMetadataObjects('3031') should have same permissions too. Thanks Gianni. I will check on fixing the permissions first.

Hi Gianni, Thanks for prompt response. I have seen that issueRawSQL, gave permissions to my user and executed the script, but it didn't work. I have observed that the results are displayed only for "BI Administrator". Can you please help me where else the permissions need to be setup to execute this javascript by normal…

Did you try using Export Entire Dashboard option?