Fact Vs Dimention

[NavinReddy]

Hi All,

Could some help me get out of this Query

i have Fact table and Multiple Dimention Tables

How can i use Dimention Table Fields in Fact Table

Linking between Fact Table and Dimention Table

Thanks & Regards

Niranjan

[jagan]

Hi,

A common field name in both Fact and Dimension table automatically links the tables.

Regards,

Jagan.

[NavinReddy]

Hi jagan,

No common Field ,Multiple Dimension Tables Fields how to link Fact table

I think one to many relation ship

if i am wrong plz correct me

Thanks & Regards

Niranjan

[#4]

if you have different names in your fiels you can rename for example;

table1:

Load

Key_Customer

Amount

from FactTable.qvd(qvd);

table2:

Load

field1 as Key_Customer

field2 as Description

from catalogs.qvd (qvd);

this way the qliview linked both table by Key_customer because the names of the fields now are the same name.

otherway is using left, rigth,outer join.

table1:

Load

Key_Customer

Amount

from FactTable.qvd(qvd);

left join

table2:

Load

field1 as Key_Customer

field2 as Description

from catalogs.qvd (qvd);

YOU HAVE A GREAT DAY!!!!

[Sokkorn]

Hi Niranjan,

Check here. And this one may give some idea to get start:

[Fact]:

Load

     Dim1F1 &'|'& Dim1F2 &'|'& Dim1F3 AS [_LinkDim1],

     Dim2F1 &'|'& Dim2F2 AS [_LinkDim2],

     FactVal1,

     FactVal2;

From Fact;

[Dim1]:

Load

     Dim1F1 &'|'& Dim1F2 &'|'& Dim1F3 AS [_LinkDim1],

     Dim1Val;

From Dim1;

[Dim2]:

Load

     Dim2F1 &'|'& Dim2F2 AS [_LinkDim2],

     Dim2Val;

From Dim2;

........................

Regards,

Sokkorn