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:


Operating system(s):


Reference #:


Modified date:


Translate my page

Content navigation