MISSING DATA

[master_student]

Hello everyone,

The data of yesterday is missing from one of my dashbords. How can I reload the missing data?

Thanks for your help.

here's my script :

LET vDate1 = date(Today(), 'YYYY-MM-DD');

LET vDate2 = date(Today()-30, 'YYYY-MM-DD');

LET vDate3 = date(Today()-1, 'YYYY-MM-DD');

noconcatenate

USAGE1:

SELECT

'$(vDate3)' as Date,

...

sum(trunc(RC.net_call_charge_amount/1000,3)) AS TOTAL_RECHARGE

FROM

where RC.call_end_date >= '$(vDate2)'

and RC.call_end_date < '$(vDate1)'

concatenate (USAGE1)

SELECT

'$(vDate3)' as Date,

...

FROM

where RC.call_end_date >= '$(vDate2)'

and RC.call_end_date < '$(vDate1)'

noCONCATENATE

usage:

load date(date,'DD/MM/YYYY') as date,

FROM

[\usage - Copy.QVD](qvd)

WHERE Date(date,'DD/MM/YYYY') < Today()-1

;

Concatenate(usage)

load * resident USAGE1 ;

store usage into [\usage - Copy.qvd] (qvd);

drop table usage;

drop table USAGE1;

[Anonymous]

Hi Wiem,

How do you load your data?

Regards!

[Anonymous]

Make the connection with the data source and reload it

[master_student]

I didn't create the qvw that's why I am asking, In fact after having a look on the application, it uses qvd's load * from QVD and the reload of these qvds (sql queries )are done in another qvw

[Anonymous]

Hi Wiem,

This qvd have data from yesterday or only for today?

Regards!!

[master_student]

the reload job brings yesterday data, the data of 03-09-2016 are not available, the qvd contains data expect 03-09-2016

[Anonymous]

Hi Weim,

If the reload jon brings yesterday data (04/09/2016), and your qvd contains 03/09/2016, you will reload no data. I think that your job must birngs the day before the max data stored on qvd.

Regards!

[master_student]

the data of 03/09/2016 is missing from my qvd.

Thanks

[Anonymous]

You're wellcome!!