OLAPOBJECTS 5.0 and TM1API.DLL

Post Reply
kkmk
Posts: 71
Joined: Wed Jan 25, 2012 9:08 am
OLAP Product: IBM Cognos TM1
Version: 10.2
Excel Version: 2013

OLAPOBJECTS 5.0 and TM1API.DLL

Post by kkmk »

Hi,

I have installed OLAPObjects 5.0 in TM1 web and after the installation when i start access the web, i am getting error - File Not Found : TM1API.dll.

I tried registering this dll using REGSVR32. But still it throws error (please find attached screen shot).

Please help me to resolve this. Thanks in advance.

Thanks
KKMK
Attachments
Eror File
Eror File
10-4-2012 4-47-26 AM.jpg (15.11 KiB) Viewed 6951 times
Duncan P
MVP
Posts: 600
Joined: Wed Aug 17, 2011 1:19 pm
OLAP Product: TM1
Version: 9.5.2 10.1 10.2
Excel Version: 2003 2007
Location: York, UK

Re: OLAPOBJECTS 5.0 and TM1API.DLL

Post by Duncan P »

Not all DLLs are COM libraries.

If a DLL is a COM library it will contain a function DllRegisterServer which RegSvr32 can call to make it put information about what objects it supports and how to instantiate them, along with the DLL's location, into the system registry.

Most DLLs are not like this however. They simply export a set of functions which are available to calling functions once they are loaded. The client will call LoadLibrary to load it. This takes a file name or a path name. If it is not a fully qualified path then LoadLibrary searches for it as documented here http://msdn.microsoft.com/en-us/library ... s.85).aspx.

TM1API.DLL is the second kind (which is why RegSvr32 gives you that error) but it is obviously not on the path or in the current working directory of the program that is trying to load it.

You need to find what is trying to load it and put it where that can find it. Are there specific instructions in the documentation of OLAP Objects about where it needs to be installed relative to the TM1 installation?
kkmk
Posts: 71
Joined: Wed Jan 25, 2012 9:08 am
OLAP Product: IBM Cognos TM1
Version: 10.2
Excel Version: 2013

Re: OLAPOBJECTS 5.0 and TM1API.DLL

Post by kkmk »

Yes we have to specify the path to install.

Thanks
kkmk
Attachments
1.JPG
1.JPG (48.12 KiB) Viewed 6945 times
Duncan P
MVP
Posts: 600
Joined: Wed Aug 17, 2011 1:19 pm
OLAP Product: TM1
Version: 9.5.2 10.1 10.2
Excel Version: 2003 2007
Location: York, UK

Re: OLAPOBJECTS 5.0 and TM1API.DLL

Post by Duncan P »

... and is the TM1API.DLL in the location that you specified? If you are using 9.5 it almost certainly won't be in the path shown in the picture.
kkmk
Posts: 71
Joined: Wed Jan 25, 2012 9:08 am
OLAP Product: IBM Cognos TM1
Version: 10.2
Excel Version: 2013

Re: OLAPOBJECTS 5.0 and TM1API.DLL

Post by kkmk »

I am using TM1 10.1.1. and the path i have chosen for TM1API is

C:\Program Files\ibm\cognos\tm1_64\bin64 as i am using a 64 bit application.

Thanks
KKMK
User avatar
Mike Cowie
Site Admin
Posts: 482
Joined: Sun May 11, 2008 7:07 pm
OLAP Product: IBM TM1/PA, SSAS, and more
Version: Anything thru 11.x
Excel Version: 2003 - Office 365
Location: Alabama, USA
Contact:

Re: OLAPOBJECTS 5.0 and TM1API.DLL

Post by Mike Cowie »

Hi:

The current version of OLAPObjects is a 32-bit application and, thus, it needs a 32-bit version of TM1 API files. The easiest way to get that is to install a 32-bit TM1 client (like Architect) and to make sure the installed BIN folder is reflected in the system PATH variable, which is what the installer is ultimately doing.

If you have any questions, please don't hesitate to let me know. I'll send you a PM as well.

Regards,
MIke
Mike Cowie
QueBIT Consulting, LLC

Are you lost without Print Reports in Planning Analytics for Excel (PAfE)? Get it back today, for free, with Print Reports for IBM Planning Analytics for Excel!
kkmk
Posts: 71
Joined: Wed Jan 25, 2012 9:08 am
OLAP Product: IBM Cognos TM1
Version: 10.2
Excel Version: 2013

Re: OLAPOBJECTS 5.0 and TM1API.DLL

Post by kkmk »

thanks Mike.

I am installing as per your instruction. Keep you posted.

Thanks
kkmk
User avatar
Harvey
Community Contributor
Posts: 236
Joined: Mon Aug 04, 2008 4:43 am
OLAP Product: PA, TM1, CX, Palo
Version: TM1 8.3 onwards
Excel Version: 2003 onwards
Contact:

Re: OLAPOBJECTS 5.0 and TM1API.DLL

Post by Harvey »

Actually, I believe TM1 10 installs both 32-bit and 64-bit versions of the API (at least it did for me, with the options I selected).

There should be both a "bin64" and a "bin" folder underneath the program path.

I'm not sure how you tell OLAPObjects which one to pick, but there is likely a registry key or config file to do the job.
Take your TM1 experience to the next level - TM1Innovators.net
kkmk
Posts: 71
Joined: Wed Jan 25, 2012 9:08 am
OLAP Product: IBM Cognos TM1
Version: 10.2
Excel Version: 2013

Re: OLAPOBJECTS 5.0 and TM1API.DLL

Post by kkmk »

Thank you for all your support. I have installed and configured OLAP Objects and the system is up and running.

Thanks
kkmk
BPalacios
Posts: 1
Joined: Thu Sep 23, 2010 11:47 pm
OLAP Product: OLAB Objects
Version: 5.1
Excel Version: 2007

Re: OLAPOBJECTS 5.0 and TM1API.DLL

Post by BPalacios »

Hello all,
I have and issue with a custom .Net web app I built. I'm using OLAP Objects to connect to TM1. The issue I have is that when I set the Admin Server in my TM1 DataSpace object, it doesn't find any TM1 servers. I have 2 TM1 servers up and running, but it doesn't find them. Any advice?


Ben Palacios
User avatar
Mike Cowie
Site Admin
Posts: 482
Joined: Sun May 11, 2008 7:07 pm
OLAP Product: IBM TM1/PA, SSAS, and more
Version: Anything thru 11.x
Excel Version: 2003 - Office 365
Location: Alabama, USA
Contact:

Re: OLAPOBJECTS 5.0 and TM1API.DLL

Post by Mike Cowie »

Hi Ben:

We'll contact you offline to assist further - it could be things like licensing, TM1 SSL settings or something similar preventing TM1 Servers from being seen via OLAPObjects and the TM1 API.

Regards,
Mike
Mike Cowie
QueBIT Consulting, LLC

Are you lost without Print Reports in Planning Analytics for Excel (PAfE)? Get it back today, for free, with Print Reports for IBM Planning Analytics for Excel!
Post Reply