Connecting to TM1 using Qlikview

[slique-cya]

So here is the situation. We have a client that has Qlikview and TM1. They need to do high level CPM reports on Qlikvi with data sitting in TM1. Issue is Qlikview is on one server and TM1 is on another server. We have managed to establish a connection between the application (from Qlikview to TM1) in an instance where both are on the same machine. The issue arises where we now have to connect to TM1 in Server A from Qlikview in a local machine. It just hangs at best, but mostly doesn't do anything. The client is using TM1 9.5.2 with IntegratedSecurityMode 5 on the .cfg, we are testing this with Qlikview 11 Personal Edition.

Some guidance would be appriciated in regard, but please note my knowledge is limited to TM1.

Siya

[David Usherwood]

Would help if you set out how you are connecting Qlikview to TM1 - I'm not aware that this is supported (by IBM).

[PlanningDev]

The connection is likely through ODBO. Microstrategy claims TM1 integration but in reality its just passing MDX calls through the ODBO connection.