Hi All:
I am running AS 2000 Ent., SP 3a on Windows 2000.
I have this problem wih more than one data source- I can
select dimensions/fact tables from one data source only.
When I try to make a new cube, both the data sources show
up, but when I select the fact table and move on to make
dimensions, I can only see the datasource that the fact
table belongs to.

Does anybody have similar experience?
What I am trying to do is this-
a. Pull all the Dimension tables to SQL Server.
b. Connect to the fact tables/views on the DM(Oracle)
directly.
c. Make cube on the SQL Server.

Thanks.

All fact data must reside in the same table...You can try
to make calculated members or user unary lookups to other
cubes that contain facts.

-mike

Mike:
Thanks for your prompt reply. What I meant was this-
I have a fact table in Oracle and the Dims in SQL Server
and cannot seem to build a single cube using this two
databases. Is that by design or a bug?
LD

By design. The dimension tables must be in the same database, or at least
appear so to Analysis Services. (The tables must be joinable.)

tom @ the domain below
www.tomchester.net


"LD" <lalatendu.dhal (AT) pearsoned (DOT) com> wrote

Small correction: It is possible to define multiple partitions i the cube,
and each partition can have its own data source.

--
==================================================
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.
==================================================

Tom:
Thanks. Good to know. tried various versions- thinking that happens only in
the desktop version. Could have saved me a lot of storage space. I tried
creating an Oracle linked server (from SQL Server)- and viewing the fact
table. Problem is the data types are all messed up when using the MS OLEDB
provider and have to cast/convert to get the desired type, besides being
rather slow (there are 30m records in each fact table). Wondering if there
is a better way.

Mosha:
All my facts are in one table, but the fact tables are in Oracle and the
dimension tables in SQL Server 2000. And when I try to design a cube,
starting from the 'Select Fact table' screen, if I select the Oracle fact
table, in subsequent screens for adding the dimensions tables only the
Oracle data source is visible.

LD

"Tom Chester" <publicNOSPAM (AT) tomchester (DOT) net> wrote

Can you use DTS to bring the fact table to SQL Server, or dimension tables
to Oracle ?

--
==================================================
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.
==================================================

Thanks for your reply.Yes, I can use DTS to get the fact tables, but it will
be better to have the dimension tables in Oracle and create the cube.

"Mosha Pasumansky [MS]" <moshap (AT) microsoft (DOT) com> wrote