Oracle Fusion Data Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion Data Intelligence› Oracle Fusion Data Intelligence

Categories

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

Filtering different datasets with a common attribute Expression Filter vs Regular Calculation (Case)

Received Response
48
Views
2
Comments
bwdata
bwdata Rank 3 - Community Apprentice
in Oracle Fusion Data Intelligence

Current Version: FDI 24.R4.P2 / Oracle HCM Cloud 24D (11.13.24.10.0)

Context:

For a simple / proof of concept type dashboard, we want to drop in some subject areas and CSV data sets that are pretty disparate (not joined). They have a few fields in common, like Business Unit.

Question:

Is the expression filter + parameter the best way to go about trying to give the user single filter that applies to many disparate / separate datasets in one canvas within a workbook? This seems to work / refresh as expected.

Unexpected behavior:

Attached an example where we used a regularly case statement to accomplish the same thing. It seems to work only after clicking Refresh Data, which doesn't feel like expected behavior (I would expect it to update as soon as the parameter is changed by user).

Any thoughts welcome. At the very least, hope it helps other folks building entry level dashboards.

Filter SA via Parameter and Regular Calc.catalog

Filter SA via Parameter and Expression Filter.catalog
Tagged:

Answers

  • JohnW-Oracle
    JohnW-Oracle Rank 6 - Analytics Lead

    Hi @bwdata

    You could using the canvas property settings documented here https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/canvas-data-refresh-properties.html, to configure canvas data to refresh when you open a canvas.

    Let me know if that helps.

    Regards,

    John

  • bwdata
    bwdata Rank 3 - Community Apprentice

    Thank you for the reply. Really appreciate it @JohnW-Oracle.

    Canvas properties does give you the option for:

    • Refresh Data when Canvas is Opened
    • Auto Refresh Data Every *** seconds

    I think our expected outcome is:

    1. When Parameter selection is changed
    2. Then refresh workbook data OR
    3. Then refresh canvas OR
    4. Then refresh canvas visualizations

    When we think about the functionality of a filter, we expect once a filter is applied, the visualizations refresh (even if the background data does not).

    Perhaps this is an idea/enhancement request?

    Note: I tried creating a parameter that would work for anyone opening the attached workbooks. If your parameter is returning no values, feel free to modify the parameter Available Values logical query:

    SELECT DISTINCT
    "HCM - Workforce Core"."Organization Hierarchy"."Level 1 Organization Name" AS "Org Name"
    FROM
    "HCM - Workforce Core"."Organization Hierarchy"