How to set default value for a dashboard prompt based on user role. — Oracle Analytics

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

How to set default value for a dashboard prompt based on user role.

Received Response
42
Views
8
Comments
Chandra kanth
Chandra kanth Rank 3 - Community Apprentice
edited Aug 13, 2024 6:59PM in Oracle Analytics Cloud and Server

Hi All,


I have "PLAN" dashboard prompt which has list of values.


The  "plan" filter in the dashboard prompt, should be set differently according to the selected responsibility.


Example: for Master Scheduler responsibility the plan should be populated with MPS-Current.

For Planner Buyer and Test Scheduler with MRP-Plan Current and for the S&OP Process Owner SOP-Plan current.


How to achieve this? Please let me know.


This should be for all dashboards/reports which is filter is there.


Regards,

Chandra kanth.

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Session variable.

    By its very nature a user-centric variable initialized per session based on a query.

  • Chandra kanth
    Chandra kanth Rank 3 - Community Apprentice

    Hi,

    Please let me know the approach how to do this one.

    regards,

    Chandra kanth.

  • Community DW Integration
    Community DW Integration Admin

    This is a good site! come on and join with us!

    agen bola , poker online

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    1.) Google "obiee session variable"

    2.) Read

    3.) Do

    Took ME longer to write this than it would you to find the answer. Add to thar the time delay vetween question and responsw and you see why it's actually clever to invest at least a minimum of effort oneself and not wait to be spoon-fed. Plus you also won't ever learn anything.

    Screenshot_20160428-113426.png

  • Chandra kanth
    Chandra kanth Rank 3 - Community Apprentice

    HI,

    Please let me know how to keep other values along with default value which will be set using session variable based on role.

    EG: for the user: Master Scheduler the default value is: MPS-Current. Along with MPS-Current i should have remaining values.

    How to achieve this. Similarly for other users also.

    Regards,

    Shubham Chandra.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    @Gianni Ceresa take over I'm back off to the beach :-P

  • Gianni Ceresa
    Gianni Ceresa Mod

    Thanks Christian

    Shubham,

    Just to be clear: you want to have a variable list of values in the prompt based on the role or it's only the default selected value that must change but the list of values is always the same? (it changed between your first post and the last one ...)

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    It's just about what SQL statement to write in the init block.. that's all but I don't feel like doing someone's homework today.

    https://twitter.com/thatjeffsmith/status/724973984924733440