Hi,

Is it possible to show KPIs from SSAS in HTML using XMLA and what is
the MDX code to show the KPIs ?

Is there any HTML Viewer available showing the new KPIs from SSAS ?

Best regards,
Marco Groeneveld

Hi,

What is the MDX code to display SSAS KPIs in OLAP Report ?

I can display the SSAS Adventure Works DW KPI for Internet Revenue:

Select non empty HIERARCHIZE(DISTINCT({{
[Product].[Product Line].[(All)].AllMembers,
[Product].[Product Line].[All Products].Children}})) on rows,
non empty {
KPIValue('Internet Revenue'), KPIGoal('Internet Revenue'),
KPIStatus('Internet Revenue'), KPITrend('Internet Revenue')} on columns
But I want to show all KPIs like in the SSAS 2005 KPI Browser any idea?

Regards,
Marco Groeneveld
www.gmsbv.nl

you have to create a code which use the ADOMD.Net object model to list all
the KPIs available, then diplay them.
Look at this article:
http://sqljunkies.com/WebLog/mosha/a...2/06/5433.aspx


"Marco" <olap (AT) gmsbv (DOT) nl> wrote

see
http://www.activeinterface.com/b2005_11_22.html
for an example of a pure XMLA solution

Chris

"Marco" <olap (AT) gmsbv (DOT) nl> wrote