Jedox – User CRUD – Manage Dimensions within worksheet

Usecase

Sometimes it´s needed that a user can add elements to a dimension without accessing the modeller – e.g. you wanna budget personal ressources and want to allow power users to add new placeholders to the employee dimension.

Entry mask for new employees

To get this working, you can use multiple ways on how to pass values from the worksheet, to the script – I prefered to use “names” for the parameters I wanna pass to my php:

Name Manager

Then with the “add” button, I use the following macro to insert the new element to the selected parent (trop down) and add the attributes.

After you added the new element, with the recalc call at the end of the script, the dyna range should refresh immediatly and you should see the new element.