KPI and MDX in Goal-Expression

Hi,

Why does a MDX-Expression like

([Dim Time].[CalendarYear].PrevMember, [Measures].[Sales Amount - Fact Reseller Sales])

not work within a KPI-Goal-Expression ?

Is there a work-around for that?

Best whishes,
Manfred

Hi Manfred,

what does it means "not work within a KPI-Goal-Expression"

Simply you don't see data or you receive an error message?

If you simply don't see data maybe the "CurrentMember" for "[Dim Time].[CalendarYear]" is "All Periods" in your KPI-Goal-Expression context so AS can't find a PreviousMember.

sql

KPI

Hi all,

I've created a KPI and it is working correctly, however, I don't see it in the cube browser under the measures group? Where can I set the property to have it appear?

Thanks,

Mark

You can see KPI on "Browser View" mode on KPI's tab or sending an MDX query from the SQL Server Management Studio.

Francesco

|||Thanks Francesco, I do see it there. How can I get it to render via an Excel (2007) pivot table? I recall having generated one when I was using the Beta version of 2007.