Skip to Main Content
Jedox Ideas

Let us know how we can make Jedox even better!

Status Future consideration
Workspace Jedox Platform
Created by Guest
Created on Jun 19, 2020

Hold on CE level -> Adjust BE

Hold aggregation value and adjust base elements while reallocate with weighted distribution.

  • Guest
    Reply
    |
    Sep 24, 2021

    The desired functionality should be as follows.

    Say we have three Departments A, B and C

    Place a Hold on Total departments. Say at 100K

    Then go to department A and set it to 50K

    Both Deparments B and C would then go to 25K each and Total departments stay at 100K

    Total Depts 100k (Held)

    Dept A 50 K (type 50K)

    Dept B 25K (goes to 25k)

    Dept C 25K (goes to 25k)

    Next you put a second Hold on Department A and adjust Dept B to be 30K. Dept C would then become 20K.

    Total Depts 100K (Held)

    Dept A 50 K (Held)

    Dept B 30 K (Type 30K)

    Dept C 20 K (goes to 20k)


    This is a must more useful Hold functionality than the current Jedox method and is other products do have this capability.


  • Guest
    Reply
    |
    Apr 27, 2021

    Hello,


    yes, i checked this one, but the customer wanted a seamless integration where the user can hold multiple measures on a flexible level to then be able to work within the template on some of them.


    it's possible to integrate this but it could be better integrated e.g. in paste views.

  • Admin
    Dominik Lenz
    Reply
    |
    Jun 26, 2020

    Hi,

    have you already looked into the "reallocate" functionality? It is described here: https://knowledgebase.jedox.com/knowledgebase/planning-assistant-transfer-reallocate/

    It allows you to change some value, keep the value of parent elements as they are, and re-allocate the necessary difference across a defined set of other elements. It can also take existing value distribution into account. Please let us know if this helps.