topic Re: Section Access is not reducing data in QlikView

Section Access is not reducing data

cjzimm76 — Mon, 14 Jan 2013 18:48:43 GMT

I am using QV 11 and QVS 11 with publisher. I am trying to reduce data using section access but when I open the dashboard (desktop or via Access Point) the date is not reduced.

Here is my code.

SECTION ACCESS;

LOAD * INLINE [
    ACCESS, NTNAME, PROJDIV
    ADMIN, IT\QLIKVIEW,
    ADMIN, IT\ABC, BS
    USER, IT\XYZ, GA
];
SECTION APPLICATION;

DivisionGroups:
LOAD * INLINE [
    GROUP, PROJDIV
     BDEV, GA
     G&A, GA
     IT, BS
     FS, BS
];

I go to Settings>Document Properties>Opening tab and check the check box for Initial Data Reduction Based on Section Access. Hit Apply, then OK. I save the document and then copy it to my QV Server. I create a task to reload and publish the dashboard. On the Reload tab of the task, I check the Section Access check box and enter the service account and password. The task runs successfully. But the data is not reduced. Am I missing something?

And I did notice that when I go back into the Document Properties, that the check box for Initial Data Reduction Based on Section Access is no longer checked. Why is that?

Re: Section Access is not reducing data

chematos — Mon, 14 Jan 2013 19:33:29 GMT

Check that the last chackbox is selected in Security menu at Document Properties and Strict Exclusion after Data Reduction Based on Section Access at Settings>Document Properties>Opening tab

What field you want to reduce??

Re: Section Access is not reducing data

cjzimm76 — Mon, 14 Jan 2013 19:42:16 GMT

I am trying to reduce the data on the PROJDIV field.

Re: Section Access is not reducing data

cjzimm76 — Mon, 14 Jan 2013 21:38:05 GMT

I found a section access example .qvw and I can get it to work. But I take the code from the example .qvw file and put it into a new .qvw file to build it from scratch and it doesn't work. But if I take my code from my .qvw and put it into the demo .qvw file it does work. What could possibly be the difference in 2 files? Either set of code works in one file, but neither works in another file.

In my file I still can't get the check box for Data Reduction Based on Section Access to stay checked.

Re: Section Access is not reducing data

cjzimm76 — Mon, 14 Jan 2013 22:03:49 GMT

I found the only difference between my file and the demo file to be the version of QV. If I change my file back to V10, then it works. Anyone have any idea what would need to be done to get it to work in V11?

Re: Section Access is not reducing data

Thu, 20 Feb 2014 15:36:49 GMT

I am having a similiar issue to this