Where are ROLAP tables in Analysis Server?

[Guest_imported]

I have a ROLAP cube defined in MS Analysis Server, the fact/dim tables are in SQL Server (on the same physical server). Where do the aggreagation tables go? How can I get to them to run SQL queries on them?

Thanks,
Bob

 

[mhweiss]

you have probably figured this out by now, but I just joined the list...the ROLAP tables are created and stored in the database that serves as the data source for your analysis services database...ie, if you create a new analysis database and select 'mydb' as the underlying database, analysis services will create the rolap tables in 'mydb'...
hth,
Michael