Data spreading with the TM1 REST API

One of the most powerful and complex features of TM1® is data spreading.

You can use data spreading to write large amounts of data into your TM1 database quickly. This feature is commonly used in planning and budgeting applications. For example, when you are projecting expenses based on last year's actual results, you can use data spreading to move last year's results, plus a small percentage, into this years projected budget. This technique gives you a baseline for projecting expenses for the next fiscal period.

To perform data spreading with the TM1 REST API, use the following actions:

• Cellset.Update
• Cellset.UpdateCells
• Cube.Update
• Cube.UpdateCells
• Update