Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Reduction & Distribute with Publisher doc with Section Access

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

1 Solution

Accepted Solutions
Not applicable

Re: Reduction & Distribute with Publisher doc with Section Access

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

1 Reply
Not applicable

Re: Reduction & Distribute with Publisher doc with Section Access

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

Community Browser