dbTalk Databases Forums  

Virtual cube using a two cube with different time level

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Virtual cube using a two cube with different time level in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Tomas
 
Posts: n/a

Default Virtual cube using a two cube with different time level - 10-06-2005 , 09:30 AM






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



Reply With Quote
  #2  
Old   
Darren Gosbell
 
Posts: n/a

Default Re: Virtual cube using a two cube with different time level - 10-07-2005 , 05:24 PM






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



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.