IBM Support

Compound DBRW formulas are not supported in TM1 Web

Troubleshooting


Problem

TM1 Web does not support compound DBRW formulas. A compound DBRW formula is one in which a
DBRW function is used in combination with other functions and/or mathematical calculations.
Placing a minus sign before a DBRW function results in a compound formula, as this is interpreted as -1 x
(DBRW value).

If you want to display a value retrieved by a DBRW function as negative, create a cell reference with a
negative sign preceding the reference to a cell containing a DBRW function. For example, -A7, where A7
contains a DBRW function.
Some use cases may appear to work with compound formulas within TM1 Web, but they are not supported directly and thus should be avoided entirely.

[{"Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS9RXT","label":"Cognos TM1"},"ARM Category":[{"code":"a8m0z000000blfjAAA","label":"Troubleshooting"}],"ARM Case Number":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Version(s)"}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
09 May 2025

UID

swg21967436