You would normally do this by using the same (shared) dimension in both
cubes. In the Budget cube you would disable the Date level.
--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell
In article <DE15D6A3-8313-4F45-91BD-CA8DD98B7A18 (AT) microsoft (DOT) com>,
Tomas (AT) discussions (DOT) microsoft.com says...
Quote:
I have a cube for sales order at the invoice date level (1/1/2005) using a
Time dimension that has Year,Quarter,Month and Date.
I have another Cube which is Budget base on a month level Jan 2005, again
using a time dimension that has Year,Quarter and Month only.
This two cube do share common Dimension, but here is the question.
How do create a virtual cube such that you can still query the cube using
dates for the sales order, but receive budget also.
thank you |