QuickStart for QlikView (batch mode)

This Quick Start Guide gives you the basic steps you need to know to begin creating exports in batch mode for import into QlikView (via a QVX file). Batch mode should be used under the following conditions:
 

Data volumes are large

QlikView Web client will be used by userstm1

Information from TM1 only needs to be refreshed on a periodic basis

 

Basic Export Creation Steps

hmtoggle_arrow1 Define the basic content of the data to be extracted

Use the TM1 Cube Viewer to create a view that closely resembles the bulk of information that is to be displayed on the form or report. Get this view to look as close to the final format that you want to display and save it as a public view.
 
Unlike TM1, QlikView prefers information in a relational format where the data values correspond with the column headings (measures), rather than on the rows. The following view has the accounts on the rows and the months on the columns. Although this may appear to be a typical view in TM1 (and applications can import this data file easily), it will however, turn out to be difficult to work with when attempting to obtain a quarterly total for the Cash (1110) account.

Basic View Bad
 
 
The following view contains the same exact information, however, the measures are in the columns and months are in the rows. This view is not only easy to load, but Quarterly totals for Cash (1110) can be easily calculated with a formula that operates over all rows within a specific column. The remaining dimensions can be configured as needed.

Basic View

 
Once the view is created, it should be saved as a public view.

Save View

hmtoggle_arrow1 Select the view to export in TM1Connect

Using Internet Explorer, Chrome, Firefox (or other web browser), go to the URL of TM1Connect (typically http://servername/TM1Connect).
 
When the page loads, you will be presented with a list of cubes that are contained within your server.

TM1Connect - Cube List

Expand the desired cube and locate the saved view created in the previous step.

TM1Connect - Select View

hmtoggle_arrow1 Schedule/Run the extract

The next step is to either schedule the view to be exported, or request it be performed immediately. To execute the export on demand, select the Scheduler tab.

TM1Connect - Batch - Data Export

 

Tips_200

If the view you selected from TM1 uses consolidated values, uncheck the Skip Consolidated Values setting in the Advanced tab before running the extract.

 
Next, confirm the name of the file to export the data to and click on the Save and Run Now button.

TM1Connect - Batch - Run Now

 

hmtoggle_arrow1 Load QVX in QlikView

Once the extract is complete, the QVX file will be located in the Export Directory configured during installation. To load the data into QlikView, select Table Files from the Edit Script dialog:

TM1Connect - QlikView - Table Files

Navigate to the extracted file.

TM1Connect - Batch - Select QVX File

 
The data being loaded into QlikView should look the same as in TM1.

TM1Connect - Batch - Load QVX