I have 2 Dimension tables, one view and one fact table. The dimension tables are fund and task.
Earlier the view table was joined to task and fund table.
View.Fundl = Fund.Fundl
View.Program = Task.Taskl
I am trying to change these joins to go through the fact table and still get the same...