Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> SQL Server Analysis Services

OLE DB for OLAP Schema Rowsets - MDSCHEMA_KPIS GUID?

I'm trying to get the KPI's (Key Performance Indicators) from SQL Server 2005 - Analysis Services 9.0 by using VB6 and the OpenSchema method. According to SQL Server Books Online the MDSCHEMA_KPIS rowset should do it.

Anyone know where to find MDSCHEMA_KPIS GUID?

Rgds,
Jan

[287 byte] By [JanFerneman] at [2008-2-20]
«« Context Menu Question
»» How can I get a Field From A Dataset
# 1
This is GUID for KPI schema rowset:

{2AE44109-ED3D-4842-B16F-B694D1CB0E3F}

I checked it with SchemaRowsetExplorer from SQL Server 2000 Resource Kit and it functions properly.

best regards!

GregStolecki at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Analysis Services...
# 2
And this is the way (discovered by my friend Sebastian):

In SQL Server Management Studio click button "New Query" and select Analysis Services XMLA Query. In Query Window enter:

<Discover xmlns="urn:schemas-microsoft-com:xml-analysis">
<RequestType>DISCOVER_SCHEMA_ROWSETS</RequestType>
<Restrictions>
<RestrictionList>
</RestrictionList>
</Restrictions>
<Properties>
<PropertyList>
</PropertyList>
</Properties>
</Discover>

Result contains all schemas' names and GUIDs.

Best Regards!

GregStolecki at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Analysis Services...
SQL Server
SQL Server Analysis Services

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified