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