3 Replies Latest reply on Dec 11, 2018 3:30 PM by Joe Oppelt

    Completely hide a dashboard using row level security

    Tyson Andrews

      Hello,

       

      I have two dashboards in a workbook., a group overview, and details about those group.  I have implemented row level security (a simple username = userID) to filter what data everyone can see.

       

      Is there a way to completely hide the first dashboard if they don't have full access? Essentially only execs will want to see the first dashboard, and everyone else just needs to see the details of one specific group on the second dashboard. I would like for them not to even see the first one. Is this possible?

       

      Thank you,

      -Tyson Andrews

        • 1. Re: Completely hide a dashboard using row level security
          Patrick Van Der Hyde

          Tyson,

           

          You might be able to craft something like that with a sheet selector - Sheet Selection on Steroids | VizPainter  - but why not just provide two different views? One for your Exec folks and another to the rest of the group? 

           

          Patrick

          • 2. Re: Completely hide a dashboard using row level security
            Tyson Andrews

            Patrick,

             

            I appreciate the time, We ended up just doing two different views. There wasn't a 100% clean solution.

             

            Again, thank you!

            -Tyson

            • 3. Re: Completely hide a dashboard using row level security
              Joe Oppelt

              I have some dashboards that certain users aren't allowed to view.

               

              I have users placed into Groups (set on Server).  Power users can see the dashboard (and only power users get the buttons that have the actions to navigate to the dashboard, but nothing stops the general users from clicking the tab at the top to go to the dashboard.)  General users should not see it.


              When a general user goes to that dashboard, I have a pop-out that covers the whole dashboard.  It is a sheet that simply says, "you are not authorized to view this dashboard.  Click here to return to the main dashboard."  And at that point all they can do is click it.  And that sheet has an action to go to the main dashboard.

               

              If you are using ISUSERNAME() to control the users, you can do the same thing.  I just use ISMEMBEROF(), which looks at the group level.  (And if you have multiple users who can see that dashboard, it's a whole lot easier to manage them at the group level, in my opinion.  Further, and people come and go, you just manage it on the server, and no usernames are hardcoded in the calcs that control this.