Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

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 Forum

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 Acha
    Joel Acha Rank 8 - Analytics & AI 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.