Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

data reduction in qlikview when automatic reloads

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  .

   

ADMINQLIKVIEW ADMIN1BENZ\qadmin1ALLALL
ADMINQLIKVIEW ADMIN1qadmin1ALLALL

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 what could be the reason.

10 Replies
Gysbert_Wassenaar

Any errors in the log files?

Does the document reload scheduled if you disable section access?


talk is cheap, supply exceeds demand
stabben23
Partner - Master
Partner - Master

Hi,

I have strugeling a lot With this, when you run it from Publisher it seams that only ONE ADMIN is allowed and that is the service account. Try to delete one of the ADMIN and reload it from Publisher.

marcus_sommer

Section access has no influence to the records which will be loaded - section access will restrict the data (by reducing the data) to the set authorization while opening an application. Are after opening the application through an administrator who should see all data not all data available then you hadn't authorized all available data. The use of "*" as wildcard worked only to real values and not for NULL which couldn't considered in any way (unless you replaced NULL with something like 'Null').

- Marcus

Not applicable
Author

No errors in Log File

Not applicable
Author

When I removed the code in the section acess and run from the Publisher , it is loading all the data.

Not applicable
Author

Hi ,

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
Specialist
Specialist

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

Not applicable
Author

Hi Rupam,

Many thanks the reply.Is there any way to skip the session access code while reloading through the service account or from the publisher.

Thanks,

Jojee

marcus_sommer

This meant that not all of your values from your authorization-keyfield have a valid counterpart and therefore those data will be reduced/removed. Now it's on you to decide if you have a topic with the data-quality which needs to be fixed or not.

- Marcus