Use XMLA as a data source

 The XMLA connector allows you to send MDX queries to XMLA enabled data sources.

  1. Click Data Sources in the left navigation bar.

If you don’t see the above option, go to the bottom of the left navigation sidebar and click your Account Name > Data Sources instead.

  1. Click the Create a New Data Source button.
  2. Select XMLA from the list of connectors.
  3. On the Configure your data source page, provide the following information:
    • Host
    • Username
    • Password
    • Query
  1. Click Get data.
  2. Ensure this is the data you’re looking for and, optionally, select the checkbox to Model your data. Learn more about modelling your data source here.
  3. Click Continue.
  4. Name, choose refresh settings, and, optionally, share your data source.
  5. Click Save.

The data source is created and stored in your list of data sources for use in a Klip or a PowerMetric.

Have more questions? Submit a request