Top-Down Data Entry

Post Reply
Toto
Posts: 71
Joined: Mon Jul 20, 2009 8:52 am
OLAP Product: TM1
Version: 9.5 Build 9.5.00100.2380
Excel Version: 2003

Top-Down Data Entry

Post by Toto »

Hello,

I want the users to enter data top-down but the consolidated cell are locked. Which options do I have to set in order to allow the users to enter data top-down?

Thanks a lot,

Toto
David Usherwood
Site Admin
Posts: 1458
Joined: Wed May 28, 2008 9:09 am

Re: Top-Down Data Entry

Post by David Usherwood »

You may have locked the element - in which case unlocking would be the right thing to do :)
Otherwise, if the c level element(s) are writable by your users, then they can use top down spreading. But they can't just type a number in. Right click, select spreading, take one of the last four options, starting with Relative Proportional Spread.
Toto
Posts: 71
Joined: Mon Jul 20, 2009 8:52 am
OLAP Product: TM1
Version: 9.5 Build 9.5.00100.2380
Excel Version: 2003

Re: Top-Down Data Entry

Post by Toto »

Hi David,

understood, thanks a lot for your answer.

Regards,

Toto
Post Reply