4 Replies Latest reply: Oct 4, 2016 3:12 AM by Peter Cammaert RSS

    Data reduction  - automatic reloads with the distribution service

    jojee Jojee M Issac

      @@ ! 

      We have an issue facing in data when automatic reloads with the distribution service.

       

       

       

      The data is not loading fully when automatic reloads runs at morning using the service account(distribution service).

       

       

       

      But when reload manually with the same service account , the data is loading perfectly. .

       

       

       

      The Initial Data Reduction Based on Section Access & Strict Exclusion are checked. We have section access defined as below  .

       

       

       

                              

       

      ADMIN

      QLIKVIEW ADMIN1

      BENZ\qadmin1

      ALL

      ALL

      ADMIN

      QLIKVIEW ADMIN1

      qadmin1

      ALL

      ALL

       

      Section Access;
      LOAD ACCESS, NAME, NTNAME, IF(GROUP='ALL','*', GROUP) as 'Stock Group', // STOCK
         IF(GROUP='ALL','*', GROUP) as Group, // PARTS SALE
         IF(GROUP='ALL','*', GROUP) as GROUP., // LABOUR LOG
         IF(GROUP='ALL','*', GROUP) as GROUP.., //CLOCK ENTRIE
         IF(BRANCH='ALL','*', BRANCH) as Branch, IF(BRANCH='ALL','*', BRANCH) as 'Branch Name', // W.Revenue Branch
         IF(BRANCH='ALL','*', BRANCH) as Branch.Name  // W.Analysis Branch
         FROM
      [D:\QlikView Live\Data\Permission.xlsx]
      (
      ooxml, embedded labels, table is [P&W]);
      Section Application;

         

       

      Please let me know any settings has to be change

        • Re: Data reduction  - automatic reloads with the distribution service
          Peter Cammaert

          How do you know that not all data is getting loaded? How did you check this? Did you open your document in QV Desktop using an ADMIN account? Maybe the data gets reduced for everybody.

           

          As a test, add an ADMIN account with empty link fields to your section access table, reload and open your document in QV Desktop using that account.

           

          Note that your observation that all data is loaded when reloading in QV Desktop is correct, because Section Access will only reduce your data model at file open time and never afterwards. So a reload always returns a full data set, until you save-close-reopen the document. At that moment Data reduction is applied on the new data set as well.

           

          Best,

           

          Peter

            • Re: Data reduction  - automatic reloads with the distribution service
              jojee Jojee M Issac

              Hi Peter,

               

              Thanks for the answer.

               

              We got a complaint from the user  for a particular group , the data is not loading correctly and also when we compare with our DMS application.

               

              Upon further analysis , we tried to manual reload the document with the same service account and the data is loading correctly.

               

              Then we tried the remove the code from the  section access code and data was loading correctly when  ran from the publisher .

               

              Hence we finalized , it was problem with the section access.

               

              Thanks,

              Jojee

                • Re: Data reduction  - automatic reloads with the distribution service
                  Peter Cammaert

                  Ok, so you'll have to focus on the way Section Access reduces the data for particular users.

                   

                  There is an easy and very useful technique to simulate data reduction as far as possible. It simply consists of opening your misehaving document in QV Desktop, commeting out the statement Section Access; and reloading the document. You don't need to close it. Now your data model will contain an extra field called NTNAME (or even NAME). Put this field as a liustbox on a sheet and in this field select the user that is experiencing problems. You are now simulating data reduction as much as possible. Investigate what is happening in your data model.

                   

                  You will probably find the real cause of this data reduction malfunction.

                   

                  Do not forget to remove the comment marker after you're done investigating or your document will show everything top everyone.

                   

                  Best,

                   

                  Peter

              • Re: Data reduction  - automatic reloads with the distribution service
                Rupam Das

                Why not separate the two process

                1) One QVW file to load the data and store in QVD without Section Access

                2) Load the QVD in the Final APP with Section Access