Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
In my dashboard i have two fact tables... say FACT1 and FACT2.. also there are other dimentions too...
In both fact table there is time_id by which we can restrict the data...
My problem is... first i want to load previous 30 days of data to start with and then data from both fact table should be incremented every 4 hour in 30 days data.
how to make qvd file and store them such that when they are incremented/refreshed successfully i can use them in my dashboard/application.
Pleas help me out to solve this problem..
Thanks...
Hi,
Does it mean you always just need last 30 days data in your dashboard and then in QVD?
Chers.
Hi,
I think with some modifications to original fileds that you have and taking care in the date format you can try the below script.
//First create a snapshot of 30 days data and store in QVD, this step is one time only.
//Last30daysTranData:
//Load time_id, ctry,prod from table table1 where time_id>=Today()-30;
//
//Store Last30daysTranData into Last30daysTranData.QVD;
//Please uncomment the above code and comment everyhting else to create a snapshot
//Once you created the above snapshot, load data from QVD
//any data beyond 30 days will not be loaded
Last30daysTranData:
Load * from Last30daysTranData.QVD where time_id>=Today()-30;
//this will append incremental data which is not there in above QVD
Concatenate (Last30daysTranData)
Load time_id, ctry,prod from table databasetable where time_id>=Today()-30;
Store Last30daysTranData into Last30daysTranData.QVD;
Cheers.