Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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