question on section access

[Anonymous]

I am trying to give section access to users. and Use the NIH_IC as a variable in the report. vIC=only(NIH_IC). . do I have to store this field somewhere.

- I reload the file after saving the excel. attached is the excel. Please suggest.

Here is the script.

SECTION ACCESS;

trace <<< SECTION ACCESS >>> ;

SAccess:
LOAD ACCESS,
NTNAME,
NIH_IC
FROM
[\\nihdqv1\03_SourceDocuments\03.ICS\CIT\Admin Testing\EO Dash Development\Final Version\Padma\V1\SectionAccess.xlsx]
(ooxml, embedded labels, table is Sheet1);

trace <<< SECTION APPLICATION >>> ;

SECTION APPLICATION; 

[#2]

section access will identify what type of user you are (admin or user) and tries to reduce the datamodel (or island tables) based on what fields that you have given. in your example you should have NIH_IC field some where in your data model (or island table)

[marcus_sommer]

Here a lot of useful links to this topic: Section Access‌

- Marcus