Hi all,
Is there a parameter that would not allow data input at consolidation level in Contributor? How can this be achieved?
Thanks,
Luther.
All data input only at leaf level in Contributor
-
- 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
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.
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
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
-
- 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
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.
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.
-
- 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
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.
-
- 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
That helps. Thanks Ascheevel!