How to break many to many relationship between tables

building semantic layer
1

Hi,

In my universe i have to join two tables,one is fact and another one is dimension table which contains the history data.the relation between these two table is many to may.can some one help me to break this relation.

Thanks in advance…

Thanks,
Michael.

Michael Das (BOB member since 2009-10-15)

2

Hi,

Why is the relationship between the fact table and the dimension table many to many? Can you please explain with some data as an example?

The thing is that properly designed dimension and fact tables have one to many relationship.

Marek Chladny :slovakia: (BOB member since 2003-11-27)

3

Very brief:
Apply a stub-join/self-restrictive join (or with XI 3.x add a class-wide filter for example) to your dimension table, which is a slowly-changing dimension type 2 (SCD 2) most likely. This way the user will have to pick the as-of-date for the SCD 2 whenever running a query.
See also this post of mine here, please.

Andreas :de: (BOB member since 2002-06-20)