Loop & Reduce to remove unwanted sheets or tabs

[#1]

Hi

Suppose my dashboard has 6 tabs(sheets) and each user is given access to certain sheets only through section access. Say, users A can view only 1,3,6 numbered sheets while user B sees 1,4 numbered sheet only. Here, the sheets are just hidden on basis of Section access excel which we maintain for each sheet in the dashboard and assign a 1 or 0 for respective sheets.

Now, if we want to do the same using Loop & reduce, how can we do it? Instead of hiding the sheets, we want to remove the unwanted  sheets from the child dashboards with respect to users.

PS:The userNTname field that we use to apply Section Access is not joined to any tables in the dashboard. Users cannot be categorized on basis of Location, Region,Department etc.

Thanks in advance.

[marcus_sommer]

AFAIK loop and reduce impact only the data within an application and not the GUI - therefore you couldn't remove sheets and objects with them. If you want to control which sheets are available for a certain user (which is strictly seen more a kind of usability and less a security feature) you could use a query to osuser() within the visibility-properties of the sheets.

- Marcus

[vinieme12]

Keen to know what is the identified benefit (s) in comparison to hiding the sheets;   even if this was possible?