Technote (troubleshooting)
Problem(Abstract)
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.
Symptom
Adding a web sheet to use as view in TM1 applications.
Cause
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 :
Environment
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:
=DBRW("<tm1_server_name>:}ElementAttributes_}Clients";$A$1;"group_membership")
Resolving the problem
Using the SUBNM formula instead for getting the report parameters should enforce approval hierarchy security.
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.