Hi Vkish,
Sorry for the late reply, not sure if you're still grappling with this problem. If you still have difficulties connecting IBM PA/TM1 cubes to Qlik, you might want to give TMVGate a try.
TMVGate was specifically built to allow users to connect their data in Planning Analytics/TM1 to industry leading BI tools like Qlik Sense.
It has a lightweight server based architecture and does not require any software or driver on the client workstation, making it ideal for widespread deployment.
TMVGate returns Cube view (private or public) and Dimension Hierarchies data in real time streaming in either the JSON, XML, HTML or CSV (TXT or Pipe) format via a simple HTTP or HTTPS call.
The various data streaming formats have been validated with the visualization tools mentioned, without the need for any additional scripting.
You can watch the demo videos on our Youtube channel here:
https://www.youtube.com/channel/UC95AcZmT7jByvMfWDCIWbWw
Please send us an email if you'd like a free TMVGate trial we'll get back to you in as soon as possible. Most of our clients don't even require half of the free trial time to get their required results.
Email: info@itlink.com.sg or visit our website at https://www.itlinkbizs.
