1 Reply Latest reply on Jul 27, 2016 11:56 PM by Glen Robinson

    Row Level Security, but filters only

    Rahul Ahluwalia

      Here's an interesting one that I haven't been able to solve off the bat. I have 4 parameters that control everything on a dashboard. I only want managers to be able to edit the values in these type-in parameters, and prefer (though not mandatory) that non-managers don't even see the parameters. The dashboard essentially incentivizes people; thus, if a non-manager changes the value, they could game the system and up their bonus which is bad.


      Any idea on how I can enable row-level security on filters/parameters only?


      One idea I thought of was to create a duplicate dashboard, but that only enables filtering on specific sheets, not parameters so it's not really a solution.

        • 1. Re: Row Level Security, but filters only
          Glen Robinson

          Hi Rahul

          When a Dashboard is published to a server, the parameters associated with the dashboard are set to what they were when published.

          You can then change them when using the dashboard, but they aren't saved at that point. ie the next person who uses the dashboard will have parameters set to those when the dashboard was published.


          If you want to allow these parameters to be changed (by managers) then the workbook will have to be re-saved (or republished)

          An option to do this would be to allow managers to have WebEdit permissions to the workbook, where they can change the parameters, and then save the workbook.

          You could Have a workbook with the dashboard as a published View, and a sheet with the parameters on them, but not as a published view.

          ie. The end user sees the published dashboard, where parameters have been set. The Manager is able to webedit the workbook, and has access to a Sheet (which isn't a published view), and can amend the parameters, and then save the workbook.


          The option would work, but im not sure how happy i would be with allowing someone to overwrite the published dashboard.


          Hope this helps