why any function related to prior period in my data does not work?

Helen999888

Hi, all,

I am encountering a very strange problem that I cant get any value for prior period for my KPI. E.g, I am defining a KPI goal which will be the value of the prior period multiplies 1.2, but then no result returned for this definition, only result returned for value of current period, if I defined the goal as anything of current period Why is that

I am very much looking forward for your help.

Thanks.

With best regards,

Yours sincerely,

Darren Gosbell


Do you have your time dimension set up as a "Time" type and are all the attributes in their default order I have seen some databases where the user wanted the time members to appear in descending order, but this "breaks" a lot of the built-in time calculation functions as they all assume that the attributes are in ascending order.

Helen999888

Hi, Darren,

Thank you very much for your kind advices. No, I dont have my time dimension set up as 'Time' Type. It is as normal as other dimensions in the cube. Is it because of this reason Therefore in order to let the system knwo the order of the time, we will have to set the time dimension as 'Time' Type I am looking forward to hearing from you shortly and thanks a lot.

With best regards,

Yours sincerely,

Darren Gosbell

yes, if you are talking about time based functions like ParallelPeriod() and PeriodsToDate(), etc. they look for a dimension with a type of "Time", having the year and quarter attributes set with the appropriate types is important to if you want to do YTD and QTD. If you have not changed the default ordering, that should still be OK.

Note: you just have to set the Type property on the dimension and attributes, you don't have to use a server time dimension or anything like that.

Helen999888

Hi, Darren,

Thanks. But the fact is the time dimension have already been set as 'Time' type in my case. But still the problem remains Why is that Any other ideas Thanks and I am looking forward to hearing from all of you here.

With best regards,

Yours sincerely,

Darren Gosbell

I can't think of any more obvious issues, you might need to be more specific with your issue. What were you trying to do What results did you get What results were you expecting

Helen999888

Hi,

Thanks.

What in my data is :

for year 2006, I have records for month of 11 and 12. And I have dimensions like regions. What I am trying to do is to set up a KPI for regions. The goal is the 1.3 times of its previous period(e.g. the goal target of month of 12 will be 1.3 times of month of 11). But the problem is, it does not return any results for this. Why is that

Hope it is clear and I am looking forward to hearing from all of you here.

With best regards,

Yours sincerely,

Darren Gosbell

What is the MDX you are using in your KPI and How are you testing it Are you using an MDX query or the KPI viewer

Helen999888

Simply, the MDX for the goa is : ([Measures].[measure_name],[Date].[hierarchy_name].[level_name].prevmember])*1.3

I am using KPI viewer to test it.

Darren Gosbell

This is not a valid statement. You have a trailing "]" after the prevmember and prevmember is not valid against a level, it needs a member. You can also use a hierarchy as this implies the currentmember of the hierarchy. So something like the following should work.

([Measures.[measure_name],[Date].[hierarchy_name].prevmember) * 1.3

I have not checked, but the KPI viewer looks like it might be using sub-select to filter the data which will not set the context for the outer query. You might get a better idea of if it is working by testing your KPI with an MDX query like the following:

select

{KPIValue("KPI"), KPIGoal("KPI")} on columns,

[Date].[Calendar].Members on rows

FROM [Adventure Works]

Helen999888

Hi, Darren,

Thanks a lot. It works perfectly now.

With best regards,

Yours sincerely,