Hi,
I want to create kpi out of the BI studio. So can anybody suggest the dll that can be used to create kpi from .NET.
Microsoft.AnalysisServices.AdomdClient returns the list of kpi but we cant create one using it. Can we create kpi using mdx query? If so, plz tell me a sample query.

Thanks

this feature is available with AS2005, not 2000.
so post your question in the SQL Server 2005 beta newsgroup.

but from my knowledge, creating a KPI use near the same syntax as creating a calculated member.
"Pratibha" <pratibha (AT) intraactionsoftware (DOT) com> a écrit dans le message de news: %23RGKH3N7EHA.2072 (AT) TK2MSFTNGP10 (DOT) phx.gbl...
Hi,
I want to create kpi out of the BI studio. So can anybody suggest the dll that can be used to create kpi from .NET.
Microsoft.AnalysisServices.AdomdClient returns the list of kpi but we cant create one using it. Can we create kpi using mdx query? If so, plz tell me a sample query.

Thanks

Actually no. KPIs are metadata objects inside the cube, much like hierarchies, attributes, measure groups etc. They are created using AMO - which is the object model for managing cubes. ADOMD.NET is for querying.

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebLog/mosha
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and confers no rights.
==================================================