Troubleshooting
Problem
In Planning Analytics for Excel, once the TM1User() function is executed through some VBA macro, the performance degrades: the next Refresh Sheet or Rebuild Sheet or Rebuild Book is slow.
The time taken can goes from several seconds to several minutes.
Resolving The Problem
In the Excel VBA macro, add a "Application.Calculate" call after the "Run".
Example:
Dim User As String
User = Application.Run("TM1USER", "SData")
Application.Calculate
Using this method, Planning Analytics for Excel detects that the formulas are already executed and returns to a clean state.
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":"SSCTEW","label":"IBM Planning Analytics Local"},"ARM Category":[{"code":"a8m50000000KzKhAAK","label":"Planning Analytics for Microsoft Excel-\u003EReporting"},{"code":"a8m0z000000blfjAAA","label":"Troubleshooting"}],"ARM Case Number":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
12 January 2022
UID
ibm16540238