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"}}]
Was this topic helpful?
Document Information
Modified date:
24 February 2020
UID
swg21644577