Page 1 of 1

Repeat Leaves - LR Shortcut

Posted: Mon Sep 17, 2012 12:06 pm
by declanr
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...

Re: Repeat Leaves - LR Shortcut

Posted: Mon Sep 17, 2012 1:16 pm
by Duncan P
LR*3

Re: Repeat Leaves - LR Shortcut

Posted: Mon Sep 17, 2012 1:25 pm
by declanr
Duncan P wrote:LR*3
Duncan you are a star (pun semi-intended.)

Re: Repeat Leaves - LR Shortcut

Posted: Mon Sep 17, 2012 2:57 pm
by Duncan P
BTW http://publib.boulder.ibm.com/infocente ... B0F6F.html.

Took a bit of finding. I knew it must be documented somewhere.