Portability of workbooks between servers; what do you need?
Posted: Fri May 08, 2009 6:05 am
It's been suggested that a useful topic of conversation would be "portability of workbooks". I haven't put this in the Enhancements sub-forum because this isn't about a specific enhancement, but rather a fishing expedition for what people might consider to be useful in this regard.
Specifically, it's about "what would make it easier to move workbooks /worksheets between environments"? For the most part I would imagine that this would involve movement from a development to a production one, but it could be between different production environments as well. Aspects to consider include (add as needed):
- Formulas
- Action buttons
- Active forms
A couple that I can think of:
- Being able to specify the server name in a single cell so that all formula references flow from that cell. Effectively this has already been done with effect from 9.4.1 FP1. DBRWs have always worked correctly using a cell reference syntax; the big problem was that SubNms didn't, though that was rectified in 9.1.4 FP1.
- Action buttons which open TM1 applications have the workbook reference in the format Server\WebsheetName.xls. This would make it problematic to shift between servers.
Anyone else?
Specifically, it's about "what would make it easier to move workbooks /worksheets between environments"? For the most part I would imagine that this would involve movement from a development to a production one, but it could be between different production environments as well. Aspects to consider include (add as needed):
- Formulas
- Action buttons
- Active forms
A couple that I can think of:
- Being able to specify the server name in a single cell so that all formula references flow from that cell. Effectively this has already been done with effect from 9.4.1 FP1. DBRWs have always worked correctly using a cell reference syntax; the big problem was that SubNms didn't, though that was rectified in 9.1.4 FP1.
- Action buttons which open TM1 applications have the workbook reference in the format Server\WebsheetName.xls. This would make it problematic to shift between servers.
Anyone else?