Hi all,

How to find out all the Cubes or OLAP databases available on the
analysis server (in SSAS)? Like, for database engine we can use
sp_databases which returns us all the available databases..

Regards,
Gayatri

look at the XML/A commands
or the ADOMD.NET API

"gayu" <gayatri.kulkarni (AT) gmail (DOT) com> wrote

Jeje is right, specifically you can query a schema rowset called
DBSCHEMA_CATALOGS. Either by sending the following XMLA


<Discover xmlns="urn:schemas-microsoft-com:xml-analysis">

<RequestType>DBSCHEMA_CATALOGS</RequestType>

<Restrictions>
<RestrictionList>
</RestrictionList>
</Restrictions>

<Properties>
<PropertyList>
</PropertyList>
</Properties>
</Discover>


....or by using the GetSchemaDataset() method of the AdomdConnection
object from the AdomdClient library.

You can access pretty much all of the metadata available in Analysis
Services through these schema rowset. Most of them are documents to some
extent in BOL or you can issue an DISCOVER_SCHEMA_ROWSETS query and the
server will tell you what schema rowsets it supports. The template
explorer in SSMS has a built-in template for DISCOVER_SCHEMA_ROWSETS.

--
Regards
Darren Gosbell - SQL Server MVP
Blog: http://www.geekswithblogs.net/darrengosbell

In article <OXbvvBUlGHA.4100 (AT) TK2MSFTNGP05 (DOT) phx.gbl>,
willgart_A_ (AT) hotmail_A_ (DOT) com says...