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

Run reports based on conditions in dashboard sections

Received Response
11
Views
1
Comments
Joe Choueiri-Oracle
Joe Choueiri-Oracle Rank 5 - Community Champion
edited Aug 13, 2024 6:16PM in Oracle Analytics Cloud and Server

Hi

I have read few articles on the web but for some reason I did not understand how they can serve what I need...hoping you can shed more lights specifically to my requirement.

I want to create 3 different analyses, (analysis A, analysis B, analysis C) each one has different columns, and I want to use one set of prompts such as division (EMEA, NAMER, APAC, LAD, JAPAN) and country but here is when I want the 3 reports to appear:

When I select EMEA, NAMER, APAC & LAD then Analysis A to appears

When I select JAPAN then Analysis B to appears

When I select APAC AND any of the following countries in APAC such as KR, TW IN then Analysis C appears


Any idea on how it can be done.


Thanks

Joe

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi Joe,

    You can do it by using conditions to show or hide sections in your dashboard.

    You dashboard page will contains 3 sections with one single analysis per section, you must create 3 analysis acting as conditions.

    The conditions to display or hide a section is not based on the content of the analysis for only on the row count. So your analysis acting as conditions must return at least one row when "OK" and nothing when "NOT OK", you do that by setting filters with your rules (for example "prompted division IN (EMEA, NAMER, APAC & LAD)" => at least one row of result etc.).

    And it's done

    The key element to keep in mind is that a condition on a section only works on the row count of an analysis and not the values returned, so the analysis you use as a condition must have the right filter to return rows when OK and nothing when not OK.