Importing Scorecard Metrics

[teelee]

Hello All,
I'm working with  Cognos Metrics Studio, and trying to figure out how I can set-up my data in Excel so that it can be converted to a SQL data base file to use in Metrics Studio.

Can anyone help? What am I doing wrong?  Is there any documentation anywhere that I can refer to that can assist me with setting up the metrics the correct way in Excel so that I have useable data?

This is what I've done----
I created an Excel file containing several worksheets (so I can link the data once imported into SQL) with the information needed.  However, for some reason, when I try to link the data once it is in SQL, it fails, and I'm stumped.  Can't figure out what I need to do.

Can anyone please help??? ???

Thanks in advance... :)

importing scorecard metrics from Excel into cognos