If you are unable to create a new account, please email bspsoftware@techdata.com

Author Topic: Load data from Excel  (Read 9233 times)

terry_stjean

  • Guest
Load data from Excel
« on: 16 Oct 2008 07:58:33 am »
Is there a way to load data from an Excel file into Metric Studio?

JoeBoxer

  • Guest
Re: Load data from Excel
« Reply #1 on: 28 Dec 2008 12:27:46 pm »
You can convert the excel sheets to tab-delimited files.  Metrics studio can import from tab delimited files.  Conversely, you can also export your metrics to tab-delimited files.  This makes it very portable and convenient.

You can get a precise description of the tab-delimited file structures in the appendix of the users guide.  Its time well spent.

If you are looking to import new metric data, then the .cmv, and .cmo files will become your best friends.

Ursula Hill

  • Guest
Re: Load data from Excel
« Reply #2 on: 14 Apr 2011 03:55:05 pm »
You can also place the excel file into framework manaer as a query subject. Then pull the QS into your package and republish you package. Then open up the Metric Designer Model that points to your revised package.  Create an extract and selete the QS of the excel file that will be used to populate your measure(s).