Using Planning Analytics (TM1) data in Qlik Sense
In this post two worlds collide as the topic is on using data from Planning Analytics (TM1) as a data source for Qlik.
There are a lot of ways you can do this including third party connectors or creating flat files from TM1, though out of the box you can use the TM1 API via the Qlik REST API connector to bring back data and this example shows how to do that using a public cube view as the source.
Create the connection in Qlik Sense.
Set the URL:
https://<PA server>:<port number>/api/v1/Cubes('<cube>')/Views('<view>')/tm1.Execute?$expand=Axes($expand=Hierarchies($select=Name),Tuples($expand=Members($select=Name))),Cells<PA server> Name or ip address of the PA database server (admin host)
<port number> Base on value against the HTTPPortNumber parameter in the tm1s.cfg file
<cube> Name of the cube
<view> Name of the public viewSet the Method field to POST
Set Authentication to Basic (assuming using TM1 built in authentication)
Enter the username and password
Set Certificate Validation to Skip Server Certificate Validation
Add in a query header called content-type with a value of application/json; charset=utf-8
Click the Save button
It should just work, if not check your configuration against the sample images at the end of this post where the updated fields have been highlighted.
Select the data
Click the Select data button under the new PA REST connection created in step 1
When the selection box appears, click the root folder (left hand side)
Click the Insert Script button
That’s all there is to it. You should then have the dimensions, elements and values flowing through into your data model. From there you may want to tidy up the field names in the model otherwise, enjoy!
REST connection images
Select data image
