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.