IBM Support

TM1 10.1. Workflow hierarchy dimension in websheet is not consistent with workflow hierarchy

Technote (troubleshooting)


When adding a websheet to the TM1 application, and the web sheet contains a dimension tied to the security dimension. The dimension shows all elements and not just the elements that the user has access to.


Adding a web sheet to use as view in TM1 applications.


The combo box that holds the dimension for security is populated using a DBRW formula which does not take into account the security setting for the approval hierarchy :


Windows 2003, 2008

Diagnosing the problem

In the web sheet, the combo box holding the dimension that shows all elements is populated using a formula for example:


Resolving the problem

Using the SUBNM formula instead for getting the report parameters should enforce approval hierarchy security.

Document information

More support for: Cognos TM1
TM1 Contributor

Software version: 10.1.1

Operating system(s): Windows

Reference #: 1617675

Modified date: 16 November 2012

Translate this page: