Hi @User_27DEY, Can you please click on the 'Download' button under 'Manage Session' Page as highlighted in Yellow. It should download in CSV format. Hope this help. Cheers,

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

Hi @User_VGJDM, Please try the following Queries, it is working for me. FDoPM: SELECT CAST((CAST(TIMESTAMPADD(SQL_TSI_MONTH, -1, TIMESTAMPADD( SQL_TSI_DAY , DAYOFMONTH( CURRENT_DATE) * -(1) + 1, CURRENT_DATE)) AS CHAR)) AS TIMESTAMP) s_1 FROM "Absence Management - Leave Donations Real Time" LDoPM: SELECT…

Hi @Stefano_Mazzocca, Yes, please. That'll be very helpful. Thank you very much!

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. https://community.oracle.com/customerconnect/discussion/619538/otbi-bip-catalog-refresh-modified-date 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,