COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => TM1 => Topic started by: andyhofer1 on 04 Jun 2015 09:51:15 AM

Title: Headers in dimensions
Post by: andyhofer1 on 04 Jun 2015 09:51:15 AM
I'm just starting moving from Cognos EP to Cognos TM1 Cloud, and I am using Performance Modeler.

One of the things that I did in EP is to have a Dlist with headers/titles. These were text formatted and Force to Zero and the cell contents were shown as blanks or empty cells. If I do the same in TM1 it places a 0 in the cell. Does anyone know how to get round this.

Also, how do you create blank rows in a cube. In EP you entered |||||| or as many as was needed to make it unique in the Dlist, format to text and Force to Zero, and this would create a blank row.

I know it does alter the calculation etc of the cube but it makes it nicer to look at and easier to use by the user.

Example Dlist below