All,
A simple question where I am pretty much expecting the answer to be no...
The LR shotcut you can use in cube views, websheets etc. e.g. LR3 would spread a 3 to all the leaf cells under a consolidation... fantastic... as long as their are values for it to replace. Is there a shortcut that either Repeat to All Leaves regardless of current value or Add to all Leaves?
I know this can be done through right-click etc and I could also write a TI to spread this but I'm just looking to see if there is a simple shortcut?
http://pic.dhe.ibm.com/infocenter/ctm1/ ... =2_2_6_3_0 - the reference guide doesn't even seem to document LR as being a shortcut as far as I can see...
Repeat Leaves - LR Shortcut
-
declanr
- MVP
- Posts: 1831
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Repeat Leaves - LR Shortcut
Declan Rodger
-
declanr
- MVP
- Posts: 1831
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: Repeat Leaves - LR Shortcut
Duncan you are a star (pun semi-intended.)Duncan P wrote:LR*3
Declan Rodger
-
Duncan P
- MVP
- Posts: 600
- Joined: Wed Aug 17, 2011 1:19 pm
- OLAP Product: TM1
- Version: 9.5.2 10.1 10.2
- Excel Version: 2003 2007
- Location: York, UK
Re: Repeat Leaves - LR Shortcut
BTW http://publib.boulder.ibm.com/infocente ... B0F6F.html.
Took a bit of finding. I knew it must be documented somewhere.
Took a bit of finding. I knew it must be documented somewhere.