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!

https://community.oracle.com/products/oracleanalytics/discussion/24743/bicc-frequency-recommendation 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…

https://community.oracle.com/products/oracleanalytics/discussion/24738/sum-of-hires-from-acquired-company 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…

https://community.oracle.com/products/oracleanalytics/discussion/24735/agent-condition-evaluates-to-false-despite-analysis-returning-rows 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…

https://community.oracle.com/products/oracleanalytics/discussion/comment/64385#Comment_64385 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!

https://community.oracle.com/products/oracleanalytics/discussion/19826/how-does-the-last-update-date-of-seeded-reports-and-dashboard-of-change 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…

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

https://community.oracle.com/products/oracleanalytics/discussion/comment/64372#Comment_64372 Very exciting! It'll be a great help for fellow community members. Thank you very much @Benjamin Arnulf-Oracle!