Hi, we would need some urgent help concerning security configuration in one customer running ‘Budget and Planning’ in V12 MT (not standard module but customized from scratch)
We have set a security access by the dimension entity where the users only have access to read/write on their own entities. The problem comes for an special casuistic consistent on the sales module prices where some users need to write some prices on an entity outside their scope, that is, on an entity where these users have not access to write nor reading
This issue is already have experimented on the standard consolidation platform in the intercompany reconciliation report where it is necessary to ‘read’ information from other entities in order to match the interco figures and that problem is easily solved by creating a second connection to the OLAP in Application Studio with ‘admin’ permissions to be used in the cells where we have to show information from other companies (with ROC, CELLGET, etc.)
This solution consistent on creating a second connection ‘ad hoc’ for these purposes it is not possible to create it at MT because of security problems as we were informed from support team
We know that we can create a ‘mirror’ cube without the dimension affected to skip the security but probably would have a huge impact on performance and it would be a solution for ‘read’ all companies but not for ‘writing’
Any suggestion to solving this issue?
Many thanks a lot in advance, any helpful information would be appreciated
Kind Regards,
