dimesion source table help

#1

I have my fact table in 1 database, and my star / dimension source tables in
another database.

they are both on the same sql 2k server.

I can add both datasources to the AS manager. I can create dimensions from
the tables.

I can not use the dimesions when building a cube! They dont show up. Only
those shared dimensions I created from the fact table database.

Thanks,

PCH

#2

You could utilize a SQL view for this.

--
Ray Higdon MCSE, MCDBA, CCNA
--
"PCH" <pch12 (AT) hotmail (DOT) com> wrote

Quote:

I have my fact table in 1 database, and my star / dimension source tables
in
another database.

they are both on the same sql 2k server.

I can add both datasources to the AS manager. I can create dimensions
from
the tables.

I can not use the dimesions when building a cube! They dont show up.
Only
those shared dimensions I created from the fact table database.

Thanks,

PCH

#3

Thanks!

Is there a spefic reason why you cant do it directly?

"Ray Higdon" <rayhigdon (AT) higdonconsulting (DOT) com> wrote

Quote:

You could utilize a SQL view for this.

--
Ray Higdon MCSE, MCDBA, CCNA
--
"PCH" <pch12 (AT) hotmail (DOT) com> wrote in message
news:eXVIYbCuDHA.2180 (AT) TK2MSFTNGP09 (DOT) phx.gbl...
I have my fact table in 1 database, and my star / dimension source
tables
in
another database.

they are both on the same sql 2k server.

I can add both datasources to the AS manager. I can create dimensions
from
the tables.

I can not use the dimesions when building a cube! They dont show up.
Only
those shared dimensions I created from the fact table database.

Thanks,

PCH

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

dimesion source table help

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

dimesion source table help - 12-01-2003 , 10:19 AM

Re: dimesion source table help - 12-01-2003 , 11:36 AM

Re: dimesion source table help - 12-01-2003 , 01:48 PM