I am having problems with a 2005 cube that I am creating; I did not get
all the joins spot on in the Data Source View at first, but when I make
the necessary changes and redeploy the project to the server the
changes are not reflected in the cube design as I assumed they would
be.
Can anyone give me a pointer as to how I should be doing this?

Thank you

Rachel

If these were joins between a fact table and dimension tables, then you
will have to manually correct the relationships in the dimension usage
tab. I believe this behaviour is by design, the dimension usage tab
infers its settings from the DSV, but changes to the DSV do not
propagate down to the dimension usage tab as you may have set up role
playing dimensions.

--
Regards
Darren Gosbell - SQL Server MVP
Blog: http://www.geekswithblogs.net/darrengosbell

In article <1163783947.152549.62170 (AT) e3g2000cwe (DOT) googlegroups.com>,
rachel.jones (AT) talbotuw (DOT) com says...