Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
@@ !
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
(
Section Application;
Please let me know any settings has to be change
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
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
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
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