| T O P I C R E V I E W |
| marco |
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 |
| 1 L A T E S T R E P L I E S (Newest First) |
| admin |
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 |
|
|
Report Portal
