Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have this nice big dashboard with a dozen tabs I'd like to share out with the company via document cals assigned to other user groups. One tab has individual biometric information I do NOT want to share out with the company. Is there a simple way, say in tab properties, for me to check a checkbox and put in a list of the user groups allowed to view that biometrics tab?
So for the document, I'd have reporting, marketing, tech, and customerservice groups given a document cal to view the document
and for the biometrics tab of the document, I'd want only the tech team to be able to view it, while all those other teams can still view all the other tabs.
I know I could kick the biometrics to their own dashboard, but thought I'd check for a way to do this without piling up (any more) dashboards.
You may try as below approach.
You may try as below approach.
i am agree with chiranjeevi but my suggestion is to use below in Conditional
Lower(osuser())='Domain\loginame1' or lower(osuser())='Domain\loginname2'
hope this helps
you can find an example (.qvw) here
You all rock, all three approaches have their uses. I like the match ouser approach because you can drop a list of users in there and flank them with the match, and it confines itself to the one sheet while leaving the other sheets open. (The = approach works too, but if the list starts getting long you feel it when you have to maintain line by line around the osuser= part.)
The qvw script example made me an unexpected competent at handling section access when I was looking for a shortcut around section access. I did accidentally lock myself out of the sheet for all time when I tried something- because the script applies to all sheets and you can't get into the qvw at all if you're not on one of the lists. It may be great if I have to maintain more than one sheet in a document, but for now I'm just trying to whitelist the one sheet.
Thanks again, problem solved and one less dashboard needed since I can just lock down the sensitive sheet on this one.
Section Access is best Approach ....
Vikas