Troubleshooting
Problem
Editing few cells in custom report (leaf level) is causing high CPU spikes ( close to 100% usage) then Excel will not be usable and system will be slow. No major threads will show up in Planning Analytics Server side. The Excel process is what seems to be taking most of the CPU percentage on the user machine.
Symptom
High CPU spikes and overall system is slow.
Cause
The cube view in question has the following naming structure: "[Dimension_Name].[Hierarchy_Name].[Element [Name]]"
The CPU usage is caused by attempting to evaluate the regex for the above "[Hierarchy_Name].[Element[Name]]".
The "[Element[Name]]" containing brackets is the problem.
Resolving The Problem
The "[Element[Name]]" containing brackets is the problem. It is recommended not to use brackets in the names of dimensions/hierarchies/elements. This causes problems in this case, and would possibly cause problems in other cases. Here, we see a hanging thread caused by trying to evaluate a regular expression for "[Element[Name]]". The user would likely have a better experience and would probably avoid more potential issues down the line if they used non-bracket characters for their names (ie "[Element(Name)]" would not be hanging).
Document Location
Worldwide
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSD29G","label":"IBM Planning Analytics"},"Component":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
29 January 2020
UID
ibm11284892