Using the QlikView Plug-in

The TM1Connect QlikView Plug-in allows QlikView applications to connect directly to TM1 without having to wait for a scheduled batch process to update the data. In addition to allowing real-time access to the information in TM1, TM1Connect can also leverage TM1 security for restricting information that can be seen on a user-by-user basis.

Information you will need:

In order to connect to TM1, you will need some information from the TM1Connect administrator:

 

TM1Connect URL

TM1 Username & Password (if not using integrated login)

Names of the published views that are appropriate for the application

 

hmtoggle_arrow1        Select the TM1Qonnect Plug-in in QlikView

With the TM1Connect plug in software installed, open the script editor in QlikView and select TM1Connect.exe from the database dropdown menu as shown below.

TM1Connect - OnDemand - Select Plug-in

 

The buttons on the page will change to reflect the selection of the new data source.

TM1Connect - OnDemand - Plug-In Buttons

hmtoggle_arrow1        Connect to TM1Connect

 

With the TM1Connect plug-in selected, press the the Connect... button to be prompted for the location of TM1Connect server, and user name and password to connect with TM1. Enter the TM1Connect URL provided by the administrator, along with the TM1 user name and password (or if integrated login is used in your setup, select the Use Integrated Login checkbox).

TM1Connect - OnDemand - Connect to TM1Connect

A successful log in will add a custom connection line to the QlikView script

TM1Connect - OnDemand - Custom Connect

hmtoggle_arrow1        Select the view to import into QlikView

Once you have made a successful connection to TM1Connect server, you will be presented with a list of published views that are ready for use. Select the view that was published and is ready for use provided by the TM1Connect administrator, and press the Select button.

TM1Connect - OnDemand - Select View

After the view has been selected, an SQL statement will appear in the script which will instruct QlikView what information is to be extracted from TM1Connect.

TM1Connect - OnDemand - Query

hmtoggle_arrow1        Reload the data

With the connection and the query configured, press Reload button in the top left menu bar of the QlikView Script Editor, to import the data using the normal QlikView data loading procedures. The fields returned will correspond with the columns defined in the view and will be available for loading into the QlikView document.

TM1Connect - OnDemand - Field Selection