TRANSFORMER

MDX source

To use an MDX or Hyperion resource as source in a Transformer project, it must first be imported. See Resources for information on how to import an MDX source.

Transformer connects to Analysis Server in this way:

Transformer contacts a .dll on the server, usually the server running Analysis Server. This .dll has been published via Internet Information Server. In turn the .dll contacts Analysis Server and routes the response back to Transformer.
XMLA 1.1 and MSXML 4.0 from Microsoft are needed to set up the .dll. They are libraries that must be installed on the machine where the .dlls are published.

Creating an MDX source

Right click in the Transformer design panel and choose Source -> MDX source. Now double click the MDX source icon to configure it.

It is possible to 'Drag and Drop' an MDX resource from the Resources panel to the Design panel to use as an MDX source.

Properties

General

Name - the name "MDX source" is generated automatically but it may be changed
Description - an optional text describing the MDX source

Audit

Modified by - the name of the last user to make changes to the object.
Last modified - the date and time when the object was last changed.
Created by - the name of the user who created the object.
Created - the date and time when the object was created.

Custom

Connector - click the icon to the right and choose the desired resource. Choose either an MDX or Hyperion resources. The information necessary to connect to the MDX resource should already be defined in Resources.

MDX query - enter an MDX query directly in the field

The context date to use must be specified in the query. This can either be a fixed date or a dynamic one. Use the Date calculator that opens when you click the icon to the right of the field to help construct a dynamic date. E.g. to define the year to use, mark Year at the top, then click the appropriate button in one of the columns below. When you click OK the correct query syntax will be created. Month and Day can be defined in the same way.

Syntax:

Date function.year --> yyyy
Date function.month --> MM
Date function.date --> dd

For example:

+1M+2Y.year
+1M+2Y.month
+1M+2Y.date