Author Topic: Data Entry for Manual Driven KPI's  (Read 2516 times)

Offline Abdulillah Faruqi

  • Associate
  • **
  • Join Date: Apr 2011
  • Posts: 4
  • Forum Citizenship: +0/-0
Data Entry for Manual Driven KPI's
« 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.
« Last Edit: 26 Sep 2012 01:01:30 pm by Abdulillah Faruqi »

Offline tjohnson3050

  • IBM Certified Solution Expert - Cognos BI
  • Statesman
  • ******
  • Join Date: Dec 2011
  • Posts: 370
  • Forum Citizenship: +63/-0
  • The only dumb question is the one never asked.
    • Linked In Profile
Re: Data Entry for Manual Driven KPI's
« Reply #1 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

Offline bdbits

  • Super Moderator
  • Statesman
  • ******
  • Join Date: Feb 2010
  • Posts: 1,783
  • Forum Citizenship: +105/-0
Re: Data Entry for Manual Driven KPI's
« Reply #2 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.

Offline cognostechie

  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 1,549
  • Forum Citizenship: +132/-7
    • Pervisol
Re: Data Entry for Manual Driven KPI's
« Reply #3 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.

 


       
Twittear