Currently the only option to remove an element from consolidation with spreadsheet functions is to use PALO.EUPDATE
function. This method is in-direct as it requires all the elements remaining in consolidation as an argument which makes the use of function laborious.
A new function to simply "break" parent-child relation of two elements would make this operation much easier. The function could be something like PALO.EREMOVE(Server/Database,Dimension,Element,Consolidated Element).
As correctly identified above, this is already possible.
this is already possible, if you set the last parameter of the PALO.EUPDATE Function to 2, it will remove the element from the consolidated element. Example:
=PALO.EUPDATE("localhost/Demo","Regions","West","N","Germany",2)
will remove Germany from the node West