TM1 Forum

Hi all,

Some functions seems not running in active forms (SUMIF, VLOOKUP). Is there any possibility to be able to run them in TM1 web sheets?

Thanks so much,

There's lists of functions supported and unsupported in Websheets in the docs.

Regarding the Excel worksheet fcts supported by Excel see the manual TM1 9.5.2 Web User Guide:

http://publib.boulder.ibm.com/infocente ... Web_NE0007
TM1 9.5.2 Web User Guide
Supported Excel Functions - WebTM1
IBM Cognos TM1 Web supports many Excel worksheet functions.


The same manual also lists the Excel worksheet fcts not supported by TM1 9.5.2 Web:

http://publib.boulder.ibm.com/infocente ... Web_NF0007
TM1 9.5.2 Web User Guide
Unsupported Excel Functions - WebTM1
IBM Cognos TM1 Web supports many Excel worksheet functions. This appendix lists the Excel functions, by category and in alphabetical order, that are not supported in TM1 Web.


Also helpful may be the old Applix document "Applix TM1 9.0 SP3 - Web Supported Excel Feature List":

http://public.dhe.ibm.com/software/data ... relist.pdf
Applix TM1 9.0 SP3 - Web Supported Excel Feature List


Also helpful may be the the Cognos Proven Practice document "IBM Cognos TM1 Web Tips and Techniques":

http://www.ibm.com/developerworks/data/ ... ge343.html
IBM Cognos TM1 Web Tips and Techniques

Summary: This document describes various tips and techniques that will improve functionality, ease administration, and improve performance of IBM Cognos TM1 Web applications.

This document describes various tips and techniques that will improve functionality, ease administration, and improve performance of IBM Cognos TM1 Web applications.

Topics covered include:

* Performance Tips
* Formatting Tips
* Control Objects and Forms

http://public.dhe.ibm.com/software/dw/d ... niques.pdf