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://support.oracle.com/knowledge/Oracle%20Cloud/2245339_1.html Ago Function not working in OTBI — Cloud Customer Connect Hope this help. Thank you.

Hi @Anup Karmankar, Welcome to the Oracle Analytics Community. Please check the following as highlighted in Yellow. Hope this help. Thank you.

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 30 Jun 2025 and in July it will execute for 01 Jul 2025 to 31 Jul 2025. If yes (for the above question), are you having any date filter in your…

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 helpful to find potential solution. Thank you.

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 you.

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

Very useful & helpful information. Thanks for sharing!

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. 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!

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!

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.

Hi @Momen Jaradat, Additionally, please take a look into the following Oracle Note which might be useful. https://support.oracle.com/knowledge/Oracle%20Cloud/2785818_1.html Hope this help. Thank you.