Section Access not working for field types

[matthewp]

I cant get my section access to limit what a user can see within my qv document.

Excel file : section_access.xlsm

Tab name: SA

Data:

User/Admin	Name	NT logon	fieldtype
ADMIN	SVC_QV	server\svc_qv	<ALL>
ADMIN	John Doe	server\abc1	<ALL>
USER	Alan Smith	server\cde2	002
ADMIN	Administrator	server\administrator	<ALL>
USER	Paul Potts	server\fgh3	<ALL>

SECTION ACCESS SCRIPT:

SECTION Access;

trace <<< Section Access >>> ;

LOAD [User/Admin] as [ACCESS],

     [NT logon] as [NTNAME],

     [fieldtype] as [Field Type]

FROM

[Resources\section_access.xlsm]

(ooxml, embedded labels, table is SA)

;

trace <<< Section Application >>> ;

SECTION Application;

FIELD SCRIPT:

field:

LOAD [f ID],

     [f Type] AS [Field Type],

     [f Name] AS [Field Name]

FROM

$(vDetailsQVDDirectory)FIELD_LOAD.qvd

(qvd);

[Chanty4u]

try with UPPER()

SECTION Access;

trace <<< Section Access >>> ;

LOAD [User/Admin] as [ACCESS],

    UPPER( [NT logon]) as [NTNAME],

     UPPER([fieldtype] )as [Field Type]

FROM

[Resources\section_access.xlsm]

(ooxml, embedded labels, table is SA)

;

trace <<< Section Application >>> ;

SECTION Application;

FIELD SCRIPT:

field:

LOAD [f ID],

    UPPER( [f Type])  AS [Field Type],

     UPPER[f Name] ) AS [Field Name]

FROM

$(vDetailsQVDDirectory)FIELD_LOAD.qvd

(qvd);

[matthewp]

Still the same after reload, [Field Type] is a number if that makes any difference?

[jonathandienst]

I am assuming that <ALL> means all items rather than a specific value of <ALL> in your fact table. You will need a generic key approach here. This article will help you   Generic keys

Also the fields used in section access should all be in upper case, so you might need to rename [Field Type] to [FIELD TYPE]

[matthewp]

Changed the Aliases to upper case and still the same

[Anil_Babu_Samineni]

I Tried same thing. It's working perfect

ACCESS	NTNAME	SECURED_COMPANY	PASSWORD
ADMIN	ABC	ALL
ADMIN	DEF	A;B;C
ADMIN	GHI	A;D;F
USER	JKL	*
ADMIN	MNO	ALL
USER	PQR	ALL

Then Try Something like

Security:

NoConcatenate

LOAD ACCESS,

     NTNAME,

     SECURED_COMPANY,

     PASSWORD

FROM

Path

(ooxml, embedded labels, table is Sheet1);

Try this

User/Admin	Name	NT logon	fieldtype
ADMIN	SVC_QV	server\svc_qv	ALL
ADMIN	John Doe	server\abc1	ALL
USER	Alan Smith	server\cde2	002
ADMIN	Administrator	server\administrator	ALL
USER	Paul Potts	server\fgh3	ALL

[stigchel]

Have you checked the initial data reduction based on section access? It is in menu Settings\Document properties the opening tab