10 Replies Latest reply: Oct 7, 2013 7:31 AM by Paul Johansson RSS

    Section Access working only locally

    Jakub Szurogajlo

      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.