Product:

Cognos TM1 10.1.1 Perspective

PLANANALYTICS_Update_version=PLANANALYTICS-AW64-ML-RTM-10.1.7101.108-0

Windows 2008 R2 server

Microsoft Office 2010 32 bit  version 14.0.6023.1000

Symptom:

When you start TM1 perspective on a new computer you get a error message, and can not load TM1 perspective into Microsoft Excel 2010.

Error Message:

Could not load an object because it is not available on this machine.

Compile error in hidden module: MenuFuncs.

This error commonly occurs when code is incompatible with the version, platform, or architecture of this application. Click “Help” for information on how to correct this error.

 

Cause:

http://support.microsoft.com/kb/2597986

 

Solution:

Find the correct MSCOMCTL.OCX file from a different computer, where TM1 perspective is working with Microsoft Excel 2010.

 

Correct version is dated 2012-06-06 8:49 AM and 1046 KB in size.

File version 6.1.98.34

Product version 6.01.9834

 

On the computer where you have the problem.

Exit Excel

Go to folder %systemroot%\sysWOW64

Rename file mscomctl.ocx to mscomctl.ocx.old.txt

Copy the correct mscomctl.ocx fil to folder c:\windows\syswow64

Start a cmd prompt with “run as administrator”

Enter cd %systemroot%

Enter cd syswow64

Enter regsvr32 /u mscomctl.ocx

Click OK on dialog

Enter regsvr32  mscomctl.ocx

Click OK on dialog

 

Start Tm1 Perspective again and test.