Q:

We are implementing a balanced scorecard (BSC) application and are going to use our existing data warehouse as the source system. Our problem is that some of the necessary data is not available in the data warehouse and there are no operational systems that can be used as source as well. So people have to manually key in some highly aggregated figures into the BSC application. Now my question: are there any recommendations as to which tools to use for this (meta data support is an issue)?

A:

Chuck Kelley’s Answer: Why not have them key it into an application and then use the ETL process to load the data into the data warehouse? This application may be no more than an excel spreadsheet. Then everything would be documented in the meta data. Clay Rehm’s Answer: These types of situations happen more than you think. You have many options, and one option is to classify the BSC application as both a source and reporting application. The data that is stored in the BSC database can be fed into the data warehouse, using any ETL tool, preferably one that tracks meta data. If this data entry into the BSC is a short term solution, then you may consider a less costly solution, and that is using one of the tools within your company’s standard suite. This could be anything from COBOL, VB, SAS, etc.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access