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

Offline tstjean

  • Community Leader
  • *****
  • Join Date: May 2007
  • Posts: 89
  • Forum Citizenship: +0/-0
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?

Offline JoeBoxer

  • Full Member
  • ***
  • Join Date: Dec 2008
  • Posts: 19
  • Forum Citizenship: +0/-0
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.

Offline Ursula Hill

  • Associate
  • **
  • Join Date: Sep 2009
  • Posts: 3
  • Forum Citizenship: +0/-0
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).