nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

I have a question about enable/disable parameter In the BIP Data Model.

3335658

@Thomas Dodds have a question: In the BIP data Model I have couple of parameters. Lets say parameter A,B and C.

Parameter B and C is date From and Date To.

I would like to enable/disable parameter B and C, depending upon the LOV in parameter A., so that I can enter the date range value in parameter B and C.

How do I do that?

Please let me know. Thank you in advance.

Message was edited by: 3335658

Find more posts tagged with

Accepted answers

All comments

Thomas Dodds

does UPPER(TABLENAME.Subject) LIKE (:Subject) work when you do it in SQL dev (nope it doesn't ...) you are missing basic SQL syntax

try UPPER(TABLENAME.Subject) LIKE UPPER('%' || :Subject || '%') <- contains search

try UPPER(trim(TABLENAME.Subject)) LIKE UPPER(:Subject || '%') <- begins-with search

try UPPER(trim(TABLENAME.Subject)) LIKE UPPER('%' || :Subject) <- ends-with search

3335658

Thank you.

3335658

Hello Thomas

Thank you for your help earlier this week.

I have another question ; In the BIP Data Model I have couple of parameters. let say Parameter A ,B and C. Parameter B and C is Date From and Date To.

I would like to enable/disable Parameter B and C, depending upon the LOV in parameter A. so that I can give the date range in parameter B and C.

How do I do that?

Please let me know. Thank you in advance.

Thomas Dodds

There is an option in the parameters to refresh others based on the parameter ... have you tried that?

3335658

Hello Thomas,

Yeah but it does not work. Do you have any sample?

If I select "All Closed" from dropdown I want to populate Dates field from SQL LOV. but if I select other than "All Closed" from dropdown , I want to disable the dates fields. I am doing this from Data Model from SQL generated, it is not analysis.

I appreciate your help.

Thank you in advance

Thomas Dodds

why did you replace your original question with this new one? now people don't have a correct answer tied to the original question. This is a forum - searchable for help.

You need to make a new post for a new question.

Thomas Dodds

You can't disable them as you describe ... you can however in your query choose to ignore the dates if a user picks some based on the Open/Closed

3335658

my mistake. I will do from next time.