OBIEE Data Model Parameters

Bhaskar Konar

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?

Wanted to see if OTBI is bringing all.

Thank you.

Bhaskar Konar

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 data in our instance.

Thank You!

Sean-B-01

Hey @Bhaskar Konar

Without the parameters it returns all data without any issues. I believe the issue is prompt.

Thank you,

Sean

Sean-B-01

Hey @Bhaskar Konar

Your solution works perfectly using:

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))

Thank you for all the help!

Best,

Sean

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/comment/64517#Comment_64517

Hi @Sean-B-01,

Glad it worked for you.

Thank you.