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

Stop filter being overwritten on drill action

Received Response
21
Views
6
Comments
Teresa Modesta
Teresa Modesta Rank 5 - Community Champion
edited August 2024 in Oracle Analytics Cloud and Server

Hi,

I am drilling into a dashboard page and it is overwriting one of the filters on an analysis that I do not want changing. Is there a way to stop this.

Thank you!!!

Answers

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    There is a protect filter on the filter control which is used to prevent the dynamic filter overwrite that you describe and enforce the originally written filter.

  • Joel
    Joel Rank 8 - Analytics Strategist

    You can Protect the Filter. check the Protect Filter checkbox and this will ensure it doesn't get overridden by a dashboard promptpastedImage_0.png

  • Teresa Modesta
    Teresa Modesta Rank 5 - Community Champion

    Gosh, that was easy - very kind. Thanks.

  • Teresa Modesta
    Teresa Modesta Rank 5 - Community Champion

    Thank you also!

  • Teresa Modesta
    Teresa Modesta Rank 5 - Community Champion

    Is there any other way to use prompts with filters, but selectively so some are not affected?

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Sure, you could also set a presentation variable and put the {PresentationVariableName} in your filter, or sql equivalent. This can also be used with the protect functionality.