All data input only at leaf level in Contributor

Post Reply
Paul-TM1
Posts: 142
Joined: Tue Jun 13, 2017 3:20 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

All data input only at leaf level in Contributor

Post by Paul-TM1 »

Hi all,
Is there a parameter that would not allow data input at consolidation level in Contributor? How can this be achieved?

Thanks,
Luther.
Wim Gielis
MVP
Posts: 3238
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: All data input only at leaf level in Contributor

Post by Wim Gielis »

Aren't you transitioning to more modern IBM PA / TM1 clients that will be supported going forward by IBM?
In 2 months time support will stop for a number of older TM1 clients.
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Paul-TM1
Posts: 142
Joined: Tue Jun 13, 2017 3:20 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

Re: All data input only at leaf level in Contributor

Post by Paul-TM1 »

Hi Wim,
We are transitioning from Contributor to PAW next month. In between, I want to expose the PAW views (input screens) to all the users for a month. This will give us time to fix the issues and fully upgrade. So, technically, we will be using 2.0.9.2 for a month and Contributor is still present.
We want to allow data input at the lowest (leaf) level only. There is a parameter that did not allow data input at consolidated level and cant find it now. Don't remember if it's ProportionSpreadToZeroCells. This works only if the leaves are zero. So, the confusion.

Thanks,
Paul.
ascheevel
Community Contributor
Posts: 314
Joined: Fri Feb 15, 2013 5:49 pm
OLAP Product: TM1
Version: PA 2.0.9.1
Excel Version: 365
Location: Minneapolis, USA

Re: All data input only at leaf level in Contributor

Post by ascheevel »

In PA, you'll find that setting in the }Capabilities cube, the specific item is "Consolidation TypeIn Spreading" and you'd want DENY for the EXECUTE permission.
Paul-TM1
Posts: 142
Joined: Tue Jun 13, 2017 3:20 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

Re: All data input only at leaf level in Contributor

Post by Paul-TM1 »

That helps. Thanks Ascheevel!
Post Reply