TM1 Websheets and Approval Hierarchy
Posted: Wed Oct 15, 2014 6:02 pm
Hi,
We have a TM1 Planning and Forecasting model and we used Websheets and Active forms with lots of Action buttons to move data between cubes, and it is working well. We use 2 dimensions ( Service and Region ) to control the security ( with both, ElementSecurity and CellSecurity depending on the cube ). The TM1 version we have is 10.1.1, and Excel version is Excel 2007
Now we are planning to upgrade to TM1 10.2.2 and implement an approval hierarchy. We would like to keep all the websheets that we have, so will it be possible to keep them and implement the Approval hierarchy? My understanding is that Approval hierarchy works with one single dimension. In our case we need to dimensions, so is there any workaround for this, or do we have to merge both dimensions into one?
Thanks
We have a TM1 Planning and Forecasting model and we used Websheets and Active forms with lots of Action buttons to move data between cubes, and it is working well. We use 2 dimensions ( Service and Region ) to control the security ( with both, ElementSecurity and CellSecurity depending on the cube ). The TM1 version we have is 10.1.1, and Excel version is Excel 2007
Now we are planning to upgrade to TM1 10.2.2 and implement an approval hierarchy. We would like to keep all the websheets that we have, so will it be possible to keep them and implement the Approval hierarchy? My understanding is that Approval hierarchy works with one single dimension. In our case we need to dimensions, so is there any workaround for this, or do we have to merge both dimensions into one?
Thanks