Section access to provide access to all data to a few users

[#1]

Hi,

I am trying to create a document with section access. I am using a reduction field to reduce the data on inital load based on user login. I need a way to display all the data to most of the users and only selected data to a few users. For example:

I am putting in section application section the following:

section access;

Directory $(vQVDPath);

LOAD NTNAME,

     ACCESS,

     GROUP

FROM

[Access Permissions.xlsx]

(ooxml, embedded labels, table is [User-Group]);

section application;

Directory $(vQVDPath);

LOAD GROUP,

          Currency

FROM

[Access Permissions.xlsx]

(ooxml, embedded labels, table is [Group-Permissions]);

In the Group-Permissions sheet, I have the following:

GROUP          CURRENCY

GRP1               USD

GRP2               GBP

GRP3               JPY

GRP4                ????

My question is on group 4. My data has more than 20 currencies. I want GRP4 to be able to view all these 20 currencies and GRP1, GRP2, GRP3 only 1 currency each as per the table above. I have tried using * but that essentially means that GRP4 will be able to access only USD, GBP and JPY. I tried leaving it blank but in that case GRP4 doesn't get access to any currency.

Please let me know if there is a way to solve this.

Thanks.

[amars]

Hi,

You can use all the 20 currencies in ur Section Application Against GRP4,

See Attached Example

LOAD * INLINE [
    Value, Currency
    1000, USD
    2000, GBP
    2500, JPY
    3000, INR
    2200, SGD
    1400, DNR
];

Section Access;
LOAD * INLINE [
    ACCESS, USERID, PASSWORD, GROUP
    User, ABC, *, GRP1
    User, PQR, *, GRP2
    User, XYZ, *, GRP3
];
Section Application;
LOAD * INLINE [
GROUP, Currency
GRP1, USD
GRP2, GBP
GRP3, USD
GRP3, GBP
GRP3, JPY
GRP3, INR
GRP3, SGD
GRP3, DNR
];

Note:- While using Section Access rather than using "Initial data reduction based on section Access", use "Initial data selection based on Section Access" until ur testing is complete.

Thanks