Modify TM1 data

You can modify data in reports that use an IBM® Planning Analytics data source.

For example, when your TM1® Server Application folder administrator distributes an enterprise-wide plan, you can use IBM Planning Analytics for Microsoft Excel to create an exploration to review, analyze, and update the portion of the plan that is assigned to you.

You can also write back data using TM1 worksheet functions, such as DBRW.

IBM Planning Analytics for Microsoft Excel offers different ways to work with IBM TM1 data changes. The Writeback mode and the Sandbox settings determine how changes to the server data are managed.