Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a document with 3 tabs, in which one of the tab needs to be restricted and should be available only for a set of users, available in an excel sheet. Additionally, only one group of the users that is available in the excel should get the access (this excel has other purposes for other dashboards).The other 2 tabs should be available to ALL users.
The Excel looks like:
NTNAME | ACCESS | BUDGETACCESS |
ABC | USER | Yes |
BCD | USER | No |
So, here is what i did after loading the excel:
SECTION APPLICATION;
LOAD * INLINE [
BUDGETACCESS,SH07
YES, 1
NO, 0
];
Also, on the restricted tab, i have enabled conditional show with "= sum(SH07)>=1".
I have checked the appropriate checkbox in the Settings/opening.
I have ensured in QMC, the task associated has the section access check box enabled.
With all this, the restriction is not working. Also, for the people who are not in the excel are not able to see the entire dashboard. Ideally, they should be able to see the other 2 tabs.
What am i doing wrong?!
Thanks,
Anitha
Section Access restricts access to your document to those users that are explicitly listed in your Section Access table. No one else will get in, UNLESS you add a line with a * in the NTNAME field and a NO in the BUDGETACCESS field.
Note that if you are not using Data reduction, but only data selection in the settings on the Document Properties->Opening tab, you will not protect your document in any way. Anyone who can add a listbox with the BUDGETACCESS field can select the YES value because it will still be available.
The difficulty with Section Access explanations is that they never describe configuration and operation in its entirety. It's way simpler for you to post an example document, and for us to show what we mean.
Section Application and Section Access script should have below details
1. NTNAME/USERID
2. ACCESS
3. Reduction Fields
in Your Example the table should look like
SECTION APPLICATION;
LOAD * INLINE [
NTNAME, ACCESS, BUDGETACCESS
ABC,USER,YES
BCD,USER,NO
];
Use this Budget Access field to Show/Hide the Sheet.
Section Access restricts access to your document to those users that are explicitly listed in your Section Access table. No one else will get in, UNLESS you add a line with a * in the NTNAME field and a NO in the BUDGETACCESS field.
Note that if you are not using Data reduction, but only data selection in the settings on the Document Properties->Opening tab, you will not protect your document in any way. Anyone who can add a listbox with the BUDGETACCESS field can select the YES value because it will still be available.
The difficulty with Section Access explanations is that they never describe configuration and operation in its entirety. It's way simpler for you to post an example document, and for us to show what we mean.
Thanks for your solution. Once I added the line with a * in NTNAME and moved the users who should have access to a different sheet, the solution worked.
Hi Anitha,
I am facing the same issue and unable to replicate it.Can you share me Sample Qvw for reference or can you share me the detail script that you have used.
Hi Peter,
I am having similar issue.I have two sheets which is Sheet1 and Sheet2. Sheet2 should have access only few people(Not sure how many) but the sheet1 should see everyone.Can you please help me the Sample qvw or detailed script that i can use?.
Thanks in advance!