Just looking round for anecdotal information on Qlik / TM1 integration. Will be having a look to evaluate this in the near future so would be interested in any live implementation experiences prior to my own investigatons.
As such, can anyone with real world implementation of Qlik talking to TM1 for web dashboarding purposes share their experiences?
TIA
Any experiences with Qlik integration?
-
garry cook
- Community Contributor
- Posts: 209
- Joined: Thu May 22, 2008 7:45 am
- OLAP Product: TM1
- Version: Various
- Excel Version: Various
Re: Any experiences with Qlik integration?
We have done some solutions which integrate the two products in several ways. Your needs will dictate what direction you want to take.
Initially, we had to create data extract scripts that would be loaded overnight into publisher server and then distributed to the users. This was OK, but it required a lot of TI script writing and tweaking because we needed to know in advance what the users wanted and the security had to be applied using data reduction, etc. (which got a bit dicey with payroll data). Some of the aggregate functions were a bit of a pain as well because we had to duplicate them in QlikView.
For some customers, this was fine, but for others they wanted a way to directly connect up to QlikView and get up-to-date information without having to go through the nightly processing. They also wanted to push as much of the calculations onto TM1 rather than re-doing them in QlikView. To accomplish this, we built a connector called TM1Connect (http://www.carpedatuminc.com/products/tm1connect/) that provides this capability (I work for CarpeDatum). However, because they wanted the user to be in control of the data that is being pulled in from TM1, care had to be taken to ensure that they were not pulling in the entire cube. So you have to create selection list boxes that when you pick an item, it re-issues a partial reload and parameterizes the query to TM1. This allows you to pull Q1 numbers without having to load Jan, Feb, Mar data. This, however, required that the users work with the desktop version of QlikView rather than the web version, because reloads cannot be done in publisher very easily with multiple users. It locks up the entire document while it is being re-loaded.
So, first decide whether or not you want to work in a nightly batch processing mode or an on-demand mode. If batch works ok, you can either write TI scripts to export the data you think your users will need, or use TM1Connect to create QVX files on a scheduled basis. These can then be loaded into publisher and distributed as QVD files.
If you want on-demand use, or you want the users to pull for themselves the data they want to see, then the only solution that I am aware of at this time is TM1Connect. But, know that they will have to use the QlikView Desktop version.
Initially, we had to create data extract scripts that would be loaded overnight into publisher server and then distributed to the users. This was OK, but it required a lot of TI script writing and tweaking because we needed to know in advance what the users wanted and the security had to be applied using data reduction, etc. (which got a bit dicey with payroll data). Some of the aggregate functions were a bit of a pain as well because we had to duplicate them in QlikView.
For some customers, this was fine, but for others they wanted a way to directly connect up to QlikView and get up-to-date information without having to go through the nightly processing. They also wanted to push as much of the calculations onto TM1 rather than re-doing them in QlikView. To accomplish this, we built a connector called TM1Connect (http://www.carpedatuminc.com/products/tm1connect/) that provides this capability (I work for CarpeDatum). However, because they wanted the user to be in control of the data that is being pulled in from TM1, care had to be taken to ensure that they were not pulling in the entire cube. So you have to create selection list boxes that when you pick an item, it re-issues a partial reload and parameterizes the query to TM1. This allows you to pull Q1 numbers without having to load Jan, Feb, Mar data. This, however, required that the users work with the desktop version of QlikView rather than the web version, because reloads cannot be done in publisher very easily with multiple users. It locks up the entire document while it is being re-loaded.
So, first decide whether or not you want to work in a nightly batch processing mode or an on-demand mode. If batch works ok, you can either write TI scripts to export the data you think your users will need, or use TM1Connect to create QVX files on a scheduled basis. These can then be loaded into publisher and distributed as QVD files.
If you want on-demand use, or you want the users to pull for themselves the data they want to see, then the only solution that I am aware of at this time is TM1Connect. But, know that they will have to use the QlikView Desktop version.
-
wang_chris
- Posts: 122
- Joined: Thu Jan 31, 2013 1:03 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2007
Re: Any experiences with Qlik integration?
Anyone has some idea whether Qlik or Tableau will provide a connector to TM1? I found Tableau has connector to Hyperion Essbase.
Re: Any experiences with Qlik integration?
Both QlikTech and Tableau have come to us (CarpeDatum) to create connectors to TM1 for them. I don't think they have anything in their development plans to support them at this time. You can check with their sales or product engineering teams and you will probably get routed to TM1Connect.
I can probably put you in touch with people at either/both companies if you want to speak with them directly.
I can probably put you in touch with people at either/both companies if you want to speak with them directly.