Data reduction - automatic reloads with the distribution service

[#1]

@@ ! 

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

[Peter_Cammaert]

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

[#3]

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]

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]

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