We are looking to take the logged in Username/Email in Sisenese and compare it against a list, then show/hide specific columns of (pivotcharts) based on the access list.
Below is our tentative plan, but we are hoping that there is a much better way to do this. Any Advice?
Column Identifier - is it possible to target data in a dashboard, including related columns in pivotcharts, based on the column name (ie: SALES_AREA_PLAN_AMOUNT) ?? if not then we may just target based off from the visual presentation column label match, and search thru dom to find the related 'fidx="4"' identifier and use to target all columns in widget to hide/show. We may also just manually hardcode the fidx column reference number.
Widget Identifier - we would likely just iterate through all of a certain type(s) of charts in the dashboard (such as pivotchart), else manually identify by id
Location for the script - current plan to but at dashboard level
Please sign in to leave a comment.