Hello forum, I want to ask you about OLAP in SQL 2000:

I have one server (SERVER1) with SQL SERVER 2000, in this I has lot of
transactional Databases and TWO Datawarehouses.
In DW1 I worked for a long time. It has lot of fact tables (FT) and
dimensional tables (DT)

When I create the DW2, in Analysis Manager I created one OLAP Database. For
this I create a DataSource (DS2) pointing to DW2 , and create a DataSource
(DS1) pointing to DW1

As my dimensional tables are in DW1, I use DS1 to create the dimensions in my
New OlapDatabase.

The matter is that When I create a CUBE, I must use the fact table in DW2. So
I choose DS2. When I want to add existing dimensions I ONLY SEE dimensions
for DS2 and can´t see dimensions that I have for DS1.

If a OLAP DataBase has 2 datasources, can´t use all the dimensions for those
two?

Please, I need help with this.

Or, if you know if SQL 2005 can use 2 datasources in a cube, one for facts
and one for dimensions...

Thanks!

--
If sun burns, sand too!

Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...-olap/200601/1

Hi Andrew,

The only way that I know to do this in AS 2000 is to create views in 1
SQL Server database which reference the other. But the new Data Source
View feature in AS 2005 can use multiple data sources:

http://groups.google.com/group/micro...olap/msg/37df5
37bdead1f6d
From: "Dave Wickert [MSFT]"
Date: Wed, 25 May 2005 15:58:06 -0700

Subject: Re: Changing data sources with Analysis Services

Sorry. You can't do it that way. AS2K does not support pulling data from
multiple data sources at the same time. You have to consolidate it into
one
(using views is the preferred way as was previously mentioned).

This is one of the top new features in SQL Server 2005.
--
Dave Wickert [MSFT]
dwick... (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no
rights.
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***