Section Access Through Excel Files

[hamdaniahmad]

Hi All,

I have some questions here, I create section access in qvw files using excel and I try to load in script, and I try to load table with same file.

And the problem is, why data always showing all data table and not same with section access login?

I want data show same with section access login, is there any settings need to set?

Thank You.

section access;

LOAD ACCESS,

          USERID,

          PASSWORD

FROM

[..\Sheet_access.xlsx]

(ooxml, embedded labels, table is Sheet1);

section application;

[Sheet Level]:

LOAD USERID,

          Tab1,

          Tab2,

          Tab3,

          Tab4,

          Tab5

FROM

[..\Sheet_access.xlsx]

(ooxml, embedded labels, table is Sheet2);

[prieper]

In the Document-Settings you need to tickmark under "Opening" the fields "Initial Data Reduction...." and "Strict Exclusion".

When running the script you can see all data (ADMIN-property).

HTH Peter