lvb


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




Re: parallelperiod

Deepak Puri


You may be encountering the same issue as discussed in the Froum thread below - the KPI browser "filter" generates a subselect rather tnan a where clause. So the KPI Goal expression may be working fine - could you test it using Excel 2007, or even with an MDX query:

KPI Goal Value doesn't change after filtering the date

...

Unfortunately, I think that the KPI browser may be misleading because, "filtering the resultset by the "Date" Dimension -> "Fiscal" Hierarchy -> equals "FY 2004" in the KPI-Browser" is probably generating a subselect, rather than applying the condition in the where clause. Try an MDX query directly, like:

>>

select {KPIGoal("Growth in Customer Base")} on 0

from [Adventure Works]

where [Date].[Fiscal].[Fiscal Year].&[2004]

-------------------------------------------------------------------------

Growth in Customer Base Goal
0.3

>>







Re: parallelperiod

lvb

Hi,

I've trid in Excel 2007 with the KPI and there is no value under KPI goal value. However, I can see the data if I run the mdx query. The query is down below

select {KPIGoal("incomekpi")} on 0

from [gltran]

where [Dim Time].[Acct_Period].[CalYr].&[2007].&[2].&[200706]

Any idea why it is not working in Excel I still thinking something wrong with my parallelperiod function call; however, I just can not find anything wrong either.

wenchi wang






Re: parallelperiod

Deepak Puri

"Any idea why it is not working in Excel " - a couple of things you could check:

  • Make sure that, when you filter by time, you're only selecting a single member.
  • Trace the MDX query generated by Excel in SQL Profiler - that will confirm how Excel is applying the filter (you could post the KPI query here, if the filter clause isn't obvious).