| Author |
 Topic  |
|
|
marco
Netherlands
588 Posts |
 Posted - 02/20/2006 : 07:28:59
|
Hi,
What is the MDX code to display SSAS KPIs in OLAP Report ?
I can display the 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
From [Adventure Works]
But I want to show all KPIs like in the SSAS 2005 KPI Browser any idea?
Regards,
Marco Groeneveld
www.gmsbv.nl |
Edited by - marco on 02/20/2006 12:52:00 |
|
|
admin
1643 Posts |
Posted - 02/20/2006 : 12:54:56
|
SELECT { [Measures].[Total Product Cost],
KPIValue('Product Gross Profit Margin'),
KPIGoal('Product Gross Profit Margin'),
KPIStatus('Product Gross Profit Margin'),
KPITrend('Product Gross Profit Margin') } ON COLUMNS,
{ [Product].[Category].CHILDREN } ON ROWS
FROM [Adventure Works]
MDX functions in Analysis Services 2005
http://www.sqljunkies.com/HowTo/9D6C4A2A-D991-48FE-8962-D439A46E6640.scuk |
 |
|
| |
Topic |
|
|
|
Report Portal
SSAS KPI display
