How accelerate a speed of spread of data tm1

Post Reply
Palczan
Posts: 20
Joined: Tue Apr 14, 2020 8:57 am
OLAP Product: TM1 Cognos
Version: 11.3.0.27
Excel Version: Office 365 MSO 64bit

How accelerate a speed of spread of data tm1

Post by Palczan » Thu Aug 27, 2020 6:59 am

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

lotsaram
MVP
Posts: 3475
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

Post by lotsaram » Thu Aug 27, 2020 11:34 am

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).
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.

Wim Gielis
MVP
Posts: 2646
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.8
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: How accelerate a speed of spread of data tm1

Post by Wim Gielis » Thu Aug 27, 2020 4:16 pm

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

Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 117 TM1 articles and a lot of custom code
Newest blog article: Avoid circular references https://github.com/wimgielis

curiops
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

Post by curiops » Fri Aug 28, 2020 9:04 am

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.

Post Reply