Troubleshooting
Problem
Unable to export specific dynamic report as a snapshot to excel, slice to excel or PDF. This was tried in tm1 web and Planning Analytics Workspace. The report was published using Planning Analytics for Excel.
Symptom
Once you click on Export, nothing will happen in Planning Analytics workspace however in tm1 web you will see "Exporting 1 of 2, cancel export" message. Then nothing happens until you click cancel.
Cause
TM1RptRow Formula is missing arguments (ie not complete).
Resolving The Problem
After investigating the tm1 formulas in the report, we noticed that the TM1RptRow was missing some parameters(arguments). Hence, it was not a complete formula and was causing the report not to export. The Tm1RptRow formula in question had the syntax similar to:
TM1RPTROW(ReportView Cell reference,"Server:Dimension",Subset")
So we modified it to become:
TM1RPTROW(ReportView Cell reference,"Server:Dimension",Subset",,,,,,)
Then the report was able to export successfully in tm1 web and PAw. Below is a short definition of the TM1RptRow:
It sets the Active Form control row definition. The control row definition governs the behavior of all rows in the Active Form.
Proper Syntax:
TM1RptRow(ReportView, Dimension, Subset, SubsetElements,Alias, ExpandAbove,MDXStatement, Indentations, ConsolidationDrilling)
TM1RptRow(ReportView, Dimension, Subset, SubsetElements,Alias, ExpandAbove,MDXStatement, Indentations, ConsolidationDrilling)
Document Location
Worldwide
[{"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":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"}]
Was this topic helpful?
Document Information
Modified date:
20 September 2021
UID
ibm16397788