https://community.oracle.com/products/oracleanalytics/discussion/comment/54423#Comment_54423 Very helpful information. Thanks for sharing @MarkPescatrice!

https://community.oracle.com/products/oracleanalytics/discussion/20139/trim-trailing-not-working 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…

https://community.oracle.com/products/oracleanalytics/discussion/comment/58581#Comment_58581 Very helpful. Thank you very much @Prasad Deshpande!

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

https://community.oracle.com/products/oracleanalytics/discussion/comment/64182#Comment_64182 Very helpful information. Thanks for sharing @Sumanth V -Oracle!

https://community.oracle.com/products/oracleanalytics/discussion/comment/64477#Comment_64477 Very helpful information. Thanks for sharing @Marcelo G. Proaño!

https://community.oracle.com/products/oracleanalytics/discussion/comment/64387#Comment_64387 Thank you very much @Ivony Ann Paula Salango!

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

https://community.oracle.com/products/oracleanalytics/discussion/comment/64487#Comment_64487 Is this only for OTBI? Thanks for sharing @Varun Malhotra-Support-Oracle!

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

https://community.oracle.com/products/oracleanalytics/discussion/24762/how-to-retrieve-the-bicc-user-logs 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…

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?…

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

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

https://community.oracle.com/products/oracleanalytics/discussion/24757/obiee-data-model-parameters 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…

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

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

https://community.oracle.com/products/oracleanalytics/discussion/comment/59468#Comment_59468 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. https://www.ateam-oracle.com/post/data-extraction-options-and-guidelines-for-oracle-fusion-applications-suite Hope this help. Thank You!