COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Metric Studio => Topic started by: Abdulillah Faruqi on 26 Sep 2012 12:59:42 PM

Title: Data Entry for Manual Driven KPI's
Post by: Abdulillah Faruqi on 26 Sep 2012 12:59:42 PM
On any Balanced Scorecard, there could be a scenerio that all KPIs are not driven from organization Corporate Applications databases and there is a need to capture some data from manual data entry.

I would like to know , how is the data captured for the KPI's which are not having any operational data source in the organization. We have to capture them eventually to report on them into the Balanced Scorecard and Dashboard.
Which tool is used to capture such information and bring it in the BSC.

Would be greatful, for the company's have come across such situation which is very normal, I guess and how they have handled them.
Title: Re: Data Entry for Manual Driven KPI's
Post by: tjohnson3050 on 26 Sep 2012 05:17:31 PM
The Metric Studio portion of Cognos BI, among other things, provides a method of distribuiting data entry of target values via a web interface out to business users.

http://forms.cognos.com/?elqPURLPage=4496&offid=od_scorecards_whats_new_in_ibm_cognos_10&mc=-web_google_search&s_cmp=Google-Display-SWG-Cognos-OD-3106&cm=k&gclid=CKOqn-Gi1LICFegWMgodtgQA5w
Title: Re: Data Entry for Manual Driven KPI's
Post by: bdbits on 26 Sep 2012 05:22:15 PM
Or if you don't have Metric Studio (or even if you do) you could use a spreadsheet either directly as input to the dashboard, or as input to an ETL process. Or create an app that lets someone update a table in your warehouse.
Title: Re: Data Entry for Manual Driven KPI's
Post by: cognostechie on 26 Sep 2012 05:48:43 PM
Are you actually talking about KPIs or data to support those KPIs ? As tjohnson suggested, Metric Studio lets you capture some data (standards to be measured against actuals).

You can also capture the data into an Excel file and build a cube or even use that Excel file in Framework Manager and then use that in your scorecard. There are various ways to capture data.