How can we improve Jedox Software?

Standard or Default Element for Splashing

It would be nice to be able to define an element in an hierarchy as standard element. This would mean that when splashing on the parent the full value would be written on this element rather than splashed onto all the underlying elements. This would save a lot of space in the cube and avoid having to always drill down to base level to input a value.

For example for a quick forecast I would like to forecast sales but do not want to forecast for every single product. I would like to be able to define a fallback item (e.g "Product not specified") and splash sales and not have it spread out among thousands of products or having to drill down to this default element making the input view awkward.

15 votes
Vote
Sign in Sign in with Jedox AG
Signed in as (Sign out)
You have left! (?) (thinking…)
Tobias Hessel shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

1 comment

Sign in Sign in with Jedox AG
Signed in as (Sign out)
Submitting...
  • Jens Consör commented  ·   ·  Flag as inappropriate

    I fully agree and would like to drive this further:

    1.)
    it should generally be possible to define ANY kind of default splashing behaviour!
    This might be distributing the full value to a single ~fallback-element, but might also cover
    all other existing Jedox distribution types (#, !, like, etc.)
    Example:
    If a enter the average rental price per square meter for a building on a yearly base (e.g. 2017) then this value should be copied to each single month (2017-01, 2017-02, ..) to calculate the expected monthly payments. (same is with average number of employees in HR reporting)

    2.)
    In terms of maintenance this could possibly work like defining a business rule

    3.)
    Whenever a default splashing behaviour has been defined for an cons. element (or a combination: e.g. time dimension in combination with a certain key figure), then it should be possible to directly enter a value onto this cons. element without any splashing operators.

Feedback and Knowledge Base