Section Access

[#1]

There are a million posts about section access and I think reading them is making me more confused.

I am trying to apply simple logic that would look like....

section Access;
LOAD ACCESS,
     USERID,
     PASSWORD,
     GROUP
FROM
[..\Passwords\QV_Passwords.xlsx]
(ooxml, embedded labels, table is CompPlan);

section application;
LOAD USERID,
     SECURITY_DEPT
FROM
[..\Passwords\QV_Passwords.xlsx]
(ooxml, embedded labels, table is CompPlan);

ACCESS	USERID	PASSWORD	GROUP	SECURITY_DEPT
ADMIN	ADMIN	ADMIN	ADMIN
ADMIN	M00768	BMGCOMP	ADMIN
ADMIN	M01122	BMGCOMP	ADMIN
ADMIN	M09849	BMGCOMP	ADMIN
USER	M09000	BMGCOMP	CHIEF	SURGERY

The blanks in Security Department should be ALL departments.  I have tried combinations with * and 'Star is *' (which I still do not understand) but when I run the script the reduction for 'M09000' works correctly and when I sign in as an ADMIN everything is blank.

Is there a way to say ALL departments without listing out every single one (There are quite a few!)??

[#2]

Thanks guys, I think you are right it is difficult to explain without a sample.

I have attached a sample dashboard.  In the section access I am trying to assign each CHIEF to his or her department.  The ADMINs should be able to see all departments (listed and not listed!).

And then part 2 that I haven't tackled yet... The ADMINs should be able to see all tabs but the CHIEFS should only be able to see tab 1.  I found an example that used the GROUP column to achieve this but I haven't tried it yet since I can not seem to get the simple section access to work.

Any advice would be greatly appreciated.

[#3]

Create a field AA

And a table with AA and SECURITY DEPT that will make the link between the generic keys (like ALL) and the real keys of your model:

AA, Security Dept

ALL, Dept1

ALL, Dept2

ALL, Dept3

SURGERY, Dept5
etc.

AA field must be placed into your section access. You can use ALL because it is an existing value now.

Fabrice

[Anonymous · Accepted solution]

Try this

[#5]

Hi Michael,  That seems to be working but I don't understand how.  For section access if you want the person to have access to everything you do not need to list them in the section application part?

[Anonymous]

Katie,

It is the data reduction field where values can be replaced with * or blank or 'ALL.  SECURITY_DEPT is not a data reduction field, hence it doesn't do anything to add these *...
In your application, you use USERID as data reduction field.  Not a good idea because you must have real values there, cant use * nor blanks nor 'ALL'.  What I did:
- Added the new field for data reduction and called it REDUCTIONFIELD.  It is a copy of USERD, except it is blank for ADMIN users.  It could be done in your section access load inline, adding one more column, instead of my join.
- Replaced, in section application, USERID with the new REDUCTIONFIELD, and removed lines with *.

Regards,
Michael

[Nicole-Smith]

Katie,

Here is another option that does use the *.  I have also applied security to the sheets (Sheet Properties > General > Show Sheet > Conditional).

[#8]

Thank you for your help!  I think I still need to do some reading in regards to section access.

[#9]

Hmmm... I hate to keep bothering you but I am testing it and signing in as different people and it seems as though the ADMIN users can only see those departments listed in the section access.  Is there a way to include ALL departments not just those that are listed?

[Anonymous]

Now I don't understand...

First, there are no departments listed in Section Access.  There are fields ACCESS, USERID, PASSWORD, GROUP, and I added REDUCTIONFIELD.  That's it...

Next, I tried again, as all four admin users (ADMIN, M00768, M01122, and M09849) - they can see all Departments.  Including CARDIAC and OBGYN which are not listed in the first load inline of the section application.

Are you sure we're looking at the same application?

[qv_testing]

Hi Michel,

I faced same problem here,

Star is *;

section Access;
LOAD ACCESS,
     USERID,
     PASSWORD,
     GROUP
FROM
[..\Passwords\QV_Passwords.xlsx]
(ooxml, embedded labels, table is CompPlan);

section application;
LOAD USERID,
     SECURITY_DEPT
FROM
[..\Passwords\QV_Passwords.xlsx]
(ooxml, embedded labels, table is CompPlan);

SectionAccess.txt file like this

ACCESS	NTNAME	PASSWORD	GROUP	SECURITY_DEPT
ADMIN	DOMAIN/ADMIN	ADMIN	ADMIN	*
ADMIN	DOMAIN/M00768	BMGCOMP	ADMIN	*
ADMIN	DOMAIN/M01122	BMGCOMP	ADMIN	null()
ADMIN	DOMAIN/M09849	BMGCOMP	ADMIN
USER	DOMAIN/M09000	BMGCOMP	CHIEF	SURGERY

i have column like SECURITY_DEPT some fields  * and  null()

but data it shows wrong....