Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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?

Tags (3)
4 Replies
satyadev_j
Valued Contributor

Re: Extract data from IBM TM1 Cube to Qlikview

Hi,

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

Thx

Satya

Not applicable

Re: Extract data from IBM TM1 Cube to Qlikview

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

Re: Extract data from IBM TM1 Cube to Qlikview

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
Valued Contributor

Re: Extract data from IBM TM1 Cube to Qlikview

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

Community Browser