Hi @User_PBMY6, Welcome to the Oracle Analytics Community. Can you please add the following column to your report to see if it brings any values so that it can be filtered accordingly. "- Goal Alignment Details"."Actual Completion Date" Hope this help. Thank You!

Hi @Dave Whitson, Please find below the xml which will give Employee & Manager and their Employee Numbers using the 'Workforce Management - Worker Assignment Real Time' SA. Hope this help. Thank You!

Very helpful information. Thanks for sharing @MarkPescatrice!

Hi @Tonya H, Welcome to the Oracle Analytics Community. Please find below the definition of TrimTrailing function and a working example, it might help to understand the working methodology. TrimTrailing‎ function Strips specified trailing characters from a character string. Example: Used the following to Trim Trailing 6.…

Very helpful. Thank you very much @Prasad Deshpande!

Great Idea and it is much needed for good user experience. Upvoted.

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

Very helpful information. Thanks for sharing @Marcelo G. Proaño!

Thank you very much @Ivony Ann Paula Salango!

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

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.