Is this only for OTBI? Thanks for sharing @Varun Malhotra-Support-Oracle!

Hi @Sean-B-01, Can you please try the your conditions like below one? AND ( "Employee"."Employee Name" IN (:P_Name) OR (CASE WHEN ('null') in (:P_Name) THEN 1 END =1) ) AND ( "Labor Schedules Details"."Status" IN (:P_Status) OR (CASE WHEN ('null') in (:P_Status) THEN 1 END =1) ) I tried in my instance and it is working for…

Hi @Imran Shaha, Welcome to the Oracle Analytics Community. It seems BICC has no auditing mechanism yet. Please find below Idea that has been raised by a fellow community member. Please review and vote / comment so that Oracle will consider it for future release. BICC - Enabling Audit Logs — Oracle Analytics Hope this…

Hi @Sean-B-01, If possible please create a copy of the data model without the parameters and then execute to see if it is bringing all rows as per expectation or not. Want to see where it is having the issue, is it the prompt or something else. I'm not getting data in my instance with the query as we don't have project…

Hi @Sean-B-01, I'm able to replicate the issue that you had faced with 'Least' function without those DFFs and you are absolutely correct here. That's a good learning for me and Many Thanks to You. Much appreciated. Can you please execute that logical SQL from OTBI to see how many rows it is returning with the same user?…

Hi @Sean-B-01, Sorry to hear it has not work in your instance. It works for us with Oracle Fusion HCM / ERP Cloud and BI Publisher using OTBI SAs as a data model. Can you please try the following to see if it works? AND ( "Employee"."Employee Name" IN (:P_Name) OR 'All' IN (:P_Name || 'All') ) AND ( "Labor Schedules…

Hi @Sean-B-01, Please use the following code instead of the existing 'AND' AND ( "Employee"."Employee Name" IN (:P_Name) OR LEAST(:P_Name) IS NULL ) AND ( "Labor Schedules Details"."Status" IN (:P_Status) OR LEAST(:P_Status) IS NULL ) Also make the Prompt like following: Hope this help. Thank You!

Hi @Sean-B-01, Quick Question: How the prompts been defined: Can you please share screenshots? Is it 'NULL Value Passed' or 'All Values Passed' under 'Can Select All'? If possible attach your report catalog so that we can replicate the issue in our instance which will help to find any potential solution. Thank You!

Very helpful information. Thanks for sharing @Conor Murnane & @Sumanth V -Oracle!

Great Idea. It'll be very helpful feature to have. Upvoted.

Very helpful information. Thank you very much Arjun!

Hi @Prabhjeet Kaur, Additionally please find below a good document (from Oracle ATeam) that is comparing the available tools which might be a good for the understanding. Hope this help. Thank You!

Hi @Prabhjeet Kaur, Can you please share some more details like: What sort of data are you extracting? What is the data volume that you are expecting? How frequently you want the extraction? Where are you going to extract the data? It'll be helpful to understand your requirement for community members and will help to find…

Hi @Aaron Angell, Can you please provide some more details like what issue are you facing, the tool / toolset that you're using and associated examples, screenshot (without sensitive data etc.) etc. so that it will be easy for community members to understand, replicate and finally suggest any potential resolution. Thank…

Hi @Basti, If the report in condition is returning any row when executed individually, the row count should be greater than '0'. Also if you execute the report individually first and then check the condition from the agent it should not be impacted via Cache as the cache holds results for the exact same report. Couple of…

Glad to hear that. Can you please accept the answer that helped you to resolve the issue? It'll be helpful for fellow community members in future. Thank you very much @Ivony Ann Paula Salango!

Beautiful & very professional. Thank you very much @Mike Fuqua-Oracle!

Hi, The last update dates can only be changed during Upgrade/Patch. Last update dates of OOTB / seeded Folders/Files can vary based on internal modifications/developments before final addition to Patch/Release/Upgrade. The last update date of OOTB / seeded Folders can be changed due to Oracle internal developments or…

Hi @Ivony Ann Paula Salango, Quick question: Have you able to hide the parameters from data model using above steps? Thank You!

Very exciting! It'll be a great help for fellow community members. Thank you very much @Benjamin Arnulf-Oracle!