Qlikview增量加载数据库里的数据到QVD文件。
MainTab:
LET LastReload=reloadtime();
LET Curr=now();
TRACE <<<<< Current Time is $(Curr), Last Reload Time is $(LastReload)>>>>>;
SET ThousandSep=',';MainTab:
LET LastReload=reloadtime();
LET Curr=now();
TRACE <<<<< Current Time is $(Curr), Last Reload Time is $(LastReload)>>>>>;
SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;($#,##0.00)';
SET TimeFormat='h:mm:ss TT';
SET DateFormat='YYYY-MM-DD';
SET TimestampFormat='YYYY-MM-DD h:mm:ss[.fff] TT';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';
//setvQvdFolder='D:\Manie\ABC\QV_REPORT\PLS\QVD';
set vQvdFolder='D:\Watson\ABC\QV_REPORT\BDS\QVD'; //The location is on Watson's own PC
SET vDBName='DW';
//OLEDB CONNECT TO[Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;DataSource=192.168.2.250;Use Procedure for Prepare=1;Auto Translate=True;PacketSize=4096;Workstation ID=8BFWC02;Use Encryption for Data=False;Tag with columncollation when possible=False];
//ODBC CONNECT32 TO DW;
//OLEDB CONNECT32 TO[Provider=SQLOLEDB.1;Persist Security Info=False;User ID=vscmis;InitialCatalog=DW;Data Source=192.168.2.250;Use Procedure for Prepare=1;AutoTranslate=True;Packet Size=4096;Workstation ID=R9HDET7;Use Encryption forData=False;Tag with column collation when possible=False];
OLEDB CONNECT32 TO [Provider=SQLOLEDB.1;Persist Security Info=False;UserID=vscmis;Initial Catalog=DW;Data Source=192.168.2.250;Use Procedure forPrepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=R9HDET7;UseEncryption for Data=False;Tag with column collation when possible=False];
IF Month(now())>=4 THEN
LET vStartYear=Year(now())-2;
ELSE
LET vStartYear=Year(now())-3;
ENDIF;
SET vMonthDay='04-01';
LET vStartDate=Date('$(vStartYear)-$(vMonthDay)','YYYY-MM-DD');//num(Date('$(vStartYear)-$(vMonthDay)','YYYY-MM-DD'));
LET vEndDate=Date(today()-1,'YYYY-MM-DD');//num(today()-1);num(Date('2012-04-18','YYYY-MM-DD'));
Trace <<<<<Period: From $(vStartDate) to $(vEndDate) >>>>>;
Transaction Tab:
MeasureTable:
LOAD
* INLINE
[Measure
ABC_BI_INV_LINES
ABC_BI_INV_HEADERS
];
FOR counter = 1 to NoOfRows('MeasureTable') //FORcounter = 1 to NoOfRows('SourceTable')
LET vSourceName=Fieldvalue('Measure', $(counter));
IF '$(vSourceName)'='ABC_BI_INV_HEADERS' THEN