Troubleshooting
Problem
Setting ENABLE_USER_IMPORT parameter to "false" in /config/paw.ps1 does not prevent new users to connect to Planning Analytics Workspace through Planning Analytics for Excel.
Cause
Planning Analytics for Excel connects to Workspace anonymously.
Workspace just acts as a proxy that allows Planning Analytics for Excel to reach the TM1 Servers; the user does not really connect into Workspace, and no new user account is created.
Resolving The Problem
If there is a need to prevent new users to connect to TM1 Servers through Planning Analytics for Excel when ENABLE_USER_IMPORT is disabled, then we have to set an additional parameter in /config/paw.ps1:
$env:ENABLE_VIEW_EXCHANGE="true"
This parameter enables Exploration View exchanges between Planning Analytics Workspace and Planning Analytics for Microsoft Excel in the Content Store. Thereby, this forces users to be signed and no anonymous connections to Workspace are allowed anymore.
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSD29G","label":"IBM Planning Analytics"},"ARM Category":[{"code":"a8m50000000KzL5AAK","label":"Planning Analytics Workspace->Administration"},{"code":"a8m50000000KzJ4AAK","label":"Planning Analytics for Microsoft Excel"},{"code":"a8m50000000KzIkAAK","label":"Security"},{"code":"a8m0z000000blfjAAA","label":"Troubleshooting"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
27 September 2021
UID
ibm16493001