7 Replies Latest reply: Apr 7, 2016 3:30 PM by Colin Albert RSS

    Failed to open the document. You don't have access to the document

    Santosh Prabakar

      I have a new app developed by a user which comes with section access. Reloaded the file and the section access took effect after the reload. As per the section access, I shouldn't be seeing one of the tab. After the reload, I was not able to.

       

      My problem is with the Access point. When I try to access that particular document, It says - Failed to open the document. You don't have access to the document. What am I missing?

       

      Here is the screenshot of the QVW - Document properties - Opening. If I uncheck, Initial Data reduction based on section access and Prohibit Binary load then I'm able to access the App through Access point but I'm seeing all the tabs. As per section access, My windows AD login shouldn't be seeing one of the tabs.

       

      Here is the hidden script:

      Section Access;

      LOAD

          NTNAME,

           USER_ID,

           ACCESS,

           NAME,

           QLIKVIEWAPP,

           ACTIVE

      FROM

      [\\hcqvtst\Qlikview_Test\Publisher\SourceDocuments\Analytics\ExternalData\Exec.xlsx]

      (ooxml,embedded labels, Table is Section_Access);

       

      Section Application;

       

      SheetAccessMatrix:

      LOAD

           NTNAME,

           REVENUE,

           PERFORMANCE,

           [PROVIDER DETAILS],

           [FACILITY CLAIM DETAILS],

           REFERRALS,

           [JMH BILLING],

           REINSURANCE

      FROM

      [\\hcqvtst\Qlikview_Test\Publisher\SourceDocuments\Analytics\ExternalData\Exec.xlsx]

      (ooxml, embedded labels, table is Section_Access);

       

      Screenshot of the Excel