Hi All,
We have an issue with data spreading. When we try to spread, it spreads to all available cells to the left or right. Is there a way to prevent from spreading after certain months? Example, put a stop after say 5 months or is there a way to limit spreading on a rule like period of performance? Say period of performane is between Feb-21 to Feb-23, when I spread from Sep-22 it should spread upto Feb-23. Please let me know if there's a way to accomplish this.
Thanks,
Paul.
Data Spreading - Stop after certain months
-
- MVP
- Posts: 3113
- 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: Data Spreading - Stop after certain months
What is the interface in which you want to accomplish this ?
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
-
- 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: Data Spreading - Stop after certain months
In PAW you can highlight the cells you want to be part of the spread and then use the right-click spread option, this will let you do all spreading options except "relative xxx" I believe. You don't have to select right, up, down, or left as you have already defined the area to be included by highlighting the cells.
I believe Architect/Perspectives cube viewers, TM1 Web cubeviewers, TM1 Web websheets, and PAX all have the same functionality of being able to highlight cells and then right-click to go to the spread options.
I believe Architect/Perspectives cube viewers, TM1 Web cubeviewers, TM1 Web websheets, and PAX all have the same functionality of being able to highlight cells and then right-click to go to the spread options.
Declan Rodger
-
- Posts: 124
- Joined: Tue Jun 13, 2017 3:20 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2010
Re: Data Spreading - Stop after certain months
Thanks Wim Gielis. We were trying to accomplishn in Contributor.
Thanks Declnar! That works.
Paul.
Thanks Declnar! That works.
Paul.