IBM Support

TM1PRIMARYDBNAME() does not return a value in IBM Planning Analytics for Excel

Troubleshooting


Problem

The function TM1PRIMARYDBNAME() returns #‌NAME when used in a workbook

Symptom

Cell value for TM1PRIMARYDBNAME() displays #‌NAME

Cause

User has IBM Cognos Perspectives and IBM Planning Analytics for Excel installed. This can cause issues with the add-ins.

Resolving The Problem

Uninstall IBM Cognos Perspectives to resolve the issue. 

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":"a8m50000000KzLAAA0","label":"Planning Analytics for Microsoft Excel->Installation and Configuration"}],"ARM Case Number":"TS006201248","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]

Document Information

Modified date:
15 July 2021

UID

ibm16472899