TM1p.xla issues n_connect

Post Reply
cipher
Posts: 13
Joined: Thu Jan 08, 2015 6:15 am
OLAP Product: TM1
Version: 9.5.2 10.2.2 64 Bit
Excel Version: 2010

TM1p.xla issues n_connect

Post by cipher »

Hi All,
I have a situation here, I am trying to call TM1p.xla file from VBA Macro, so that I can use "N_Connect" function to connect to TM1 Instances.

I am doing all of these on following System
User: Administrator
OS: Windows 2012 R2 Standard Edition 64 Bit
TM1: 10.2.2 FixPack 5 64Bit and 32 Bit Perspective.
Excel: 2007 with SP3.

Problem Statement:
I use following command in Workbook_Open() and my workbook is called from a VBS script which runs out of command prompt.

Private Sub Workbook_Open()
Application.Calculation = xlCalculationManual
Application.MultiThreadedCalculation.Enabled = True
Workbooks.Open ("C:\Program Files (x86)\ibm\cognos\tm1\bin\tm1p.xla")
msg = Application.Run("n_connect", "TM1InstanceName", "UID", "PWD")
End Sub

below error comes on line "application.run"
unnamed.png
unnamed.png (2.93 KiB) Viewed 1711 times
The problem is I am able to execute the same code on my laptop which runs on Windows XP Professional Edition and TM1 10.1
This also works on other System which runs on Windows 2008 R2 Edition running TM1 10.1.
But somehow, this doesnt work on our newBox which runs on Win2012R2 Std edition.

- I have added TM1p.xla into Add-Ins.
- I have also added TM1 Bin directory into Trusted Location in Excel Settings.
- My macro setting is "Enable all macros" with trust Access to VBA project object model.

I tried almost everything that I had to and still trying. From my analysis I feel that, somehow excel is blocking the functions of TM1p.xla due to some security reasons.
I have been experimenting all of these things with Administrator credentials.

If you guys could please take a look to this issue and provide any resolution to this then it will be grateful.

Thanks
Cipher!
Post Reply