topic Re: data reduction in qlikview when automatic reloads in QlikView

data reduction in qlikview when automatic reloads

Thu, 29 Sep 2016 09:51:14 GMT

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

Re: data reduction in qlikview when automatic reloads

Gysbert_Wassenaar — Fri, 30 Sep 2016 07:17:28 GMT

Any errors in the log files?

Does the document reload scheduled if you disable section access?

Re: data reduction in qlikview when automatic reloads

stabben23 — Fri, 30 Sep 2016 09:27:50 GMT

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.

Re: data reduction in qlikview when automatic reloads

marcus_sommer — Fri, 30 Sep 2016 11:42:12 GMT

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

Re: data reduction in qlikview when automatic reloads

Mon, 03 Oct 2016 05:46:42 GMT

No errors in Log File

Re: data reduction in qlikview when automatic reloads

Mon, 03 Oct 2016 05:48:59 GMT

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

Re: data reduction in qlikview when automatic reloads

Mon, 03 Oct 2016 05:59:37 GMT

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

Re: data reduction in qlikview when automatic reloads

rupamjyotidas — Mon, 03 Oct 2016 20:49:34 GMT

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

Re: data reduction in qlikview when automatic reloads

Tue, 04 Oct 2016 03:46:11 GMT

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

Re: data reduction in qlikview when automatic reloads

marcus_sommer — Tue, 04 Oct 2016 07:19:22 GMT

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

Re: data reduction in qlikview when automatic reloads

marcus_sommer — Tue, 04 Oct 2016 16:22:21 GMT

Section access meant either on or off - a skipping to a condition isn't possible. But maybe by using the publisher you could use loop and reduce: Reduce and loop by NT username.mp4‌

- Marcus