Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to connect with Qlikview directly into the TM1 cubes / data ? Currently we work via excells or csv's coming from excell export of the TM1 cubes ,but I wonder wether a direct read on TM1 through Qlikveiw is possible ?
Hi HWallays,
Yes this is possible and the performance is excellent.
I suspect you have this issue solved now, however, I have been working on a similar problem lately and wanted to share my experience, just in case anyone has the same question in the future.
Using the QlikView (or Qlik Sense) REST connector you can connect to the TM1 Rest API and extract the data you want eg dimension, cube view, MDX statement.
Example
Here is an example against the sample sdata database to bring back the details of the view1 view in cube pnlcube.
In this example I have the following options with the rest connector:
URL is: https://localhost:8010/api/v1/ ('pnlcube')/Views('view1')/tm1.Execute?$expand=Axes($expand=Hierarchies($select=Name),Tuples($expand=Members($select=Name))),Cells
- POST method
- basic authentication i.e. admin / apple
- added header for Content-Type with value application/json, charset=utf-8
- turned of auto check response
- turned off validate SSL
Planning Analytics (TM1) Prerequisites
- Ensure the httpportnumber field has been set in the tm1s.cfg file (8010 for above example).
- Make sure TM1 Rest API was part of base installation.
- See https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_rest_api.2.0.0... for the official IBM doco on the TM1 Rest API.
Hope this helps someone in the future...
Rod