Link Problem Data Model

[vikasmahajan]

Dear all

Here I am attaching my data model pics , Here in Fact GL , I want to fetch vendore associated to gl entry ,

so I use apply map command and bring all vendore code in fact GL table , But now I want to have Vendore Names also link

along with codes .

I use following mapping

PickVendor:

Mapping Load

[Document No_] as DocNo ,

[Vendor No_]    as Vend

FROM [Source QVDs NAV\FACT_QV_VendLedgerEntry.qvd]

(qvd); 

fact_glentry:

load

...

     IsProduct,

     ApplyMap('PickVendor',[Document No_],0) AS key

FROM

[Source QVDs NAV\FACT_GL_Entry_temp.qvd]

(qvd);

Vendor:

DIM_Vendor_Master:

Directory;

LOAD

  Vendor_Code,

  Vendor_Code as key,

     Vendor_Name

FROM

[Source QVDs NAV\DIM_Vendors.qvd]

(qvd)

WHERE Vendor_Name <> '';

This forms loops how to avoid this.

Vikas

[jagan]

Hi,

Try like this

Create another mapping table

Vendor:

Mapping LOAD

  Vendor_Code,

     Vendor_Name

FROM

[Source QVDs NAV\DIM_Vendors.qvd]

(qvd)

WHERE Vendor_Name <> '';

DIM_Vendor_Master:

Directory;

LOAD

  Vendor_Code,

  Vendor_Name,

  Vendor_Code & '_' & Vendor_Name as Key    

FROM

[Source QVDs NAV\DIM_Vendors.qvd]

(qvd)

WHERE Vendor_Name <> '';

fact_glentry:

LOAD

*,

TempVendorCode & '_' & ApplyMap('Vendor',TempVendorCode,'') AS Key;

load

...

     IsProduct,

     ApplyMap('PickVendor',[Document No_],0)  AS TempVendorCode

FROM

[Source QVDs NAV\FACT_GL_Entry_temp.qvd]

(qvd);

Regards,

Jagan.

[vikasmahajan]

Thanks Jagan I will try and get back you.

Vikas