dbTalk Databases Forums  

Creating local cube from several server cubes

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


Discuss Creating local cube from several server cubes in the microsoft.public.sqlserver.olap forum.



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

Default Creating local cube from several server cubes - 06-22-2005 , 01:01 AM






Hello

I am trying to create a local cube using (CREATE GLOBAL CUBE) fro
man
server cubes. Is it doable

I tried the following (CREATE GLOBAL CUBE [SalesLocal] ... FRO
[Sales], [Budget] ...) but I received this error: Formula error
global cubes can only accept a single cube in the source cube list.

In the linked document
http://www.microsoft.com/technet/pro...n/anserddl.msp

I found the following
When using the CREATE GLOBAL CUBE statement, consider the following
1. You can store more than one cube in a single local cube file. Thi
is a
excellent way to group local cubes according to business purpose

But I could not find how

Thank
Yone


Reply With Quote
  #2  
Old   
karenmiddleol@yahoo.com
 
Posts: n/a

Default Re: Creating local cube from several server cubes - 06-22-2005 , 09:01 AM






Can you not use a virtual cube which as all these basic cubes.

Karen


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.