Hi all,
I've use this function in my KPI goal expression as shown below:
(
PARALLELPERIOD([Dim Time].[Acct_Period].[CalYr],1,[Dim Time].[Acct_Period].CurrentMember),[Measures].[Tran Amt])*1.1
I have a time dimensions hirearchy called [acct_period], it will start from Calyr --> CalQtr --> Period. In my KPI goal, I want to set the goal as 10% increase from the same period last year. The cube is deployed fine. However, when I go to my KPI browser, there is no goal value displayed after I apply some dimension criteria. It looks to me the system does not know the value of the last argument of this function because if I put a specific period as oppose to use the currentmember, I can see the goal value. But I just can't find anything wrong with this snytax. Any ideas
Thanks in advance.
wenchi