Partial Load in dashboard

[raju_salmon]

Hi,

We have a dashboard where we need to pull two tables from SQL DB. We don't create QVDs.

Requirement is to load both table in dashboard for first time (as it should have 5 years+current month data)

Table 1 contains 5 years data

concatenate

Table 2 contains current month data

(these two tables are just part of big model)

We would want to load Table 1 once in a week from DB where Table 2 should load everyday. If we reload by putting a condition, Table 1 data will not be there everyday and just Table 2 data will be there.

Can anyone provide a solution how can we retain the Table 1 data in the dashboard?

Regards,

Raju

[raju_salmon]

Can anyone help me here?

[vishsaggi]

When you say every week do you have a specific day in that week like Monday or tuesday? IF yes may be try like

You can change the weekday to Mon or Tue or Wed etc...

IF WeekDay(Today()) = 'Mon' Then

Table1:

SQL Select *

FROM yourtablename;

ENDIF;

Table2:

SQL SELECT *

From yoursourcetablename;

[raju_salmon]

Thanks Viswanath. But i want to retain Table1 data for all rest of days without loading it. I know its possible using partial load but we have larger model where 100+ tables are there. Everywhere i need to use REPLACE load except above table. I am looking for any other solution.

[vishsaggi]

Ok. Then use store command to store it to QVD and in everyday load you get the data for table1 from qvd. Like below:

IF WeekDay(Today()) = 'Mon' Then

Table1:

SQL Select *

FROM yourtablename;

Store Table1 into \\server\folder1\QVD\Table1.qvd(qvd);

Drop Table Table1;

ENDIF;

Table1:

LOAD *

FROM \\server\folder1\QVD\Table1.qvd(qvd);

Table2:

SQL SELECT *

From yoursourcetablename;