Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi Saperos, did you find the problem? Im having the same problem, br Paul