TM1 10.1. Workflow hierarchy dimension in websheet is not consistent with workflow hierarchy
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.