Incremental and Qlikview Workflow

[#1]

Hi ,

I have below high level understanding of incremental load and Qlikview workflow- given scenario where we receive data files on daily basis , please correct me if I am wrong or missing something 

Qlikview version : Qlikview 11

1. Import records from data files into DB tables

2. Use incremental load procedure for uploading new records from DB tables into Dashboard by using multiple qvd files (each qvd file belongs to one particular table)

3. Create Data model and apply transformations(if required)

4. Develop UI (charts, security etc)

5. Change the QVDs and QVW files path based on Root folder on server

6. Move all QVDs and QVW file from local system to Root folder on Qlikview Server (Assuming same records are available on Prod DB server)

7. Create Publisher task on Qlikview Server which will move QVD and QVW files inside Access Point folder

To upload daily updated records we will have to run incremental load every day

[ramasaisaksoft · Accepted solution]

Hi Sharma,

First thing you need to say Fresh/Updated data & Qlikview (Not incremental load)

1. Import records from data files into DB tables

2. create Qvd's files as a source (It is Fully load in Incremental load type) for different tables

a table     a.qvd

b table     b.qvd....x table   xqvd

3.Create Data Model  by using different joins/Concatenation/Keep...Load types...Functions

(it is better to create Data Model without Synthetic tables & Circular Loops)

4.Now create Different sheets as per your client requirement using with different objects with in Sheets.

Server:-

1) create Folder structure for a perticular project(Here only u need to maintain all files)

     0_Access

     1_Source_Data

     2_QVD

     3_ETL

     4_Dashboards

     5_Settings

     6_Scripts

     7_Resouces

     8_Documentation

2)After that in QMC  u need to schedule the jobs

3)Check the dashboards at Access point as per your credentials.