Keep track of different loads

[#1]

Dear all,

I have a QV dashboard that has several xls files as a source.

The xls files are various status reports of my project which are updated on a weekly basis.

What I would like to do is keep the history per week. Meaning that I would like to store some KPI's per load.

Does anyone know of an easy way to do this?

For example:

I load the file status.xls on 03/07 and have that KPI_A=250.

I load the files status.xls (which is updated) on 10/07 and have that KPI_A=500.

How can I store the KPI_A of 03/07 to be able to track my progres?

Thanks in advance!

Kind regards,

Jens

[#2]

If the KPI is stored in a variable then load it in a table and store it in qvd format.

Ex:

First time you have to create a History file

Let KPI_A=500;

TableKPI:

Load

     '$(KPI_A)' as KPI

Autogenerate 1;

Store TableKPI into TableKPI.qvd (qvd);

Next time

Let KPI_A=500;

TableKPI:

Load

     '$(KPI_A)' as KPI

Autogenerate 1;

Concatenate(TableKPI)

Load * from TableKPI.qvd (qvd);

Store TableKPI into TableKPI.qvd (qvd);

This will maintain the history.

Hope this will help

[#3]

Thanks for the response Arasu.

The problem is that I have a very high number of KPI's that I would like to store (almost all the data that I load).

So I was wondering if it would be possible to store these upon loading (in bulk) and adding the load date to be able to generate some history graphs from it afterwards.

Kind regards,

Jens

[swuehl]

It seems to me that you want to use an incremental load, i.e. loading only the newest data from source, but accessing also historic data. There is a description in the Manual of how to do something like this and also a quite nice working example in the QV cookbook (which I can recommend anyway):

http://robwunderlich.com/downloads/

Hope this helps,

Stefan