Hello everybody,
in a report I use DIMNM function with a subset in order to use just a part of the element present in that dimension.
Anyway when the selection screen appears (Subset Editor) if you press "All", all the element appear...
I would like to fix the subset in order to forbid to users to expand the selection.
Is there an option to do it?
Thanks in Advance for you help.
Nicola
Subset fix
-
nicola531
- Posts: 43
- Joined: Thu Oct 22, 2009 7:58 am
- OLAP Product: TM1
- Version: 9.5.1
- Excel Version: 2007
Re: Subset fix ERRATA CORRIGE
the function was SUBNM
txs Nicola
txs Nicola
-
Michel Zijlema
- Site Admin
- Posts: 712
- Joined: Wed May 14, 2008 5:22 am
- OLAP Product: TM1, PALO
- Version: both 2.5 and higher
- Excel Version: 2003-2007-2010
- Location: Netherlands
- Contact:
Re: Subset fix
Hi Nicola,
It is not possible to change this 'show all' behaviour.
If you want to restrict the available elements you can (should) use dimension element security.
Another option could be to create a seperate dimension which only contains the elements that are in the subset. With this construct the cube will still contain the full dimension, but the SUBNM formula can refer to the 'subset copy' of the dimension. This way, if the end user clicks on the 'All' button (s)he will only see the elements available in this restricted copy of the dimension.
Michel
It is not possible to change this 'show all' behaviour.
If you want to restrict the available elements you can (should) use dimension element security.
Another option could be to create a seperate dimension which only contains the elements that are in the subset. With this construct the cube will still contain the full dimension, but the SUBNM formula can refer to the 'subset copy' of the dimension. This way, if the end user clicks on the 'All' button (s)he will only see the elements available in this restricted copy of the dimension.
Michel