Basic Analysis Server questions

1) Can an AS database be created from multiple data sources .. i.e. can we
create cubes with tables( dimensions) that may belong on different data
sources ?
2) What kind of storage mode do I currently have ? How do I check ? I know
there are a few types such as ROLAP,MOLAP,HOLAP. Is there a way I can find
out from AS Manager how the cube was created ?
3) I believe the default is MOLAP.. And where are the cubes physically
stored ? How can I find the path ?
> 1) Can an AS database be created from multiple data sources .. i.e. can we
> create cubes with tables( dimensions) that may belong on different data
> sources ?
With SQL Server 2000, No.
Your best bet is to create views in one data source which reference
structures in the other.
We have a better story coming in SQL Server 2005.

> 2) What kind of storage mode do I currently have ? How do I check ? I know
> there are a few types such as ROLAP,MOLAP,HOLAP. Is there a way I can find
> out from AS Manager how the cube was created ?
If you edit the partition, Analysis Manager tells you storage mode the
partition is in.

> 3) I believe the default is MOLAP.. And where are the cubes physically
> stored ? How can I find the path ?
In SQL Server 2000, everything is stored off the data path.
Typically <install folder>\Data, e.g. C:\Program Files\Microsoft Analysis
Services\Data
Hope that helps.
Dave Wickert [MSFT]
dwickert@.online.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.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:ubJ6mBQMFHA.1172@.TK2MSFTNGP12.phx.gbl...
> 1) Can an AS database be created from multiple data sources .. i.e. can we
> create cubes with tables( dimensions) that may belong on different data
> sources ?
> 2) What kind of storage mode do I currently have ? How do I check ? I know
> there are a few types such as ROLAP,MOLAP,HOLAP. Is there a way I can find
> out from AS Manager how the cube was created ?
> 3) I believe the default is MOLAP.. And where are the cubes physically
> stored ? How can I find the path ?
>
>