Supress Blank String Cell

Post Reply
AuctionTM1
Posts: 3
Joined: Wed Mar 02, 2011 10:09 pm
OLAP Product: TM1
Version: 9.4.1
Excel Version: 2007

Supress Blank String Cell

Post by AuctionTM1 »

I have a cube view in which a dimension contains both number and string data types which are being fed from another cube (feedstrings is used). Thiw view is dependant upon the current date; if the month of the data (Jan) is less than the current month (Mar), then the values don't pull from the origination cube and displays blank cells. With the blank cells, I can supress the number data types, but not the string data types. Any ideas on how to suppress these blank string cells?

Thanks,

TM1 v. 9.4.1
User avatar
rkaif
Community Contributor
Posts: 328
Joined: Fri Sep 05, 2008 6:58 pm
OLAP Product: IBM Cognos TM1
Version: 9.1 or later
Excel Version: 2003 or later

Re: Supress Blank String Cell

Post by rkaif »

You should be able to Suppress the Rules Calculated String Cells both in the Cube viewer ans Spreadsheets (Active forms).

It will be good idea to share your Rule which is doing the calculation for the string cell.
Cheers!
Rizwan Kaif
Post Reply