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 Jul 2, 2019

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.
  • Guest
    Jul 2, 2019
    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.