TM1 Forum

Hi Everyone,

I've got an excel sheet that works fine refreshing, expanding elements okay but once published to tm1web - it displays all rows that even have zero values. Has anyone encoutered this phenomenon?

Some details about the excel worksheet:
* Not a plain slice from cube viewer
* References 2 cubes
* Has combination of DBRW and DBR for iteration
* Contains some regular excel formulas like IF() and B20 - C20
Not sure if it has to do with referring to TM1RPTROW column for DBRW's, having 2nd cube data, the DBR column or some other factor, that cause difference from excel displaying only the rows returning non-zeros and tm1web expanding to include rows with all zero values.


Thanks

Before you upload the active form into the TM1 application folder, first delete all rows (even those blank) BELOW the row with the TM1RptRow() formula. I've often found that the browser will cache whatever view is first rendered, and the rows won't update properly unless you load it this way.

Just be sure you don't accidentally delete your TM1RptRow() row as well. I've made that mistake one (ten?) times too many.

The parameter that indicates zero suppression is with the TM1RPTVIEW formula.

Also, can I assume when you publish to Tm1web, you have got suppress zero toggled on?