This feels like a hack but traditionally we have always edited c:\windows\system32\drivers\etc\hosts on the TM1 server and added an alias on the loopback address i.e.
# localhost name resolution is handled within DNS itself.
# 127.0.0.1 localhost
# ::1 localhost
127.0.0.1 localhost TM1Server
May work for you as a temporary fix.
Would be interested to hear what others have done besides self-signed certs.
------------------------------
George Tonkin
Business Partner
MCI Consultants
Johannesburg
------------------------------
Original Message:
Sent: Mon February 26, 2024 04:20 AM
From: Willem Noble Stibolt
Subject: I receive a security alert when using TM1 REST API from a VBA-function in Excel
Hi!
I have created a VBA-project in Excel that interact with PA using the TM1 REST API.
It works fine, except that I receive this security alert when I run the first GET-request:
and when I click 'Yes', The data is retrieves and all following requests work fine.
I have tried to install the certificate, but the message comes back regardless.
Does anyone have any ideas how I can make this alert go away?
Regards,
Willem
------------------------------
Willem Noble Stibolt
------------------------------