Ability to use Column Selector in DV (same as OBIEE) — Oracle Analytics

Oracle Analytics Cloud and Server Idea Lab

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

Ability to use Column Selector in DV (same as OBIEE)

Delivered
433
Views
10
Comments

Description

'Column Selector' option in available in OBIEE (below image) and this would be very useful to be added in DV as well (or a similar feature).

Use Case and Business Need

Feature will provide a lot of utility in DV and can save up space in your canvas (i.e. create only one visualization and toggle between options, instead of having multiple visualizations).

Original Idea Number: 058dc6978b

OBIEE_Column_Selector.png

33
33 votes

Delivered · Last Updated

Comments

  • Wilian Perone
    Wilian Perone Rank 5 - Community Champion

    It would be quite good for reporting in smaller areas.

  • User_CGJM2
    User_CGJM2 Rank 3 - Community Apprentice

    Much needed.

  • Branden Pavol
    Branden Pavol Rank 6 - Analytics Lead

    Why did Oracle create a "better" tool and take away functionality in the process?

  • Greg Faris
    Greg Faris Rank 5 - Community Champion

    This would be extremely helpful for making analysis a lot more dynamic for "non-author" users. DV is becoming the go to solution in OAS for reporting. Column selectors allow the users to be able to select the analysis they want to see without having to know how to modify the views with full author access in Visualize. This just isn't a reasonable ask to have executives take the time to have to dig through large subject areas for metrics/dimensions (our subject area has 1000s of metrics and dimensions).

    Column selectors allow authors to create reports where they can collapse many metrics into a single visual/pivot and quickly and easily give users flexibility in how they want to see them.

  • GauravSingh
    GauravSingh Rank 5 - Community Champion

    We can use Presentation Variable Plug-in (From Extensions) to achieve this kind of functionality.

  • Aleksander Miler
    Aleksander Miler Rank 1 - Community Starter

    It would be very useful (esp. for creating easy to use but still flexible pre-defined dashboards for consumers)!!! We have customer who is using classic dashboards. They could be interested in migrating to the DV but due to the lack of such functionalities like column selector they are not fully convinced.

  • Jahnavi-Oracle
    Jahnavi-Oracle Rank 6 - Analytics Lead

    This would be useful in DV, as its quite used in classic too.

  • Amrita Gupta-Oracle
    Amrita Gupta-Oracle Rank 6 - Analytics Lead

    This would be a very useful feature indeed.

  • Column selector use cases can be implemented using the new feature in OAC - Parameters.

    Parameters is GA with OAC March 2023 update and for OAS customers is available with the annual 2023 update.

    Parameters in DV allows you to implement the use cases for presentation variables in Classic BI.

    Refer to this you tube videos for details and sample use cases: https://www.youtube.com/playlist?list=PL6gBNP-Fr8KW1B76SZ0Iu_wVBLszEupBC

    We will continue adding more capabilities to Parameters in 2023. Please try out the feature for your use cases and share your feedback with us.

  • Amrita Gupta-Oracle
    Amrita Gupta-Oracle Rank 6 - Analytics Lead

    Thanks for the update Avinash