Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Data reduction - automatic reloads with the distribution service

@@ ! 

We have an issue facing in data when automatic reloads with the distribution service.

 

 

The data is not loading fully when automatic reloads runs at morning using the service account(distribution service).

 

 

But when reload manually with the same service account , the data is loading perfectly. .

 

 

The Initial Data Reduction Based on Section Access & Strict Exclusion are checked. We have section access defined as below  .

 

 

                        

 

ADMIN

QLIKVIEW ADMIN1

BENZ\qadmin1

ALL

ALL

ADMIN

QLIKVIEW ADMIN1

qadmin1

ALL

ALL

 

Section Access;
LOAD ACCESS, NAME, NTNAME, IF(GROUP='ALL','*', GROUP) as 'Stock Group', // STOCK
   IF(GROUP='ALL','*', GROUP) as Group, // PARTS SALE
   IF(GROUP='ALL','*', GROUP) as GROUP., // LABOUR LOG
   IF(GROUP='ALL','*', GROUP) as GROUP.., //CLOCK ENTRIE
   IF(BRANCH='ALL','*', BRANCH) as Branch, IF(BRANCH='ALL','*', BRANCH) as 'Branch Name', // W.Revenue Branch
   IF(BRANCH='ALL','*', BRANCH) as Branch.Name  // W.Analysis Branch
   FROM

(
ooxml, embedded labels, table is [P&W]);
Section Application;

   

Please let me know any settings has to be change

4 Replies
Peter_Cammaert
Not applicable

Re: Data reduction - automatic reloads with the distribution service

How do you know that not all data is getting loaded? How did you check this? Did you open your document in QV Desktop using an ADMIN account? Maybe the data gets reduced for everybody.

As a test, add an ADMIN account with empty link fields to your section access table, reload and open your document in QV Desktop using that account.

Note that your observation that all data is loaded when reloading in QV Desktop is correct, because Section Access will only reduce your data model at file open time and never afterwards. So a reload always returns a full data set, until you save-close-reopen the document. At that moment Data reduction is applied on the new data set as well.

Best,

Peter

Not applicable

Re: Data reduction  - automatic reloads with the distribution service

Hi Peter,

Thanks for the answer.

We got a complaint from the user  for a particular group , the data is not loading correctly and also when we compare with our DMS application.

Upon further analysis , we tried to manual reload the document with the same service account and the data is loading correctly.

Then we tried the remove the code from the  section access code and data was loading correctly when  ran from the publisher .

Hence we finalized , it was problem with the section access.

Thanks,

Jojee

rupamjyotidas
Not applicable

Re: Data reduction - automatic reloads with the distribution service

Why not separate the two process

1) One QVW file to load the data and store in QVD without Section Access

2) Load the QVD in the Final APP with Section Access

Peter_Cammaert
Not applicable

Re: Data reduction - automatic reloads with the distribution service

Ok, so you'll have to focus on the way Section Access reduces the data for particular users.

There is an easy and very useful technique to simulate data reduction as far as possible. It simply consists of opening your misehaving document in QV Desktop, commeting out the statement Section Access; and reloading the document. You don't need to close it. Now your data model will contain an extra field called NTNAME (or even NAME). Put this field as a liustbox on a sheet and in this field select the user that is experiencing problems. You are now simulating data reduction as much as possible. Investigate what is happening in your data model.

You will probably find the real cause of this data reduction malfunction.

Do not forget to remove the comment marker after you're done investigating or your document will show everything top everyone.

Best,

Peter