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