Planning Analytics Perspectives Issue

Post Reply
CathyBoots
Posts: 18
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 » Mon Dec 19, 2016 8:11 am

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: 5833
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: 9.5.2 64 bit moving to 10.2.2
Excel Version: 2010
Location: Sydney, Australia
Contact:

Re: Planning Analytics Perspectives Issue

Post by Alan Kirk » Mon Dec 19, 2016 8:19 am

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: 18
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 » Mon Dec 19, 2016 8:39 am

I tried both the one that sits in \bin and the one in \bin_64, but they give the same message.

User avatar
tomok
MVP
Posts: 2491
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 » Mon Dec 19, 2016 2:01 pm

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: 18
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 » Tue Dec 20, 2016 7:53 am

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 » Wed Dec 21, 2016 10:52 am

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: 10
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 » 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)?

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 » Fri Nov 03, 2017 9:40 am

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: 18
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 » Fri Nov 03, 2017 10:38 am

!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: 1817
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 10.2.2., PAW
Excel Version: Nearly all of them

Re: Planning Analytics Perspectives Issue

Post by Steve Rowe » Fri Nov 03, 2017 1:06 pm

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.

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 » Wed Jul 11, 2018 6:44 am

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