Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Extract data from IBM TM1 Cube to Qlikview

I have installed the TM1 OLE DB driver and successfully connect to the data source in Qlikview, but now here I am wondering what to do next. How do i extract the data?

4 Replies
satyadev_j
Specialist
Specialist

Hi,

Did you manage to extract data from TM1 Cube? How does it works. Can you share some sample application?

Thx

Satya

Not applicable
Author

Solved it by creating a process in TM1 to extract the data to a flat file, then picked up the flat file in qlickview. Not the best way but it works if u dont need to have real time data.

/Andreas Torsson

Not applicable
Author

I think the only other way is to create a MDX query to interrogate the TM1 cubes but it's not really simple (need to know both the MDX syntax and the cube model).

The other problem is that the TM1 cube would store not only the detailled data but also the agregated one.

In qlikview, you would prefer to query only the detailed data to make you own agregation.

You should then query only the detailed data.....

satyadev_j
Specialist
Specialist

Hi,

Explore TM1 Conector. Link: http://market.qlik.com/tm1qonnect.html

I have tested with the trial license provided by CarpeDatum and its working fine for me.

Thx

Satya