Forum Discussion

Marfield's avatar
Marfield
Icon for Helper I rankHelper I
6 years ago

One table to rule them all

Hi there,   I have an issue with my data model. Bassicaly, I need to filter all my report according to the row filtered from one main table.   In my example, I have 3 dimensions and 1 fact table ...
Need Help
VasTg's avatar
VasTg
Icon for Memorable Member rankMemorable Member
6 years ago

Marfield 

 

Try this...

1. Create a bridge table(all combination of client,Product and source id)

2. Define relationship from source to bridge(1 to M - single direction)

3. Define relationship from Client  to bridge(1 to M - bidirection)

4. Define relationship from Product to bridge(1 to M - bidirection)

5. Join the bridge to facts(maybe M to M - single - bridge to facts)

 

Hopefully this should work.

Let us know.

 

Anonymous 

Sorry!!..Incorrectly tagged you in the previous post.

 

 

Marfield's avatar
Marfield
Icon for Helper I rankHelper I
6 years ago

This could do the trick in the example but it won't work because I would need one gigantic bridge table.

My real model kinda looks like this (and will grow in size in a few weeks because there are still some tables and rows missing):

 

Besides, I wouln't be able to see a table with ProductName, Fullname and Date. Which is kinda annoying for a fact table 😁