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.
