Can we create cube using different databases? I mean Fact table from one
database and dimensions from another database on the same server.

Thanks,
Yalaman

Unfortunately, no. This is a frequently asked for feature and you will be
able to do so with SSAS in SQL Server 2005.
--
Dave Wickert [MSFT]
dwickert (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.

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

Try using distributed query to create view to achieve the same result.

Thanks,
James

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