Reduction & Distribute with Publisher doc with Section Access

[#1]

Hi all,

I have an app with Section Access like that:

LOAD 

upper('ADMIN')         AS ACCESS,

upper(EMPLIDAC)   AS NTNAME,

upper(EMPLIDAC)   AS LOGIN

FROM QVD_SEGUR.qvd

One Field has connection with data model: LOGIN.

I need to reduce data by other field (office) and generate one .qvw per office.

Each office has several LOGIN and we need to create one doc per office but each doc has all estructure of section access.

The doc has a "Initial data reduction based on section access" and "Strict exclusion".

When I run reduction in Publisher per office it works ok, but I have just one user, the user of service. This person is the one who opens the doc to make the reduction and distribution.

The problem is didnt keep all users in section access.

I hope explained well.

Thanks

[#2 · Accepted solution]

I found the solution,

Just including "NOREDUCTION" in line of user of service:

LOAD * INLINE [
    ACCESS, NTNAME, LOGIN, LOGIN2, EMPLPUES
    ADMIN,"QLIKVIEWSERVICE",NOREDUCTION
  ];

This ensures that if the document is opened with this user, the reduction is not performed if the doc has "Initial data reduction based on section access" and "Strict exclusion".

I hope its useful

Regards