Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
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;
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.
Most of the time it is the Service Account not being added.
Dion