https://community.oracle.com/products/oracleanalytics/discussion/24445/otbi-dashboard-prompt-timestampadd-formula-for-default-end-date-covering-through-eod-11-59-59pm 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 ,…

https://community.oracle.com/products/oracleanalytics/discussion/comment/63390#Comment_63390 Hi @Stefano_Mazzocca, Yes, please. That'll be very helpful. Thank you very much!

https://community.oracle.com/products/oracleanalytics/discussion/comment/63395#Comment_63395 Very helpful information. Thank you very much @Benjamin Arnulf-Oracle!

https://community.oracle.com/products/oracleanalytics/discussion/24482/sensitive-data-access-audit-real-time-subject-area-does-not-show-results 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…

https://community.oracle.com/products/oracleanalytics/discussion/24479/get-inspired-for-the-new-oracle-analytics-data-visualization-challenge WOWWWW Absolutely awesome & mind blowing. Thanks for sharing @Benjamin Arnulf-Oracle!

https://community.oracle.com/products/oracleanalytics/discussion/comment/63391#Comment_63391 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,

https://community.oracle.com/products/oracleanalytics/discussion/comment/63386#Comment_63386 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…

https://community.oracle.com/products/oracleanalytics/discussion/comment/63384#Comment_63384 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.…

https://community.oracle.com/products/oracleanalytics/discussion/comment/63382#Comment_63382 Glad to hear that. Thank you very much @Stefano_Mazzocca!

https://community.oracle.com/products/oracleanalytics/discussion/comment/63379#Comment_63379 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…

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,

https://community.oracle.com/products/oracleanalytics/discussion/comment/63371#Comment_63371 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…

https://community.oracle.com/products/oracleanalytics/discussion/24472/replace-function-is-not-working-in-otbi-dashboard-prompt 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…

https://community.oracle.com/products/oracleanalytics/discussion/24467/why-is-the-modified-date-changing-on-the-seeded-otbi-reports 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…

https://community.oracle.com/products/oracleanalytics/discussion/comment/63360#Comment_63360 Glad, you're able to solve your issue. Thank You!

https://community.oracle.com/products/oracleanalytics/discussion/24470/aor-users-are-not-able-to-view-the-results-of-logical-sql-otbi-report-getting-no-results 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.…

https://community.oracle.com/products/oracleanalytics/discussion/comment/63336#Comment_63336 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…

https://community.oracle.com/products/oracleanalytics/discussion/comment/63345#Comment_63345 Thank you very much for sharing!