Joins

[taruna1]

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 result. I have modified these joins in the following manner.
Fact.Fundl = Fund.Fundl
Fact.Taskl = Task.Taskl
Fact.Fundl = View.Fundl
Fact.Taskl = View.Program.

Can anyone tell me if these joins will lead to the same result. If no, what would be the best way to get the same result if we have to go through the fact table.

Thanks

 

[nagornyi]

In what way Fact table is supposed to affect the output? If you need the same result why is the table ever to be involved?

 

[RiverGuy]

Maybe ask this in the OLAP forum.

 

[taruna1]

Actually we have two spanning trees in the catalog and I am trying to combine them and reduce the redundancy by getting rid of the alias tables. And I just want to check, that creating the new joins will cause the same data to be retrived.

Thanks

 

[nagornyi]

Then your joins look fine. After getting the result, swap Fact and View to ensure the result is the same.