dbTalk Databases Forums  

Creating virtaul cube from the physical cubes from two different data sources

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


Discuss Creating virtaul cube from the physical cubes from two different data sources in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
anji_reddy@dell.com
 
Posts: n/a

Default Creating virtaul cube from the physical cubes from two different data sources - 11-04-2005 , 09:39 AM






All,
Need your help.
I have cube1 in Ownership database
I have cube2 in Concession database.
I have shared dimensions for both the cubes. How to create virtual cube out of these databse cubes.
Just to be on same page, I know how to create virtual cube from Single data base.
Thanks,
Anji Reddy paluri

************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

Reply With Quote
  #2  
Old   
Paul
 
Posts: n/a

Default RE: Creating virtaul cube from the physical cubes from two different d - 11-04-2005 , 11:22 AM






Hi,
You need the Enterprise version, then right click cubes and choose 'New
Linked Cube' to attached a cube in one database to another database and then
create your virtual cube just as you would normally.
Ta
Paul

"Anji Reddy" wrote:

Quote:
All,
Need your help.
I have cube1 in Ownership database
I have cube2 in Concession database.
I have shared dimensions for both the cubes. How to create virtual cube out of these databse cubes.
Just to be on same page, I know how to create virtual cube from Single data base.
Thanks,
Anji Reddy paluri

************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...


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.