topic Re: Fact Vs Dimention in QlikView

Fact Vs Dimention

NavinReddy — Fri, 07 Jun 2013 15:22:44 GMT

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

Re: Fact Vs Dimention

jagan — Fri, 07 Jun 2013 15:44:05 GMT

Hi,

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

Regards,

Jagan.

Re: Fact Vs Dimention

NavinReddy — Fri, 07 Jun 2013 16:03:37 GMT

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

Re: Fact Vs Dimention

Fri, 07 Jun 2013 16:54:28 GMT

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!!!!

Re: Fact Vs Dimention

Sokkorn — Sun, 09 Jun 2013 04:23:18 GMT

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