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
Marfield's avatar
Marfield
Icon for Helper I rankHelper I
6 years ago

This is only an example to explain my problem/need.

My real data model contains about 20 dim tables and 3 fact table soooo... I doubt this would be efficient if I merged everything in only one table ğŸ˜‹

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Just try to make it active from the property and check what error it gives. I faced the same issue when I tried joining one table by (say ) source not by source Id. I deleted all such join and created all join on source IDs.

 

Also make sure there are no two paths, which not visible here in diagram.