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

Hi @Samantha Aguilar C, Quick Question: Has the 'Sensitive Data Access Audit' enabled? To enable auditing of sensitive data access, need to set the Mobile-Responsive Sensitive Data View Audit Enabled (ORA_HCM_SENSITIVE_DATA_VIEW_AUDIT_ENABLED) profile option to Y. Please take a look into the following Oracle note which has…

WOWWWW Absolutely awesome & mind blowing. Thanks for sharing @Benjamin Arnulf-Oracle!

Very helpful suggestions. Thank you very much @Josue Jimenez!

Also please take a look into the following post which might be useful. Agent Functionality in FAW for scheduling reports — Oracle Analytics Cheers,

Hi @Stefano_Mazzocca, Can you please take a look into the following document. Especially following part to see if the Enable and Customize Content Delivery Through Agents Hope this help. Cheers,

Hi @Ankur Jain--Oracle, It seems the issue you are mentioning now is bit different from the initial one that you raised. I would recommend you to raise a new question with associated details like screenshots etc. as more fellow community members can have a look and help you to get the resolution. Also if you got your…

Hi @Ankur Jain--Oracle, Can you supply the default value that you want to be there, please? The code I provided 'XYZ' is the default value. So if you just put your default value instead of XYZ, it should work fine. Hope this help. Cheers,

Glad to hear that. Thank you very much @Stefano_Mazzocca!

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,