Changing the analysis from the filter in Oracle BI(Analytisc) — Oracle Analytics

Oracle Analytics Publisher

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

Changing the analysis from the filter in Oracle BI(Analytisc)

Accepted answer
41
Views
3
Comments


Sure, here's the translation of the text to English:

Good day everyone!

I encountered a problem: I have a dashboard in Python and need to transfer it to Oracle BI. The problem lies in the filter that has values for employees, departments, and regions - all in one filter (screenshot). The challenge is how to display data depending on the selected filter, as these data have different forms. For example, if you select an employee, the data will show "Standard, % completion, average per unit," but if you select data by Region, it will show "Employee, Department, Region, % completion." This is all done with one filter in Python.

The question is whether it is possible to implement such functionality in Oracle BI so that the analysis changes depending on the filter, i.e., when an employee is selected, one type of analysis is shown, and when a region is selected, a different type of data is shown?

I would appreciate any answers!
Thanks to the community!

bi_help.png

Best Answer

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist
    Answer ✓

    Hi @Vitalii_Alliance_dgtl

    For example, if you select an employee, the data will show "Standard, %
    completion, average per unit," but if you select data by Region, it
    will show "Employee, Department, Region, % completion." This is all done
    with one filter in Python. —> Using one filter its not possible , you need to create separate filter and use the condition based on your selection.

    Regards,

    Arjun

Answers