Re: Virtual cube based on annual cubes

#1

Quote:

Say I have 2 cubes: Sales2001 and Sales2002. Both cube share the same
dimensions (Geography and Time) and have the same measure (SalesAmount). I
want to create a virtual cube to serve as the union of the two cubes. How
do
I select the measure for the new cube? Can some one give an example in DSO
or Analysis Manager?

From the names of the cubes it looks like you are trying to partition your
data by Year. If so, you will be much better of by using partitions per year
instead of cube per year. Otherwise, you would have to create a new
calculated measure with expression like

IIF( Time.CurrentMember IS Time.[2001], SalesAmount2001, SalesAmount2002 )

and hide the original measures.

HTH,
Mosha.

--
==================================================
Mosha Pasumansky - www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Virtual cube based on annual cubes

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

Re: Virtual cube based on annual cubes - 07-16-2003 , 12:23 AM