Oracle Transactional Business Intelligence

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

Dashboard (Launchpad) - Links Hidden/Unhidden based on role ?

Received Response
21
Views
2
Comments
ScottHillier
ScottHillier Rank 2 - Community Beginner

Hi folks

I've a request to build a dashboard which acts as a launchpad to a series of reports. (Rather than running the reports through the catalog)

The request is that only certain links/buttons appear depending on the role of the person in the launchpad.

I know you can set access to the dashboard itself based on role but is it possible to dynamically show/hide links based on roles does anyone know ?

Thanks a lot

Scott

Answers

  • Nathan CCC
    Nathan CCC Rank 7 - Analytics Coach
    edited August 13

    Yes you can show hide a dashboard based on role.

    But you can also show hide a page or sections on a page using permissions by role. So possibly a page/section for each?

    Alternative…

    If your analytics and repots are on dashboards then you can add a condition to each section on a page.

    show if query return rows, hide if no rows - maybe using something like of following query to see if this user has a role XX - you will have to grant the transaction analysis duty role for this SA to all users

    select all 0 s_0
    , "User"."User Name" as user_name
    , "Role"."Role Name" as role_code
    , "Role Facts"."Number of Users" as measure
    from "Security - Roles and Privileges Real Time"
    where "User"."User Name" = valueof(NQ_SESSION."USER")
    and "Role"."Role Name" in ('xx'))
    FETCH FIRST 7 ROWS ONLY

  • ScottHillier
    ScottHillier Rank 2 - Community Beginner

    @Nathan CCC Great approach! I like it. Thank you very much for that. That should do the job I'd say.😀👍️