Linking issue

[bharatkishore]

Hi All,

I have loaded following fields from  one qvd say T1: i.e.

T1:

Sales_Organization,

     Product_Group,

     month(TecoProxy) as TecoProxy ,

     TecoProxy_Year,

     Cat,

     Consumption,

     SWO_Count

Now i loaded one more table with the following fields:

T2:

Sales_Organization,

Product_Group,

[Norm Applicable Year] ,

Cat,

Consumption,

SWO_Count,

NORM

Now in second table i need only Norm to be in first table and  i don't want Sales_Organization,Product_Group,[Norm Applicable Year] ,Cat,Consumption, SWO_Count from second table.

Norm is derived from based on year and it is not derived based on Month but when i add  TecoProxy from first table in dimension then i am getting values for Norm for all the months which is wrong because since i don't have Norm at month level i need to get same values in chart. But instead of that i am getting different vales for month

Can you please help me how can we achieve it.

Attached app for more reference

Thanks,

Bharat

[jwjackso]

Have you considered loading the PCMS_Norm first as a mapping table:

PCMS_Norm:

Mapping

load [Norm Applicable Year] &'|'& Sales_Organization &'|'& Product_Group &'|'& Cat as Key1,

//Sales_Organization,

//Product_Group,

//[Norm Applicable Year],

//Cat,

// Consumption,

//SWO_Count,

NORM

FROM

\\nlnehvdcs3vw219.ssn.philips.com\GCS\Development\RR\5_QVD\PCMS_Norm.qvd

(qvd);

PCMS_New:

LOAD ApplyMap('PCMS_Norm', TecoProxy_Year &'|'& Sales_Organization &'|'& Product_Group &'|'& Cat,Null()) as NORM,

Sales_Organization,

     Product_Group,

     month(TecoProxy) as TecoProxy ,

     TecoProxy_Year,

     Cat,

     Consumption,

     SWO_Count

FROM

\\nlnehvdcs3vw219.ssn.philips.com\GCS\Development\RR\5_QVD\PCMS_Cons_new.qvd

(qvd);