TM1 Perspectives features not implemented in Planning Analytics for Microsoft Excel
There are some features in TM1® Perspectives that are not implemented in Planning Analytics for Microsoft Excel.
- Modeling
- Modeling is not available in Planning Analytics for Microsoft Excel. Instead, you can use Planning Analytics Workspace to create and maintain models, applications, or security permissions.
- TM1 macro functions
- The TM1 macro functions are not available. The Planning Analytics for Microsoft Excel API can be used for macro automation
instead.Note: You may experience differences in performance and/or functionality if you are directly porting macro automation from TM1 Perspectives to Planning Analytics for Microsoft Excel. You should design and evaluate macro automation specifically for Planning Analytics for Microsoft Excel.
- Various spread methods
- The following methods to spread data are not available: Relative Proportional Spread, Relative Percent Adjustment.
- Dynamic Report cell and password protection
- Dynamic Reports are supported in Planning Analytics for Microsoft Excel, except for cell and password protection.
- User defined consolidations
- User defined consolidations are not available, including the usage of DBRW worksheet functions that use subset names as a dimension element reference. However, the DefineCalc function in Planning Analytics for Microsoft Excel offers similar functionality as a user defined consolidation in Perspectives.
- Holds in formula reports
- Holds in formula reports are not visible in Planning Analytics for Microsoft Excel.
- Referencing non-default hierarchies
- Referencing non-default hierarchies is not supported in formula or legacy reports. The default hierarchy must be the same-named hierarchy.
- The Print Report Wizard
- The Print Report Wizard is not currently implemented in Planning Analytics for Microsoft Excel.
- Undo to revert data entry changes
- The Undo capability to revert data entry changes is currently not implemented in Planning Analytics for Microsoft Excel.
- Annotations in formula reports
- The capability to add annotations in Dynamic Reports and Custom Reports is currently not implemented in Planning Analytics for Microsoft Excel.
- Use of IF condition to refer to SUBNMs in TM1RPTROW
- The capability to use the IF condition to refer to a SUBNM in TM1RPTROW is not implemented in Planning Analytics for Microsoft Excel.
- Replication and Synchronization
- The replication and synchronization features in TM1
Perspectives is not in Planning Analytics for Microsoft Excel. The following
alternatives are available:
- Git integration in Planning Analytics Workspace allows you to replicate a cube and its dimension from one server to another. For more information, see Use Git repository integration to manage Planning Analytics database objects. Every time you want your target server to be updated, you have to update the repository with a push and then do a pull from the target side.
- Git integration in Planning Analytics Workspace allows you to replicate a cube and its dimension from one server to another. For more information, see Use Git repository integration to manage Planning Analytics database objects. Every time you want your target server to be updated, you have to update the repository with a push and then do a pull from the target side.
- TM1py allows you to replicate a cube and its dimension from one server to another, but requires more effort. For more information, see TM1py.