Forum Discussion

Varishtha's avatar
Varishtha
Icon for Helper I rankHelper I
2 years ago

Filter a fact table based on another (indirectly connected) fact table

I have multiple fact tables (red arrows) connected to one dimension table ('user') in my data model. 'user' table has 'ID' as primary key which serve as foreign key in all the connected fact tables (...
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
Varishtha's avatar
Varishtha
Icon for Helper I rankHelper I
2 years ago

hi lbendlin 

Thanks for the response.

Could you please explain more about this approach, since i need to use multiple filters on the unrealted table.

Your help is greatly appreciated.

 

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

There are good tutorials on the usage of TREATAS - choose one that fits your learning style. You can also look at the queries in the performance analyzer, they make extensive use if it.