About cookies on this site Our websites require some cookies to function properly (required). In addition, other cookies may be used with your consent to analyze site usage, improve the user experience and for advertising. For more information, please review your options. By visiting our website, you agree to our processing of information as described in IBM’sprivacy statement. To provide a smooth navigation, your cookie preferences will be shared across the IBM web domains listed here.
Changed status to 'Will not implement'. The zero suppression feature of Planning Analytics is implemented in the view construction and MDX query mechanisms in the TM1 database. We have no plans to also implement zero suppression directly in the clients (Perspectives, TM1Web, and Workspace). When using DBRW in combination with other Excel functions ina cell the scope of the view is limited to only that single cell. This problem is simple to workaround by having all DBRW cells in the same area of the report (hidden rows and columns are supported) with no additional functions, and then using references to those DBRW cells that perform the additional calculations.