Planning Analytics Perspectives Issue

Post Reply
CathyBoots
Posts: 19
Joined: Wed Aug 10, 2016 1:20 pm
OLAP Product: Tm1
Version: 10.2.2
Excel Version: Prof Plus 2013

Planning Analytics Perspectives Issue

Post by CathyBoots »

Hi everyone

I've installed the new Planning Analytics on Prem and now I'm having an issue starting Perspectives.

Everytime I try to start it, I get the message
Missing Library: C:\Program Files\ibm\cognos\tm1_64\bin\gsk8ssl.dll
C:\Program Files\ibm\cognos\tm1_64\bin\gsk8km.dll
Has anyone encounter this before or know how to resolve it please?
The files do exist within the directory specified.
I'm using Excel 2013 v15.0.4885.1001 (32bit)

Thank you
User avatar
Alan Kirk
Site Admin
Posts: 6606
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Planning Analytics Perspectives Issue

Post by Alan Kirk »

CathyBoots wrote:Hi everyone

I've installed the new Planning Analytics on Prem and now I'm having an issue starting Perspectives.

Everytime I try to start it, I get the message
Missing Library: C:\Program Files\ibm\cognos\tm1_64\bin\gsk8ssl.dll
C:\Program Files\ibm\cognos\tm1_64\bin\gsk8km.dll
Has anyone encounter this before or know how to resolve it please?
The files do exist within the directory specified.
I'm using Excel 2013 v15.0.4885.1001 (32bit)
I haven't installed it yet so I haven't seen the install paths but from that path it looks like you may be using the 64 bit add-in that came out for 64 bit Excel some time in 10.2.2. If you have 32 bit Excel you still need to use the 32 bit add-in. Is there another bin folder (one on a path that does not have _64 in it) containing a tm1p.xla add-in? If so, try that one instead.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
CathyBoots
Posts: 19
Joined: Wed Aug 10, 2016 1:20 pm
OLAP Product: Tm1
Version: 10.2.2
Excel Version: Prof Plus 2013

Re: Planning Analytics Perspectives Issue

Post by CathyBoots »

I tried both the one that sits in \bin and the one in \bin_64, but they give the same message.
tomok
MVP
Posts: 2831
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Planning Analytics Perspectives Issue

Post by tomok »

The key question is which version of Perspectives did you install, the 32 or 64-bit? If you installed the 64-bit version and you have 32-bit Excel then it isn't going to work. Uninstall the client and install the 32-bit version.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
CathyBoots
Posts: 19
Joined: Wed Aug 10, 2016 1:20 pm
OLAP Product: Tm1
Version: 10.2.2
Excel Version: Prof Plus 2013

Re: Planning Analytics Perspectives Issue

Post by CathyBoots »

I did that, but still no luck.
WouterM
Posts: 6
Joined: Mon Aug 30, 2010 9:44 am
OLAP Product: IBM Cognos TM1
Version: 10.2.2
Excel Version: 2013
Location: Romania

Re: Planning Analytics Perspectives Issue

Post by WouterM »

Same issue here. Running 32-bit client on 32-bit Excel on Windows 7 64b. The files gsk8ssl.dll and gsk8km.dll do exist.

Update (without success):
* Fiddling with the windows PATH didn't change anything.
* Uninstall/re-install didn't change anything (no errors in install log)
* gsk8ver runs and lists gsk8ssl.dll and gsk8km.dll
!TM1Rules
Posts: 11
Joined: Thu Dec 06, 2012 3:51 am
OLAP Product: TM1\Cognos Express
Version: All
Excel Version: 2013 + 2016
Location: Sydney, Australia

Re: Planning Analytics Perspectives Issue

Post by !TM1Rules »

Anyone got any updates on this issue? I don't think it is a 32-bit vs 64-bit issue, as Perspectives was working until after I installed PAX. Once PAX installed, even disabling the new add-ins didn't fix the issue. Does anyone know a method of forcing Excel to open without third party add-ins (other than safe mode)?
dumbom
Posts: 16
Joined: Thu Jun 27, 2013 9:07 am
OLAP Product: TM1
Version: CX 10.1 and TM1 10.0
Excel Version: 2007 and 2010
Location: South Africa

Re: Planning Analytics Perspectives Issue

Post by dumbom »

We have had the same issue. We resolved this by uninstalling the package connector (then restarting the machine)

there is a known issue with perspectives 2.0 installed alongside package connector
CathyBoots
Posts: 19
Joined: Wed Aug 10, 2016 1:20 pm
OLAP Product: Tm1
Version: 10.2.2
Excel Version: Prof Plus 2013

Re: Planning Analytics Perspectives Issue

Post by CathyBoots »

!TM1Rules wrote: Tue Jan 10, 2017 4:53 am Anyone got any updates on this issue? I don't think it is a 32-bit vs 64-bit issue, as Perspectives was working until after I installed PAX. Once PAX installed, even disabling the new add-ins didn't fix the issue. Does anyone know a method of forcing Excel to open without third party add-ins (other than safe mode)?
We did the package uninstall and that worked for getting perspectives to work. Thank you guys for your help :)

There is a known issue with PAX and perspectives though, you can't use perspectives if PAX is installed. I'd uninstall PAX if you are wanting to use Perspectives.
User avatar
Steve Rowe
Site Admin
Posts: 2410
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: Planning Analytics Perspectives Issue

Post by Steve Rowe »

Pretty sure that they both can't be loaded in Excel at once but you don't have to uninstall PAx

It works for a while but for example if you try and slice from a perspectives cube viewer with PAx loaded but not connected then the slice fails.

From our experience perspectives works fine if you don't have PAx loaded in Excel but you don't have to uninstall it. You can remove PAx from Excel through the add-ins menu.

This means that you can switch between clients as required.
Technical Director
www.infocat.co.uk
User avatar
Mumsy
Posts: 1
Joined: Tue Jul 10, 2018 3:23 pm
OLAP Product: IBM Cognos TM1
Version: 10.2.2 FP4
Excel Version: 2016

Re: Planning Analytics Perspectives Issue

Post by Mumsy »

If you are using MS Excel 32-bit so you may try to copy all gsk8*.dll files from the Planning Analytics install \bin directory to the Package Connector \bin directory.
Post Reply