You can add formulas that use IBM TM1 functions to reports. You can also convert Exploration Views that use TM1 data to formulas. For advanced analysis, you can create reports that use formulas to populate the cells of a worksheet.

IBM® Planning Analytics Worksheet functions return a numeric or string value. You can use TM1® worksheet functions anywhere in an IBM Planning Analytics for Microsoft Excel or TM1 Perspectives worksheet. To access these functions in Microsoft Excel, choose Formulas > …

IBM Planning Analytics for Microsoft Excel supports most TM1 worksheet functions.

2013年4月9日 · As i found using rule tracer if we have several not nested IF statements in rules with constructions like IF(<...>,0,Continue), TM1 will calculate all IF-s (suppose we don't use skipcheck and feeders) until one of them return not special command "CONTINUE" but a value or command "STET".

2011年8月16日 · Here we discuss how to do three rules, all that should be in your TM1 kitbag. These include Allocation/Phase Rule, Rolling Value Rule and Averaging Rule (C Level). There are full explanations and the code used for the rule examples.

2015年10月26日 · DBRA is an Excel based function for use with TM1 that retrieves a value from, and writes a value to, an Attribute from a Dimension in TM1. It is roughly equivalent to using a ATTRS in a Rule or TI, except you can use it to update an attribute as well.

2020年4月1日 · Do you know how to explain what is TM1 and its key concepts? What is TM1? Do you know all Functions in Excel for TM1? What is a DBRW formula? From Bedrock to Debugging, key concepts developers should master! Attributes in TM1. More things to be aware off. Building the next generation of TM1 applications taking full advantage of Hierarchies.

2014年9月28日 · ELPAR is a TM1 worksheet function for showing the parent value of an element. This explains the syntax and use of ELPAR, however it is better to use ATTRS.

DBRW is a Microsoft Excel function that connects to an intersection, or data point, in a TM1 cube. A user can retrieve or send data to and from the cube with this function. The syntax of the DBRW function is: =DBRW (<name of the TM1 server>:<cube name>, e1, e2, e3, …, en)

Syntax for Formulas A rules formula is an expression composed of: Using Cube References All rules formulas contain cube references, which point to areas within a cube for data. The cube references can point to the cube for which you are writing a rule (internal cube references) or to areas within other cubes (external cube references).