Help!!!!

Post Reply
Whorty1970
Posts: 6
Joined: Tue Nov 22, 2011 11:39 am
OLAP Product: Cognos BI
Version: 8.4
Excel Version: 2010

Help!!!!

Post by Whorty1970 »

Hi All,

could do with some advice please :)

Finance in my company need a planning tool and CX seems a good fit. IT however already use Qlikview for some of their reporting so are tryingto insist that we use it rather than CX. Problem is, IT see 'Cognos' as only BI but obviously CX has the TM1 planning element.

Anyway, I need to demo a simple planning model for IT to show them what Finance need and try to explain why Qlikview can't do the same. Any ideas? I've downloaded the CX trial off the IBM site but I only have a laptop which is a 32 bit system and the trial won't install.

I could try a Cog reseller (I'm in London) but tried one already but after 3 chases they just don't seem interested.

Any help or advice??

Cheers.
User avatar
jim wood
Site Admin
Posts: 3961
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: Help!!!!

Post by jim wood »

If you look in the commercial section there a some good companies in London that could help you.
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
User avatar
stephen waters
MVP
Posts: 324
Joined: Mon Jun 30, 2008 12:59 pm
OLAP Product: TM1
Version: 10_2_2
Excel Version: Excel 2010

Re: Help!!!!

Post by stephen waters »

Whorty1970 wrote: I could try a Cog reseller (I'm in London) but tried one already but after 3 chases they just don't seem interested.
Any help or advice??
Whorty,
Many "Cognos" reseller partners do not fully understand TM1 and even fewer have in-depth TM1 expertise to demonstrate and implement it. However, there are some companies from the former Applix partner community around who have made the transition to being IBM Cognos partners. They will generally have many years experience of TM1 and are much more likely to be able to help you.

We are one such company (though not the only one in london) and i will contact you via the forum mail to see if we can help.

You raised a couple of more technical questions in your post:
First, although the live licensed version of CX is 64 bit, the evaluation version is 32 bit so should theoretically run on your laptop. However installing CX can be a real nightmare compared to TM1 if you are not used to it. Have you had any experience with TM1 or Cognos tools before?

Qlikview as a front-end is a great tool for end user transactional reporting, but, my understanfiding is it depends on the data being in a reasonably well structured relational warehouse. It is definitley not a planning tool. If you could compare setting up and running a simple, driver based budget model in TM1\CX with doing the same in Qlikview I think it would make this obvious.
lotsaram
MVP
Posts: 3704
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Help!!!!

Post by lotsaram »

Whorty1970 wrote:Anyway, I need to demo a simple planning model for IT to show them what Finance need and try to explain why Qlikview can't do the same. Any ideas? I've downloaded the CX trial off the IBM site but I only have a laptop which is a 32 bit system and the trial won't install.
Beyond looking up a TM1 and CX competent reseller in London I would recommend you get them to do the demo to finance. It's their bread and butter and they should know their stuff and be finance literate and have a demo many times better then what you will pull off IBM's website.
winsonlee
Regular Participant
Posts: 180
Joined: Thu Jul 01, 2010 3:06 am
OLAP Product: Cognos Express
Version: 9.5
Excel Version: 2007
Location: Melbourne, Australia

Re: Help!!!!

Post by winsonlee »

http://www-304.ibm.com/partnerworld/wps ... search.jsp

You can try looking for cognos reseller through the above url. You definitely able to install the CX 9.5 evaluation on 32bit machine. There are some prerequisite software you need to install to get it working eg .NET Framework 3.5 and also IIS.
blackhawk
Community Contributor
Posts: 136
Joined: Thu May 29, 2008 2:29 pm

Re: Help!!!!

Post by blackhawk »

QlikView is not a planning tool, and although it can do calculations and create interactive dashboards, it is not a replacement for budgeting and planning. For example, you cannot perform interactive modeling, forecasting and budget collection that you can with TM1.

QlikView, although it has a few gagues and input tables for controlling variables, it is not designed to do the modeling and highly complex calculations that TM1 does naturally. QlikView also does not handle dynamic aggregation of data or dynamic restructuring of hierarchical relationships.

For these reasons, we have a number of customers that are using both QlikView and TM1 at the same time (in fact they are integrated) and they play very complimentary roles.

So if your needs are for planning, QlikView should not be part of any discussion other than the reporting aspect.

Perhaps communicating this to your IT team will help you.
User avatar
jim wood
Site Admin
Posts: 3961
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: Help!!!!

Post by jim wood »

Haven't Gartner done a review of Qlikview? Documentation like that goes a long way with most IT departments.
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Whorty1970
Posts: 6
Joined: Tue Nov 22, 2011 11:39 am
OLAP Product: Cognos BI
Version: 8.4
Excel Version: 2010

Re: Help!!!!

Post by Whorty1970 »

Hi All

thanks for the info. I have a call today with a consultancy who can help and hopefully move us forward with our IT friends :)

I'm almost there installing CX on my laptop (IIS is playing up so still need to sort out) so I should be able to build a simple demo. And if the consultancy pre-sales have a demo that will be great too.

As for Qlikview, I know it can't do the job but I'm in that position where IT won't even think about Cognos (even though it's the planning side) unless I can show them something tangible. We should be able to educate them though over the next few weeks!

Thanks again. Whorty
Post Reply