12 Replies Latest reply: May 5, 2014 3:43 PM by Deepak Vadithala RSS

    Section Table by Resident load

    Srikanth P

      Hi All, I am facing very wired problem as my section access is not Working when I am creating the Section Table with Resident Load

       

      Then I changed to QVD its working fine.

       

      Here is my script (Resident Load):

       

      TempSecurity:

      LOAD NTNAME ,

                ACCESS ,

                DEPARTMENT

      FROM BI_SALES_SECURITY.qvd (qvd) ;

       

      //Adding some new departments to existing qvd

      Concatenate (TempSecurity)

      LOAD * INLINE [

      NTNAME , ACCESS , DEPARTMENT

      **** ,***** ,******

      ****,*****,*****

      ****,*****,*******

      ];

       

      Section Access:

      SectionTable:

      LOAD NTNAME ,   

                ACCESS ,

                DEPARTMENT

      Resident TempSecurity ;

      Section Application ;

       

      The above script is not worked for me. The script executed with out any error and I tried and to open after reload I git Access denied Error.

       

      So I create another qvw where I add the INLINE table and creates the new security qvd and Section Access worked.

       

      Why Resident Load is not worked on SectionTable ?