Section Access not working in a server

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi QV Experts,

Qlikview secion access is working fine in my qlikview desktop but not in server. I searched and referred lot of posts but end with failures.

Similar post like below and not able to fix the issue.

Could you please help on this

Section Access Problem - AccessPoint / NTNAME

TempAuthorizationTable:

Load NTNAME, ACCESS, REGION &'_' & [SUB REGION] & '_' &COUNTRY & '_' &SEGMENT & '_' & BU & '_' & FUNCTION AS %KEY;

LOAD

ACCESS,

NTNAME,

If(REGION ='*', '<ANY>', REGION) AS REGION,

If([SUB REGION] ='*', '<ANY>', [SUB REGION]) AS [SUB REGION],

If(COUNTRY ='*', '<ANY>', COUNTRY) AS COUNTRY,

If(SEGMENT ='*', '<ANY>', SEGMENT) AS SEGMENT,

If(BU ='*', '<ANY>', BU) AS BU,

If(FUNCTION ='*', '<ANY>', FUNCTION) AS FUNCTION

FROM

[..\..\ExternalData\Finance Cost Center\Cost Center - Section Access.xlsx]

(ooxml, embedded labels, table is [Section test]);

Section Access;

Load ACCESS, NTNAME, %KEY Resident TempAuthorizationTable;

Section Application;

Drop Table TempAuthorizationTable;

CostCtrDept:

LOAD *,

[Region Code] &'_'& [Sub Region Code] &'_'& [Country Code] &'_'& SEGMENT_SHORTNAME &'_'& [Business Unit Code] & '_'& [Functional Area ID] AS KEY

Resident CostCenterDept;

//inner join(CostCtrDept)

SLogic:

//NO ANY

LOAD Distinct KEY, [Region Code] &'_'& [Sub Region Code] &'_'& [Country Code] &'_'& SEGMENT_SHORTNAME &'_'& [Business Unit Code] & '_'& [Functional Area ID] AS %KEY Resident CostCtrDept;

//1 ANY

LOAD Distinct KEY, [Region Code] &'_'& [Sub Region Code] &'_'& [Country Code] &'_'& SEGMENT_SHORTNAME &'_'& [Business Unit Code] & '_'& '<ANY>' AS %KEY Resident CostCtrDept;

LOAD Distinct KEY, [Region Code] &'_'& [Sub Region Code] &'_'& [Country Code] &'_'& SEGMENT_SHORTNAME &'_'& '<ANY>' & '_'& [Functional Area ID] AS %KEY Resident CostCtrDept;

LOAD Distinct KEY, [Region Code] &'_'& [Sub Region Code] &'_'& [Country Code] &'_'& '<ANY>' &'_'& [Business Unit Code] & '_'& [Functional Area ID] AS %KEY Resident CostCtrDept;

LOAD Distinct KEY, [Region Code] &'_'& [Sub Region Code] &'_'& '<ANY>' &'_'& SEGMENT_SHORTNAME &'_'& [Business Unit Code] & '_'& [Functional Area ID] AS %KEY Resident CostCtrDept;

LOAD Distinct KEY, [Region Code] &'_'& '<ANY>' &'_'& [Country Code] &'_'& SEGMENT_SHORTNAME &'_'& [Business Unit Code] & '_'& [Functional Area ID] AS %KEY Resident CostCtrDept;

LOAD Distinct KEY, '<ANY>' &'_'& [Sub Region Code] &'_'& [Country Code] &'_'& SEGMENT_SHORTNAME &'_'& [Business Unit Code] & '_'& [Functional Area ID] AS %KEY Resident CostCtrDept;

//6 ANY

LOAD Distinct KEY, '<ANY>' &'_'& '<ANY>' &'_'& '<ANY>' &'_'& '<ANY>' &'_'& '<ANY>' & '_'& '<ANY>' AS %KEY Resident CostCtrDept;

DROP Table CostCenterDept;

Re: Section Access not working in a server

MK9885 — Tue, 10 Oct 2017 18:03:52 GMT

I must say your section access script looks complicated.

Usually mine is jut Section Access script and the fields are being read from Data model.

You are limiting data based on what field? Any way, try using star is * and test it.

STAR is *;

Section Access;

Load ACCESS, NTNAME, %KEY Resident TempAuthorizationTable;

Section Application;

Re: Section Access not working in a server

Gysbert_Wassenaar — Sun, 15 Oct 2017 13:21:34 GMT

Make sure all the field values in the section access table and the %KEY field values in the rest of your data tables are also in upper case just. So not just the field names, but the field values as well.

Re: Section Access not working in a server

dionverbeke — Sun, 15 Oct 2017 14:33:08 GMT

Most of the time it is the Service Account not being added.

Dion

topic Re: Section Access not working in a server in QlikView

Section Access not working in a server

Re: Section Access not working in a server

Re: Section Access not working in a server

Re: Section Access not working in a server