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

limiting inhertiance on dashboard pages and reports

Received Response
1
Views
2
Comments
J Weis-Oracle
J Weis-Oracle Rank 3 - Community Apprentice
edited Aug 13, 2024 6:18PM in Oracle Analytics Cloud and Server

I've a dashboard with 7 dashboard pages.  Prompts are set on dashboard page 1, and values are inherited one the remaining 6 dashboard pages.  Is it possible to create a report on dashboard page 3 which ignores the global applied prompt?

Answers

  • Joel
    Joel Rank 8 - Analytics Strategist

    Easiest way to achieve this would be to "trick" OBIEE into thinking columns are different. Simply add a space at the end of your column formula on your report on dashboard page 3. For dashboard prompts to work with is prompted filtering, the column formulas in the dashboard prompt definition and the is prompted filter column formula must match.

  • J Weis-Oracle
    J Weis-Oracle Rank 3 - Community Apprentice

    Brilliant.  Your answer works.  I love trickin' obiee out.  in fact, that would make a nice, nerdy t-shirt.