For some reason, I am having a mental block trying to figure out how dimensions get associated with cubes, and why dimensions can't all just be used in any number of cubes. (I'm working on a MS SSAS project.)
In most cases, shouldn't there be only one time dimension? Is there a simple way to use it with multiple cubes?
Edit: For now I'm going to start using the New Linked Object wizard. If someone could confirm that this is the right approach I'd appreciate it.
What version of SSAS are you using? In 2008, you can create multiple dimensions and multiple cubes in each projects, and you can use dimensions in as many cubes as you want.
If I remember right, you were able to do that as well in 2005.