Needed some help, Trying to grey out an option in the picklist that a TI uses. if one user has selected option 'progress', the other then will not be able to change until the TI using the picklist has finished.
Any ideas what I can do?
greying out cells in tm1
-
mistry
- Posts: 2
- Joined: Thu Mar 20, 2014 9:50 am
- OLAP Product: tm1
- Version: 9.5.2
- Excel Version: 2010
greying out cells in tm1
Hello,
Needed some help, Trying to grey out an option in the picklist that a TI uses. if one user has selected option 'progress', the other then will not be able to change until the TI using the picklist has finished.
Any ideas what I can do?
Needed some help, Trying to grey out an option in the picklist that a TI uses. if one user has selected option 'progress', the other then will not be able to change until the TI using the picklist has finished.
Any ideas what I can do?
Last edited by mistry on Fri Mar 21, 2014 8:33 pm, edited 1 time in total.
-
qml
- MVP
- Posts: 1096
- Joined: Mon Feb 01, 2010 1:01 pm
- OLAP Product: TM1 / Planning Analytics
- Version: 2.0.9 and all previous
- Excel Version: 2007 - 2016
- Location: London, UK, Europe
Re: greying out cells in tm1
No idea what you mean by that. Please explain, ideally with some pictures.mistry wrote:As soon as the pick list item "progress" is selected, i want to grey out the white cells that is being used because of the TI?
By the looks of it you should consider some conditional rules in the data entry cube or possibly conditional rules in the corresponding cell security cube.
Kamil Arendt
-
mvaspal
- Community Contributor
- Posts: 341
- Joined: Wed Nov 03, 2010 9:16 pm
- OLAP Product: tm1
- Version: 10 2 2 - 2.0.5
- Excel Version: From 2007 to 2013
- Location: Earth
Re: greying out cells in tm1
Hi,
If you want to disable data entry to picklist cells that were set by your TI, most probably you will need a cell security cube, and set the relevant cells to READ. You could do it from the same TI that sets the values for the Picklist cells.
If you want to disable data entry to picklist cells that were set by your TI, most probably you will need a cell security cube, and set the relevant cells to READ. You could do it from the same TI that sets the values for the Picklist cells.
-
mistry
- Posts: 2
- Joined: Thu Mar 20, 2014 9:50 am
- OLAP Product: tm1
- Version: 9.5.2
- Excel Version: 2010
Re: greying out cells in tm1
I have created a cube that allows the user use a picklist. A TI has also been created so the TI looks for the choices of the picklist. The picklist has two options, one is "blank" and the other is "progress". If this TI finds a picklist with the option “Progress” , it will kick start the other processes that have been defined. I am now at the stage where I need to grey out the picklist option once the picklist has been chosen the option “Progress". This will stop many users to select the "progress" option when the TI is already running. So the next time anyone would be able to select the option is when the TI has finished.
-
babytiger
- Posts: 78
- Joined: Wed Jul 31, 2013 4:32 am
- OLAP Product: Cognos TM1, EP, Analyst
- Version: 10.2.2
- Excel Version: 2013
- Location: Sydney AU
Re: greying out cells in tm1
Hi,
You may want to give this a try:
1. Insert another cell/element in your cube (Cube A), eg. running
2. At the start of your master process, insert code that adds a flag in this new cell, eg, Y.
3. At the end of your master process, insert code that removes this flag.
4. In your control cube (Cube A), added rule: ['PickList'] = S: IF(['Running']@='Y",'Progress',stet;);
This would prevent users updating this cell value. But it does not prevent user running the TI manually though.
So, you may want to add further codes in the TI to stop running if the ['Running'] contains a Y.
Hope this helps.
Regards
You may want to give this a try:
1. Insert another cell/element in your cube (Cube A), eg. running
2. At the start of your master process, insert code that adds a flag in this new cell, eg, Y.
3. At the end of your master process, insert code that removes this flag.
4. In your control cube (Cube A), added rule: ['PickList'] = S: IF(['Running']@='Y",'Progress',stet;);
This would prevent users updating this cell value. But it does not prevent user running the TI manually though.
So, you may want to add further codes in the TI to stop running if the ['Running'] contains a Y.
Hope this helps.
Regards
MK