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. If you’re using Klips, optionally select the checkbox to Model your data. If you’re using PowerMetrics, which requires modelled data sources, you’ll automatically enter the modeller after clicking Continue. Learn more about modelling data sources.
  3. Click Continue.
  4. Name, choose refresh settings, and, optionally, share your data source.
  5. Click Save.

The data source is added to your account and is ready to use for custom metrics or custom Klips. You can see all your data sources in your Data Source Library, accessed by clicking Data Sources in the left navigation sidebar.

Have more questions? Submit a request