topic Re: ntname in the section of access in QlikView

ntname in the section of access

Sat, 05 Nov 2011 00:44:22 GMT

I'm using ntname in the section of access but it does not work:

Syntax.:
Access Ntname division id
01 user rolandog

table division
division id description
01 bird-
02 food

use in above script and it does not work and also activates the initial reduction option based data access section.

please help

ntname in the section of access

Sat, 05 Nov 2011 10:02:48 GMT

Please make sure that SECTION ACCESS is in uppercase.

I think, in your syntax fields should be interchanged. ACCESS is 01?

Kiran.

ntname in the section of access

Sat, 05 Nov 2011 19:59:33 GMT

Corrected:
Syntax.:
SECTION ACCESS;
LOAD * INLINE [
Access, Ntname, division id
USER, rolandog, 01
];

APPLICATION SECTION;

division table:
LOAD
division id, description
01, bird-
02, food

SELECT * FROM DIVISION

please help

Re: ntname in the section of access

Miguel_Angel_Baeyens — Sun, 06 Nov 2011 02:25:08 GMT

Hi Rolando,

Fields must be uppercase in all tables within and out of the section access part, as Kiran says. Check the script in the attached application.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Re: ntname in the section of access

Mon, 07 Nov 2011 19:29:14 GMT

THANKS FOR THE HELP

With the following script, ME LIMITED TO ALL USERS TO DIVISION 01.
USERS JUANA, FMK, ROLANDOG should have access to everything, but does not work.

SECTION ACCESS;

LOAD * INLINE [
ACCESS, NTNAME, DIVISIONID
ADMIN, GRUPOMELO \ JUANA, *
ADMIN, GRUPOMELO \ FMK, *
USER, GRUPOMELO \ AIDAR, 01
ADMIN, GRUPOMELO \ ROLANDOG, *
];

SECTION APPLICATION;

Re: ntname in the section of access

Miguel_Angel_Baeyens — Mon, 07 Nov 2011 20:34:45 GMT

Hi Rolando,

That is correct. the "*" sign in the section access doesn't mean "all possible values" but "all values listed in section access". In this case, indeed, the only value for DIVISIONID is 01, so the "*" equals to 01.

Now it depends on the environment you are using. If you are using QlikView Server, then you will need to add each possible value (even if they are thousands) to the section access list for one user, so the "*" has the proper meaning of "all values",

SECTION ACCESS;

LOAD * INLINE [
ACCESS, NTNAME, DIVISIONID
ADMIN, GRUPOMELO \ JUANA, 01

ADMIN, GRUPOMELO \ JUANA, 02

ADMIN, GRUPOMELO \ JUANA, 03

ADMIN, GRUPOMELO \ JUANA, 04

ADMIN, GRUPOMELO \ JUANA, 05

ADMIN, GRUPOMELO \ FMK, *
USER, GRUPOMELO \ AIDAR, 01
ADMIN, GRUPOMELO \ ROLANDOG, *
];

SECTION APPLICATION;

Now users JUANA, FMK and ROLANDOG will see records related to DIVISIONID 01, 02, 03, 04 and 05. You can use either a different field instead of DIVISIONID, some field that aggregates several possible values (GroupID, DivisionGroup or something like that).

But if you are using QlikView Desktop instead of QlikView Server (you don't have QlikView Server) then just leave field DIVISIONID blank instead of using the "*" sign. Then those users will have see all values of that field.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Re: ntname in the section of access

Mon, 07 Nov 2011 21:15:59 GMT

thanks for the help.

I am using a QlikView Server.

Rolando

ntname in the section of access

Wed, 18 Jan 2012 20:59:11 GMT

This was helpful. First off, the all caps NTNAME of DOMAIN\USER helped, and how I load my users (via SQL scripts) have to come after the Section Access statement.

Thanks,

Jeff G

Re: ntname in the section of access

Tue, 07 Oct 2014 12:35:22 GMT

hi,

I have a concern in section access. can u pls help?

If I have a hierarchy of users, then how am i going to achieve section access?

Re: ntname in the section of access

kkkumar82 — Wed, 05 Nov 2014 09:49:49 GMT

hi,

I think you have to create a separate row for each user with the top hierarchy person or dimension value.