Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
62
Views
8
Comments
3335658
3335658 Rank 2 - Community Beginner
edited Aug 13, 2024 5:46PM in Oracle Analytics Cloud and Server

@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

Message was edited by: 3335658

Answers

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    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
    3335658 Rank 2 - Community Beginner

    Thank you.

  • 3335658
    3335658 Rank 2 - Community Beginner

    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
    Thomas Dodds Rank 8 - Analytics Strategist

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

  • 3335658
    3335658 Rank 2 - Community Beginner

    Hello Thomas,

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

    OpenClose.PNG

    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
    Thomas Dodds Rank 8 - Analytics Strategist

    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
    Thomas Dodds Rank 8 - Analytics Strategist

    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
    3335658 Rank 2 - Community Beginner

    my mistake. I will do from next time.