Connect TM1 Perspectives(IntegratedSecurityMode 5) with CAMPassport in vba

Post Reply
kavitha2002
Community Contributor
Posts: 180
Joined: Sat May 05, 2018 11:48 am
OLAP Product: tm1
Version: 10.3.10100.8
Excel Version: 14

Connect TM1 Perspectives(IntegratedSecurityMode 5) with CAMPassport in vba

Post by kavitha2002 »

Hello Everyone,

I have tried to connect to TM1 Perspectives in IntegratedSecurityMode 5 with CAMPassport in excel vba automatically.

Previously with 'N_CONNECT_CAM' with n_connect_cam_bridge.dll worked well in excel 32 bit. In the current latest vesion of TM1 Pespective will support only 64 bit. Same dll is not supported in 64 bit. So I set the CAMPassport in vba and connect to TM1 Perspectives as a workaround.

The problem is its connected to TM1 Perspectives but ribbon is not activated.
Tm1-serverexplorer.png
Tm1-serverexplorer.png (11.19 KiB) Viewed 1517 times
Tm1-ribbon.png
Tm1-ribbon.png (18.11 KiB) Viewed 1517 times
Kindly provide your input on this.

Thanks
Post Reply