Hi @Stefano_Mazzocca, Thanks for the details. As per the screenshot the column is only storing the date part and time part you are getting it's a default value like 00:00:00. If you are looking for Current Timestamp then you can use CURRENT_TIMESTAMP similar like CURRENT_DATE. Cheers,

Hi @Stefano_Mazzocca, Is your source column having Timestamp? You can CAST a date column to Timestamp in the following way. CAST("COL NAME" AS TIMESTAMP) Hope this help. Cheers,

Hi @Rama123-Oracle, It's bit strange. As per my knowledge, Logical SQL follow the same security as Subject Area. Can you please compare the session queries? execute the report by your user id and track the session query then ask the user to execute the same report and track the session query. (both user should have same…

Hi @Ankur Jain--Oracle, Can you please try the following? (@{R1}['@']{'XYZ'}) So the query will look like: SELECT "Department"."Department Name" FROM "Workforce Management - Worker Assignment Real Time" where "- Hierarchy"."Level 1 Department" IN (@{R1}['@']{'XYZ'}) and "Department"."PER_ORGANIZATION_UNIT_DFF_LEVEL_NR_" >1…

Hi @Shravani, Please take a look into the following post which might be useful. Hope this help. Cheers,

Glad, you're able to solve your issue. Thank You!

Hi @Rama123-Oracle, It might be the issue with Role. Can you please check if those users have correct roles to see data for the Subject Areas that you mentioned. Also you can check if the users are getting data from those subject areas or not by creating a simple analysis from respective SAs. Hope this help. Cheers,

Hi Uday, You have to use 'Prompt before Opening' here. PFB the steps that you need to follow to enable it for your Dashboard. To set "Prompt before Opening": Edit the dashboard. Click the "Prompts before Opening" control in the lower right of the dashboard page editor Save the dashboard before leaving the dashboard editor…

Thank you very much for sharing!

Hi, If it is you're editing the report and it is started executing: Then you have to change the following settings from your My Account: Select 'Start on Criteria tab when editing Analysis' from the drop down under 'Analysis Editor' and then press the 'OK' button as highlighted in Yellow. Hope this help. Cheers,

Hi Uday, Can you please provide some more information like is it a Dashboard or individual OTBI Analysis? Are you editing the report and it is getting executed? Cheers,

Hi @Stefano_Mazzocca, Can you please validate the requirement and my understanding. Are you looking for something like below? Cheers,

Hi @Stefano_Mazzocca, Can you please try using CASE Statement like following: CASE WHEN (A > 50 AND B = 'Y') THEN (C + 1) ELSE C END Hope this help. Cheers,

Hi @User_WA0HA, It seems Databricks is not a certified technology under the certification matrix for Oracle Data Integrator. Please take a look into the following Oracle Note which contains all details and might be useful. Hope this help. Cheers,

Hi @Ivony Ann Paula Salango, Can you please try the following with your BI Publisher Report? Step 1: Navigate to BI Publisher Catalog Step 2: Edit the Report Step 3: Hide Parameters In the next window, you have the option to show or hide the parameters as shown. Once you have made the changes click on OK and Save the…

Hi @User_JUVGU, Unfortunately for Table view; it is only 'after' available. But you can achieve it by using 'Pivot Table' view. Hope this help. Cheers,

Exciting feature! Very helpful information. Thank you very much @Prasenjit_Thakur-Oracle & @Lalitha Venkataraman-Oracle!

Please take a look into the following Oracle Note, it has the steps & details. Hope this help. Cheers,

Very helpful information. Thank you very much @BalagurunathanBagavathy-Oracle!

Hi @TMR KRS, Sorry to hear that. Let's see if anyone else has any solution for this. If we're not getting any solution, please raise with Oracle Support. Hi @Gianni Ceresa, @SteveF-Oracle, Hope you're well. Need your expert opinion. can you please suggest? Thank You! Cheers,