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.
Jens Consör commented
I fully agree and would like to drive this further:
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.)
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)
In terms of maintenance this could possibly work like defining a business rule
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.