Hi all,
I have an issue to determine spreading functionality.
Generally I'm using tm1web or perspectives. Trying to put numbers on consolidated elements and as result I expect value equally spread to all leaf elements.
It's working perfectly if all n-elements contains some numbers or all of them are 0s.
The case is that if some of them are 0 and some are different than 0, spread functionality avoids zero elements.
Is there any option to determine spread functionality to always spread to all n-elements?
Please help if there is any option like that. I couldn't find anything on this subject.
regards
Spread functionality
-
- Posts: 2
- Joined: Wed Mar 27, 2019 2:26 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2010
-
- Site Admin
- Posts: 1454
- Joined: Wed May 28, 2008 9:09 am
Re: Spread functionality
'Equal Spread Leaves' is probably the spread option you want - the last choice on the right click menu in Architect.
-
- Posts: 2
- Joined: Wed Mar 27, 2019 2:26 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2010
Re: Spread functionality
Hi,
Thank you for answer. Yes that is the right option from architect/perspective point of view. It is working as expected.
I have more doubts with tm1web. How to set it up to use such option in tm1web by default.
Not by using right-click menu but just input data directly into consolidation cells.
regards
Thank you for answer. Yes that is the right option from architect/perspective point of view. It is working as expected.
I have more doubts with tm1web. How to set it up to use such option in tm1web by default.
Not by using right-click menu but just input data directly into consolidation cells.
regards
-
- MVP
- Posts: 1815
- 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: Spread functionality
As far as I am aware there is no ability to change the default spreading option.
If you don’t want to use the right-click menu you can show users how to work with shortcuts, for your example it sounds like LS*500 would work - this would spread 500 equally across all leaves (the * indicates it should include even the 0 value cells.)
Or since you want an equal spread it could be easier for users to press C to clear the data and then just type the value they want, it then defaults to equal spread as the underlying data is empty.
If you don’t want to use the right-click menu you can show users how to work with shortcuts, for your example it sounds like LS*500 would work - this would spread 500 equally across all leaves (the * indicates it should include even the 0 value cells.)
Or since you want an equal spread it could be easier for users to press C to clear the data and then just type the value they want, it then defaults to equal spread as the underlying data is empty.
Declan Rodger
-
- MVP
- Posts: 3114
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Spread functionality
Hello,
While we are discussing a technical solution, can you tell us why you would like to have this, even more as the default choice of data entry ? I mean, in what kind of cubes / applications / levels of aggregation do you see fit for such a requirement ? I am supporting many TM1 models and the one thing that pisses me off the most, is when users overwrite a 0 value at consolidated level... unless it's purposeful (like all level 0 cells and then a consolidated month element gets the data that is to be spread over 3-6-12 months).
While we are discussing a technical solution, can you tell us why you would like to have this, even more as the default choice of data entry ? I mean, in what kind of cubes / applications / levels of aggregation do you see fit for such a requirement ? I am supporting many TM1 models and the one thing that pisses me off the most, is when users overwrite a 0 value at consolidated level... unless it's purposeful (like all level 0 cells and then a consolidated month element gets the data that is to be spread over 3-6-12 months).
Best regards,
Wim Gielis
IBM Champion 2024
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
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