Reg-source

[#1]

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,

     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"

can any one help me out

[ToniKautto]

No really sure I get your question. Are you asking us where your database server is located and what data you get out of it? Are you experiencing any problem when you run the script above?

[#3]

if i run the above script iam getting the target value is negative and i want what is the source data for this ?

from the data is pulling .

finally  i want the name of source data

[ToniKautto]

You mean that you get negative values instead of positive. Have you validated that these are actually not the values in your data source?

What do you mean by getting the name of the source? The table name is in the FROM statement and the server name is in the connect string

[awhitfield]

Hi,

The source server name is XSPW10F022C and the data is coming from the object  "dataset_complete_report" in the database Rx_BI_Qlikview". Is that what you meant?

HTH Andy