Hello,
I have a small problem with data spread. When I want to do a proportional spread. The time of spread is very long. Sometimes I must wait a 3-5 minutes. Do you know , how solve this problem ?
I looked for information about it on IBM site but I don't find a particular answer.
Thank you
Best regards
Kamil
How accelerate a speed of spread of data tm1
-
- MVP
- Posts: 3651
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: How accelerate a speed of spread of data tm1
Other than the speed of the CPU on the server running the TM1 instance the thing affecting the time to perform a data spread is the number of leaf cells which need to be updated.
Although to do a proportional spread you may be keying a value over just one cell. If the elements at the coordinates of that cell are highly consolidated on several dimensions then there may potentially be not just hundreds or thousands of leaf cells to update but millions of cells. (Remember that in TM1 all numeric values are held in leaf cells.) Spreading is just a shortcut to leaf data entry.
So the (only) way to speed this up is to perform the spread at a less highly consolidated level. (and be careful nut to spread over an intersection that contains billions of cells).
Although to do a proportional spread you may be keying a value over just one cell. If the elements at the coordinates of that cell are highly consolidated on several dimensions then there may potentially be not just hundreds or thousands of leaf cells to update but millions of cells. (Remember that in TM1 all numeric values are held in leaf cells.) Spreading is just a shortcut to leaf data entry.
So the (only) way to speed this up is to perform the spread at a less highly consolidated level. (and be careful nut to spread over an intersection that contains billions of cells).
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
-
- MVP
- Posts: 3105
- 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: How accelerate a speed of spread of data tm1
Added to this, look at feeders too. The leaf level cells receiving the data input might very well send feeders to potentially many other cells. If that’s the case you can notice a slower performance.
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
-
- Posts: 2
- Joined: Tue Sep 24, 2019 9:21 am
- OLAP Product: Planning Analytics
- Version: 2.0.8
- Excel Version: O365
Re: How accelerate a speed of spread of data tm1
To add on to Lotsarams comments.
I have found some clients to have thousands and thousands of very small values. The clients complain about performance with exports, calculations and inputs. After reviewing I often find tiny values, for example 0.00000008. These are invisible to the user due to formating. But the system uses them for proportional spreads, feeding etc.
So you could also check your model for tiny values that should really be zero.
I have found some clients to have thousands and thousands of very small values. The clients complain about performance with exports, calculations and inputs. After reviewing I often find tiny values, for example 0.00000008. These are invisible to the user due to formating. But the system uses them for proportional spreads, feeding etc.
So you could also check your model for tiny values that should really be zero.