Excel-related issues in TM1 Web

[harrytm1]

Hi fellas,

I'm trying to compile a list of issues that we can all refer to when we develop Excel reports and input templates to be published in TM1 Web. Below is a starter.

If you like to contribute to the list, please copy the entire list in your reply and insert yours. If the issue is specific to Excel files that are developed with Excel 2003 and published in a Web server that is running Excel 2007, please highlight so that we know the conditions.

Note that the following list is based on Excel 2003 and TM1 9.4.1 (without Fix Pack). Thanks.

Issues and Considerations on TM1 Websheets
SUBNM
• Formula must not contain blank arguments.
• If possible, provide a subset.

Buttons
• Excel macros do not work in Web.
• Have to use Action Buttons instead.

Active Forms
• Do not use defined names as reference in all Active Form-related formulae i.e. functions prefixed with “TM1Rpt”.
• Instead, use cells to reference defined names i.e. “=property”.
• Then, refer to these cells in “TMRpt” formula.
• Also, do not use blank arguments in the formula.
• DBRW formula in Active Form CAN use defined names.

Excel Graphs
• Do not use images as background for charts and bars.
• Cannot combine other Excel formulae with a “=property” type of formula in a text box. The reference to a defined name only works by itself.
• Data formatting is limited in Web.
• 3D and shading may not work in Web.

Known bugs
• Avoid using If condition that checks for “null” value in a cell. Web will treat a blank cell in Excel as having value.

[Jessy]

Do cells with image background work on TM1 Web?
Seems the image is unavailable

[Alan Kirk]

Do cells with image background work on TM1 Web?
Seems the image is unavailable

Apparently not, regardless of the format of the background images; .jpg, .png and .gif all failed to work in 9.1. (Though some may argue that this is a blessing rather than a curse.)

This isn't explicitly stated in any manual (that I've been able to find). However I imagine that Iboglix wouldn't have been able to address every single feature of Excel's, especially one that I think would be rarely used given the ability of a background image to clutter the display and blow out the size of the workbook.

[winsonlee]

I have upgraded from CE 9.0 to CE 9.5. Earlier I manage to create an excel template with background and it manage to display on tm1 web. After upgrading, seem like it is no longer working. anyone has such issue before ?