IBM Support

Dynamic report works in IBM Planning Analytics for Excel but returns no data when published to IBM TM1Web

Troubleshooting


Problem

A dynamic report, that returns data in Planning Analytics for Excel, does not return any data in TM1Web

Symptom

TM1RptRow is returning no data (blank rows) in TM1Web. The same report returns data in Planning Analytics for Excel

Cause

The cause of the issue is an invalid space in one of the dimension names. The model has a dimension called "MyDimension" but is being referenced as "My Dimension" (with a space) in the TM1RptView formula. 

Resolving The Problem

To resolve the issue, the space in the dimension name in the TM1RptView was removed. 

Document Location

Worldwide

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSD29G","label":"IBM Planning Analytics"},"ARM Category":[{"code":"a8m0z000000GoRcAAK","label":"Troubleshooting->Planning Analytics For Excel"}],"ARM Case Number":"TS003549166","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
02 April 2020

UID

ibm16151725