Discussion Board for collaboration on QlikView Scripting.
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?
Did you manage to extract data from TM1 Cube? How does it works. Can you share some sample application?
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.
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.....
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.