just wondering, if the relationship is being defined in the dimension usage
tab within the cube, then is it really necessary to define the relationship
in the datasource views? Or are those relationship links more for
documentation?
Also, can you have 2 different time dimension in one cube. A fiscal and a
regular calendar. Our fiscal goes from Mar 2005 to Feb 2006 and the regular
calendar is jan to dec 2005. Or do they have the be 2 separate cubes?