When I view the KPI in browser view, what is the time for which the KPI is applied. Is it todays date for which the KPI displays value and goals or some time in the past. How can I see the value of KPI for time in the past, for eg, like June 2003.
Thanks,
Vijay
If you have not pointed to a time member in a calculated member(that you use for your KPI) or in the definition of the KPI, it is always time current member.
More clearly it then depends on the time members on of the axis or if you have filtered or sliced by the time dimension.
HTH
Thomas Ivarsson
|||In the browser view of KPI tab, I am not slicing by any time dimension. I am viewing what is shown as default after creating the KPI. The KPI value seems to be a cumulative value over all the time. For eg, if the sales amount is the value, and the sales quota is the goal, then the values displayed are the sum over all the years. This does not make sense to me.
If I filter by time dimension like Calendar Year, then I would expect the sales amount and sales quota for that calendar year.
|||The current member for your time dimension is "All". I agree that this does not make sence.
You should be aware of that the browser in the KPI-tab is not always correct.
My advice is to look at the KPI with Excel 2007 or ProClarity Professional 6.3
In the adventure works cube project, part of the installation of samples, you have examples of KPI
Here is a link to a good article about KPI
http://www.databasejournal.com/features/mssql/article.php/3604206
HTH
Thomas Ivarsson
No comments:
Post a Comment