IBM Support

TM1 API Using Excel to open a worksheet with included VBA API gives a Systemservercamsecurity required error

Question & Answer


Question

What is the reason for this error ?

Cause

A IBM Cognos Server secured with CAM Authentication and using a TM1 Server with the same, can no longer use VBA code for TM1 in the Excel Spreadsheet, without having made a connection to the TM1 Server via Perspectives and the IBM Cognos server at the same time.

Answer

The main reason for this is that the TM1 Perspectives API is a Add-In for Excel , and its internal code does not have the methods , nor can make a CAM Connection to the IBM Cognos Server.

An Enhancement Request has been put forward to change the VBA API in Perspectives so that any CAM connection can be made.

[{"Product":{"code":"SS9RXT","label":"Cognos TM1"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"TM1 API","Platform":[{"code":"PF033","label":"Windows"}],"Version":"9.5.2;9.5.1;9.5;9.4 MR1;9.4;9.3;9.2;9.1;9.0;10.1.0;10.1.1;10.2","Edition":"Edition Independent","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
24 February 2020

UID

swg21644577