Section Access and Multi Box value display based on user profile (Group)

[Anonymous]

i have the following  Section Access load:

Section Access;
Directory;
LOAD ACCESS,
USERID,
PASSWORD,
RETAILPHARMACY,
OMIT,
  NTNAME,
PATENTS,
FDA,
GENERICS,
SHOPPING,
PLAZA_ANALYTICS,
VIEWGROUP
FROM
[..\Data Files\SectionAccess.xlsx]
(ooxml, embedded labels, table is SectionAccess);

SECTION Application;

VIEWGROUP:
LOAD VIEWGROUP,
_View
FROM
[..\Data Files\MenuViewGroup.xlsx]
(ooxml, embedded labels, table is ViewGroup);

and the tables are as follows:

SectionAccess table

ViewGroup TABLE

The application is only allowing the ADMIN ACCESS to the application with all users being denied access to the document.  What could be wrong with the the structure of the Section Access above?

The _View field is meant to associate with another field _View which has the following load script:

SET HidePrefix = '_';
View:
LOAD * Inline [
_View
Dashboard
Point in Time Reporting
Leading Therapeutic Classes (Level 1)
Leading Therapeutic Classes (Level 3)
Leading Companies
Leading Products
Leading New Products
Payment Method Summary
Co-payment Summary
Fastest Growing Therapeutic Classes (ATC3)
Comparative Analysis
Trend Analysis
Product Analytics
Generic Products Opportunity Analysis
Patent Analytics
FDA Analytics
Shopping Analytics
Pharmacy Analytics
];

The above values are then loaded into a multi box with the following results.

I would want an expression to dynamically change what is listed in the multi box based on the USER profile or VIEWGROUP.  How can this be accomplished?

Regards.

[Anonymous]

Dear All

I managed to sort out the second portion of my problem.  I  used the following expression to change multi box display based on user ViewGroup:

  =If(VIEWGROUP = 'VIEWALL' , _View, if(VIEWGROUP = 'BASICSHOPPLAZA', If(Not Match(_View, 'Patent Analytics', 'FDA Analytics', 'Generic Products Opportunity Analysis'), _View), If(VIEWGROUP = 'BASIC',If(Not Match(_View, 'Patent Analytics', 'FDA Analytics', 'Generic Products Opportunity Analysis', 'Pharmacy Analytics', 'Shopping Analytics'), _View), If(VIEWGROUP = 'BASICSHOPMEDIX',If(Not Match(_View, 'Patent Analytics', 'FDA Analytics', 'Generic Products Opportunity Analysis', 'Pharmacy Analytics'), _View)))))

Document still locked out for all users despite a first success open after reloading the first time.  On trying the second time, it fails to open for all users except admin.

Regards

[Anonymous · Accepted solution]

With Section Acces, the problem was the lower case in the field _View. Re-did as follows;

VIEWGROUP:
LOAD VIEWGROUP,
Upper(_View) as _VIEW
FROM
[..\Data Files\MenuViewGroup.xlsx]
(ooxml, embedded labels, table is ViewGroup);

and the tables are as follows: