Hi, everyone. I am a beginner. I have a question about update OLAP cube
structure.

I have a cube named "MSP_ASSN_FACT" (used in project server) and the cube
has some dimensions and measures. the cube has been created. now I want to
insert into a table and change the relations( remove a join and append a new
join) in these tables in VB using programming. so I set the DSO object
clsCube's FromClause property to 'table1,table2,table3' (table3 is the table
I want to insert). and then, set the clsCube's JoinClause property to change
the relation in these tables. the joinclause include all joins except the
join I want to remove. ok, I update the cube. not error message to display.
so I think the update is successful.

when I checked the cube in Analysis manager. I found the table3 had been
inserted and the new join is created. it is ok. but the join I wanted to
remove is still exist. in my joinclause I not set the join I want to remove.
why the join still exist?