Hi,

I'm building a cube (SSAS 2005) and would like to use tables from
different databases as follows:

DI Database has my fact table with the following:
Date
Product
TotalAmount

Utilities Database has a custom time table that aggregates the date in
the fact table to our specific needs (i.e. week(ending on Sunday)).

How can I use the time table in the Utilities database with my fact
table that is in the DI database?
I am able to create the two data source views and dimensions for the
tables, but have not found how to use them in the same cube.

Currently, I created a view in my DI database for the time table so
that all "tables" are in the same database -- solves the problem, but I
would rather not have to build views just to do this.

Thanks,
Patti

One cube can have only one single data source view.

A data source view, however, can reference one or more data source.

Below is from http://msdn2.microsoft.com/en-us/library/ms174778.aspx

---
When defining a data source view that contains tables, views, or columns
from multiple data sources, the first data source from which you add objects
to the data source view is designated as the primary data source (you cannot
change the primary data source after it is defined). After defining a data
source view based on objects from a single data source, you can then add
objects from other data sources. If an OLAP processing or a data mining
query requires data from multiple data sources in a single query, the
primary data source must support remote queries using OpenRowset.
---

Ohjoo


"Patti" <xphile3101 (AT) yahoo (DOT) com> wrote

Thanks! That works

Ohjoo Kwon wrote: