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

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:

(0 users)Average rating

Add comments

Document information


More support for:

Cognos TM1
TM1 Contributor

Software version:

10.1.1

Operating system(s):

Windows

Reference #:

1617675

Modified date:

2012-11-16

Translate my page

Machine Translation

Content navigation