Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Section Access working only locally

Hello everyone,

I am facing strange issue withh QV9 report. I have implemented section access for company report and it works. but only locally.

When I am publishing it, I can see all data in QV Access point.

What I've already checked:

- tickbox for "initial data reduction" is ticked in document properties

- credentials in data protection section on reload tab in QEMC are properly entered

- I properly checked "recipient information" field in Distribute -> Loop field in Document.

- I am doing complete refresh, and then I am putting saved file to Production folder

I have no other clues unfortunetely.

I will also paste security implementation, as maybe someone will find problem there:

SecurityTable:

LOAD

UPPER(AccountName) as LOGINID,

'USER' as AccessT,

If(IsNull(organization_id) or organization_id='','*',organization_id) as OrgIdT,

UPPER(If(IsNull(division) or division='','*',division)) as DivisionT,

UPPER(If(IsNull(SBU) or SBU='','*',SBU)) as SBUT;

SQL SELECT *

FROM DATABASE_DETAILS


Concatenate(SecurityTable)

Load * Inline

[LOGINID,AccessT,OrgIdT,DivisionT,SBUT

QV_USER,ADMIN,*,*,*];

//Inline is user configured in data protection section on reload tab in QEMC

SecurityTbl:

Load

*,

RowNo() as GROUPIDT

Resident SecurityTable;

Drop Table SecurityTable;

star is   *;

Section    Access;

Load                

LOGINID    as   NTNAME,        

AccessT    as   ACCESS,   

GROUPIDT as LINK1,

GROUPIDT as LINK2,

GROUPIDT as LINK3        

Resident   SecurityTbl     ;

          

Section    Application     ;

L1:                 

Load Distinct            

OrgIdT     as   OrgId_Fltr,         

GROUPIDT as LINK1        

Resident   SecurityTbl;

L2:                 

Load Distinct            

DivisionT  as   Division_Fltr,      

GROUPIDT as LINK2        

Resident   SecurityTbl;

L3:                 

Load Distinct            

SBUT as   SBU_Fltr,      

GROUPIDT as LINK3        

Resident   SecurityTbl;

//OrgId_Fltr, Division_Fltr and SBU_Fltr are links to data shown in report (in other table they are also UPPER CASE)

I would greatly appreciate all sugestions.

10 Replies
pauljohansson
Creator III
Creator III

Hi Saperos, did you find the problem? Im having the same problem, br Paul