little help with a simple link table needed

[amien]

how would my link table script look like?

dimension table: businessline,  function, region, financial costplace#, human resource costplace#

fact table : date, businessline, value

fact table : date, financial costplace#, value

fact table : date, human resources costplace#, value

date will be linked to a master calender.

When i select region or a function .. i want that 3 different pivots to show data (one for each fact table).

perhaps other data model is more suitable .. but i like to know how this is done in a linked table model

Thanks in advanced

[amien]

/up

[amien]

no one? i need it quite urgent

[#4]

Hi,

While, I simply believe that link table approach may not be good here but still since you want it so I am adding one basic idea.

It may not be perfect but is just to show you.

...

Ashutosh

[amien]

Thanks for your reply.

You solution is the same as i have not .. when i select a region, all values in 'value' are deselected.

what i did now, is to LEFT JOIN to get a region for all fact tables. But i don't know if this is the best solution. Is this possible without LEFT JOIN the region to all fact tables?

[vijay_iitkgp]

Can you please explain how your region is linked with fact tables.

[amien]

depends on the fact table:

fact table : businessline --> region

fact table : financial costplace# --> region

fact table : human resources costplace# --> region

[vijay_iitkgp · Accepted solution]

Create

Region_Link:

Load Distinct

Businessline,

Businessline as Region

Resident Fact1;

Concatenate

Load Distinct

financial costplace#,

financial costplace# as Region

Resident Fact2;

concatenate

...

..

You will get the desired result

[amien]

Yes! .. that's better than a LEFT JOIN .. Thank you!