I am working with 2 hierarchies (Time.Calendar and Time.Agg) and the
time.calendar has a default member that is the current day. Thus when I go
to navigate and pull values within the time.agg hierarchy, values are only
pulling from the default member of the time.calendar dimension (where I would
like it to pull all of them). This default member in the Time.Calendar
dimension must stay as a default member. Since each of these hierarchies are
in two different base non-virtual cubes, when navigating in the Time-Agg, I
get no data back unless at the top level of time.agg.

What is valid MDX (some type of crossjoin that can auto specify the member
in the Time.Calendar dimension) to place in the last step of a calculated
cell so when navigating through the time.agg dimension, the time.calendar
defaults to the top (ALL) level.

Thanks for any help you can lend.
--
-Ted