Functionality to set default values in a prompt dynamically (like in classic obiee). We can use list — Oracle Analytics

Oracle Analytics Cloud and Server Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› Oracle Analytics Cloud and Server Idea Lab

Categories

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

Functionality to set default values in a prompt dynamically (like in classic obiee). We can use list

Delivered
192
Views
3
Comments
Vinaykumar Byahatti
Vinaykumar Byahatti Rank 2 - Community Beginner
in Oracle Analytics Cloud and Server Idea Lab

Organization Name

Schneider Electric Industries SAS

Description

The ask is to set default value sin the prompt. For example, there's a prompt of Year and based on result of Sql query, it should auto populate the current year. 

Use Case and Business Need

It reduces users time on the dashboard if we can prefill the prompts dynamically. Also, user need not worry what defaults to set while accessing the visual. 

 

Thanks,

Vinay

Original Idea Number: 569d763329

Tagged:
12
12 votes

Delivered · Last Updated

This is a planned feature (and active), however it is not a small project and specific timelines will only be available closer to delivery.

Comments

  • User_GL5YJ
    User_GL5YJ Rank 1 - Community Starter

    Easier business adoption when filters are cleverly defaulted. It also reduces the number of unnecessary queries to the database with filter options that the user is not interested in, before she has made her filter choices.

  • Adam Bloom-Oracle
    Adam Bloom-Oracle Mod

    We do have some plans in this area similar to using Presentation Variables in Dashboard Prompts.  No dates or specs to share at this point, but definitely something we've been looking into.

  • Avinash Krishnaram-Oracle
    Avinash Krishnaram-Oracle Mod

    Parameters in DV allows you to implement the use cases.

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

    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.