topic Re: Load table without applying Section Acess in QlikView

Load table without applying Section Acess

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

I am trying to implement Section Access

SECTION ACCESS;

LOAD * INLINE [

ACCESS, USERID, EMPLOYEEID,OMIT

ADMIN, ADMIN

USER, UK, 4,ShipRegion

USER, USA, 1,Shipregion

USER, USA, 3,Shipregion

USER, USA, 2,Shipregion

];

SECTION APPLICATION;

OLEDB CONNECT TO [SQL Connection String]);

SQL SELECT [OrderID]

,[CustomerID]

,[OrderDate]

,[EmployeeID] AS EMPLOYEEID

,[RequiredDate]

,[ShippedDate]

,[ShipVia]

,[Freight]

,[ShipName]

,[ShipAddress]

,[ShipCity]

,[ShipRegion]

,[ShipPostalCode]

,UPPER([ShipCountry]) AS REGION

FROM Orders;

SQL SELECT EMPLOYEEID,EMPNAME FROM

FROM Employee;

For Employee table also it is applying Section Access. Is there any way that no Section Access is applied to Employee table (means to load complete Employee table irrespective of Section Access)

Re: Load table without applying Section Acess

devarasu07 — Tue, 29 Aug 2017 03:29:22 GMT

Hi,

we can't exclude table from section access. may be you can check this below advise

Exclude a table from section access | Qlik Community

Re: Load table without applying Section Acess

Anonymous — Wed, 30 Aug 2017 04:11:14 GMT

How to create data Island from sql server.

Also, can I use the data Island create in above step for view and without applying section access on data Island

Re: Load table without applying Section Acess

Miguel_Angel_Baeyens — Wed, 30 Aug 2017 07:31:30 GMT

Basically you need to add all possible values in the key field for the table and the table will not be reduced, schematically something like this:

SECTION ACCESS;

SectionAccessTable:
LOAD DISTINCT
  'ADMIN' AS ACCESS,
  'DIR\ADMIN' AS NTNAME,
  COUNTRY,
  '*' AS EMPID
FROM Invoices.qvd (qvd);

CONCATENATE (SectionAccessTable)
LOAD DISTINCT
  'ADMIN' AS ACCESS,
  'DIR\ADMIN' AS NTNAME,
  '*' AS COUNTRY,
  EMPID
FROM Employees.qvd (qvd);

CONCATENATE (SectionAccessTable)
LOAD * INLINE [
ACCESS, NTNAME, COUNTRY, EMPID
USER, DIR\USERSPAIN, SPAIN, *
USER, DIR\USERFRANCE, FRANCE, *
];

SECTION APPLICATION;

Invoices:
LOAD
  INVOICEID,
  COUNTRY,
  AMOUNT
FROM Invoices.qvd (qvd);

Employees:
LOAD
  EMPID,
  EMPNAME
FROM Employees.qvd (qvd);