Skip to Main Content
Jedox Ideas

Let us know how we can make Jedox even better!

Status Already exists
Workspace Jedox Platform
Created by Guest
Created on Jul 2, 2019

Simple function to remove an element from consolidation (PALO.EREMOVE or something similar))

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).
  • Guest
    Reply
    |
    Jul 10, 2020

    As correctly identified above, this is already possible.

  • Guest
    Reply
    |
    Apr 30, 2020

    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