configurable goal value in KPI list

i am using a Sharepoint 2007 KPI list which is drawing data from an SSAS KPI . The goal, trend etc are coming from the SSAS itself. Is there a property which i can set in sharepoint itself so that the GOAL value of the KPI can be set by the Sharepoint Admin/user in the site itself while seeing the KPI stats in the website ?

I tried keeping the goal expression blank from the SSAS KPI (in an attempt that sharepoint lets me set it at its end ) but it still doesnt make the sharepoint KPI GOAL value configurable.

Any help is appreciated.

Thanks.

[578 byte] By [bhudevvats] at [2008-2-16]
# 1
Hi
You can have a seperate Fact table say FactTarget measures of which are being referred in the Goal Expression of the KPI in the SSAS cube. You can modify the values in this table from SharePoint by custom web parts. Automatically these values get reflected in your KPIs.

Thanks
Guruprasad Karnik

gpk2005 at 2007-9-12 > top of Msdn Tech,SharePoint Products and Technologies,SharePoint - Business Intelligence...

SharePoint Products and Technologies

Site Classified