Hi,
I am using MS Analysis services for cube building. At the
database level, we are using three different database
schema to keep customer data,standard data and code tables
on the same server.I need to create the dimensions from
all these 3 databases and include all these dimensions in
a cube.

I am able to create shared dimensions from three different
database. But I am not able to include those dimensions in
cube structure. I am wondering when MS AS allows to create
the dimensions from multiple database,why it is not
listing the dimensions created from other database
(datasource).

I feel, there should be someway, which I am not aware.
pls. help me ..

thanks,
partha

It's not possible. What you'll need to do is create one database and build
views that source data from those other databases.



-Sean


--
Sean

--
Sean Boon
SQL Server BI Product Unit

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.

"Partha" <anonymous (AT) discussions (DOT) microsoft.com> wrote

While it allows creating the dimensions from separate DB,
I really don't understand why MS AS was designed not
include those dimensions in a cube structure.
Ok, if it is designed for some reason, then what is the
use of allowing us to create 'those' dimensions from
separate DB.

It is really misleading.