REG-SOURCE

Tue, 26 May 2015 10:10:20 GMT

Hi Team ,

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,