OLAPOBJECTS 5.0 and TM1API.DLL
-
- 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
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
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
- 10-4-2012 4-47-26 AM.jpg (15.11 KiB) Viewed 6951 times
-
- 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
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?
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?
-
- 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
Yes we have to specify the path to install.
Thanks
kkmk
Thanks
kkmk
- Attachments
-
- 1.JPG (48.12 KiB) Viewed 6945 times
-
- 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
... 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.
-
- 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
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
C:\Program Files\ibm\cognos\tm1_64\bin64 as i am using a 64 bit application.
Thanks
KKMK
- 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
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
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!
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!
-
- 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
thanks Mike.
I am installing as per your instruction. Keep you posted.
Thanks
kkmk
I am installing as per your instruction. Keep you posted.
Thanks
kkmk
- 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
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.
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
-
- 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
Thank you for all your support. I have installed and configured OLAP Objects and the system is up and running.
Thanks
kkmk
Thanks
kkmk
-
- 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
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
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
- 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
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
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!
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!