i have one question regarding the source .this is the oledb connection to the qlikview application . i have written this in text file and script also.
i want to know what is the source data and where is the data pulling from ..
OLEDB CONNECT TO [Provider=SQLOLEDB.1;Persist Security Info=True;User ID=RX_BI_Qlikview;Initial Catalog=RX_BI_Qlikview;Data Source=XSPW10F022C;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=SHAWODC017;Use Encryption for Data=False;Tag with column collation when possible=False] (XPassword is GNXVLJBPCKMADGVNDD);
LET START_PERIOD='201501';
fact:
LOAD Period,
BU,
AreaName as Area,
RSMHC AS RSM,
TAName,
Brand,
BrandName,
ProvinceE,
PriceType,
Category,
"MAT Actual",
"MAT N-1 Actual",
"MAT Target",
"N-1 Actual",
Package,
Actual,
RSMHCID,
Target,
"YTD Actual",
"YTD N-1 Actual",
"YTD Target";
SELECT Actual,
AreaName,
Brand,
BrandName,
CASE WHEN AreaName LIKE '%CVIM-Essentiale%'
THEN 'Essentiale Hospital' else BU end as BU,
Category,
"MAT Actual",
"MAT N-1 Actual",
"MAT Target",
"N-1 Actual",
Package,
Period,
PriceType,
ProvinceE,
RSMHC,
RSMHCID,
TAName,
Target,
"YTD Actual",
"YTD N-1 Actual",
"YTD Target"
FROM "Rx_BI_Qlikview".dbo."dataset_complete_report"
