Page 1 of 1
simple question on the Subnm
Posted: Thu Sep 22, 2011 9:46 am
by stingo
Hi all,
when I create a data entry form I usually use drop down linked to subnm lists in order to let the user to choose elements in page for a particular view.
The client, instead, wants to have directly the subnm choice.
The fact is that when you save an application in TM1, you have a "default" choice in the subnm.
When the user has not the right to see that particular element selected, clicking the subnm, the selector opens but popping out an error on the rights to see that particular element.
Is there a way to avoid this?
Re: simple question on the Subnm
Posted: Thu Sep 22, 2011 10:03 am
by qml
There is an easy workaround - to create a "default" element in the dimension and grant read access to it to everyone. This could be something like "001 - Choose Element" and it would be a dummy element, not meant for actual data input/reporting.
Re: simple question on the Subnm
Posted: Thu Sep 22, 2011 10:08 am
by stingo
qml wrote:There is an easy workaround - to create a "default" element in the dimension and grant read access to it to everyone. This could be something like "001 - Choose Element" and it would be a dummy element, not meant for actual data input/reporting.
this was the initial Idea, but the user has not liked it.
Re: simple question on the Subnm
Posted: Thu Sep 22, 2011 10:16 am
by qml
If I recall correctly IBM changed the behaviour of SUBNM in some 9.4.x versions (without documenting it, of course) so that the Index parameter does not work in the context of the subset elements a user has access to, but instead in the context of the entire dimension.
Just checked it in 9.5.1 and it behaves like you would want it to - i.e. the Subset Editor only shows the elements a user has access to and the Index parameter works in the context of these elements - i.e. index 1 will return the first element in the subset that the user has access to.
Re: simple question on the Subnm
Posted: Thu Sep 22, 2011 4:13 pm
by csjean
Hi stingo,
qml wrote:Just checked it in 9.5.1 and it behaves like you would want it to - i.e. the Subset Editor only shows the elements a user has access to and the Index parameter works in the context of these elements - i.e. index 1 will return the first element in the subset that the user has access to.
The only thing you have to watchout for is
to
be sure that you specify a subset name in the SUBNM formula.
If you don't, TM1 will return the item having the dimension index that you specifie (1 usualy).
Hope this helps.