https://community.oracle.com/products/oracleanalytics/discussion/26126/how-to-get-marital-status-change-date-field-in-otbi-analysis Hi @Anup Karmankar, Welcome to the Oracle Analytics Community. Can you please check the 'Person Legislative Information' folder under 'Workforce Management - Person Real Time' Subject Area?…

https://community.oracle.com/products/oracleanalytics/discussion/26122/otbi-time-intelligence-functions-does-not-work Hi @ACDC, It seems AGO function is not supported for SAAS BI. Please take a look into the following Oracle Note & the post for the probable work around and the details.…

https://community.oracle.com/products/oracleanalytics/discussion/26108/how-to-get-marital-status-change-date-field-in-otbi-analysis Hi @Anup Karmankar, Welcome to the Oracle Analytics Community. Please check the following as highlighted in Yellow. Hope this help. Thank you.

https://community.oracle.com/products/oracleanalytics/discussion/26106/can-an-agent-to-generate-otbi-report-and-email-increment-to-the-next-gl-period Hi @Elena Brennan, Quick Question: Is your requirement is to execute the OTBI Agent for the entire month like if you are executing today it should execute for 01 Jun 2025 to…

https://community.oracle.com/products/oracleanalytics/discussion/26096/otbi-prompted-date-issue Hi @Gabby, Welcome to the Oracle Analytics Community. Can you please share some more information like what issue are you getting any relevant screenshots, report catalog / xml etc.; it'll help to understand the issue and will be…

https://community.oracle.com/products/oracleanalytics/discussion/26120/how-to-get-the-last-assignment-if-the-worker-have-several-records-in-a-analysis-and-report-goals Hi @Claudia Linares, Quick Question: Have you tried using 'Assignment Status Type' column & it's data to see if unwanted rows can be filtered with it? Thank…

Hi @Nazera Shabnam. Glad you found it useful. Thank you.

Very useful & helpful information. Thanks for sharing!

https://community.oracle.com/products/oracleanalytics/discussion/comment/67869#Comment_67869 Very helpful & useful information. Thanks for sharing @RanaAshutosh-Oracle!

It'll be a great session. Registered. Thanks for sharing the details.

It'll be a very useful feature to have. Upvoted.

This is a great idea. It'll add so much values. Upvoted.

Hi @Nazera Shabnam. Additionally, please find below the sample dashboard prompt where the formulas have been used which might be useful for the understanding. https://us.v-cdn.net/6037859/uploads/3HDT9PFUH1Y3/current-previous-month-pmt.catalog Hope this help. Thank you.

Hi @Nazera Shabnam. Welcome to the Oracle Analytics Community! Can you please try the following formulas: Current Month: MONTH(CURRENT_DATE) Previous Month: MONTH(TIMESTAMPADD( SQL_TSI_DAY , -(1), TIMESTAMPADD( SQL_TSI_DAY , DAYOFMONTH( CURRENT_DATE) * -(1) + 1, CURRENT_DATE))) It is working for me: Hope this help. Thank…

Hi @Momen Jaradat, Thanks for the details. As a work around you can create the same folder structure under 'Custom' folder and then copy the components manually. Also please check if any other OOTB Report from other different location is having same issue with the same user. It seems you have to raise it with Oracle…

Hi @Kauan_Bohn, Additionally, can you please try the following one? AND ( esi.item_number IN (:P_ITEM) OR 'All' IN (:P_ITEM || 'All') ) Hope this help. Thank you.

Very helpful sessions. Thanks for sharing!

https://community.oracle.com/products/oracleanalytics/discussion/comment/67818#Comment_67818 Hi @Kauan_Bohn, Can you please share your data model here so that we can try to replicate the issue in our instance. Thank you.

Beautiful viz & the great presentation. Thanks for sharing @James Lomotey!

https://community.oracle.com/products/oracleanalytics/discussion/25806/issue-with-multi-select-filter-in-report Hi @Kauan_Bohn, Can you please try the following code instead of your last 'AND Condition' AND ( esi.item_number in (:P_ITEM) IS NULL OR esi.item_number IN (:P_ITEM) ) Hope this help. Thank you.