1 Reply Latest reply: Aug 28, 2018 2:31 PM by RODRIGO MOLINA DE OLIVEIRA RSS

    Section Access - QlikSense

    RODRIGO MOLINA DE OLIVEIRA

      O Section Access que montei não tem efeito na aplicação, alguém tem alguma dica?

       

      USUARIOS:

      LOAD  

          UPPER( 'DOMINIO\'&%cod_usuar_so )   AS USUARIO,

          "Centro de Custo"                                      AS "Centro de Custo"

          FROM [lib://DWH_COMUM/DWH_USUARIO.QVD]

      (qvd);

       

      //===================================================================================

       

      Section Access;

      STAR IS *;

       

      Access:

      load * inline [

      ACCESS, USERID, REDUCTION

      'ADMIN', DOMINIO\QLIKSENSE,31400

      'ADMIN', DOMINIO\RODRIGO.MOLINA,31400

      ];

       

      LOAD Distinct

      'USER'                   AS ACCESS,

      USUARIO              AS USERID,

      "Centro de Custo"  AS REDUCTION

      Resident USUARIOS;

       

      Section Application;

      Drop Table USUARIOS;

       

      //===================================================================================

       

      ESTOQUE:

      LOAD

          "Centro de Custo" as REDUCTION

      FROM [lib://DWH_CONTABILIDADE/DWH_ESTOQUE.QVD]

      (qvd);