Split&Splat functionality extension to even/repeated distribution

Krisztina Zappert · October 2

Hi,

I wish to have the split&splat functionality broadened, so it is not only able to split values according to the existing proportions, but have the ability to repeat the value, or to spread it evenly onto all leaf elements that are open for data entry.

It would be excellent if developers could set what kind of split&splat is used, but then users could overwrite that for themselves. This way users would be able to decide how the data they enter gets pushed down to the lowest level.

Use case for repetition:

Let's say we have a data layout displaying a flag cube. The layout has multiple entities of the same relationship on the rows. It would be great if I could tick an entity on the top level, and have all leaf levels populated with the tick (so, 1). Even those leaf members that are currently 0.

Use case for even distribution:

Let's say users are estimating plans for upcoming years that have no values yet, and they know that they have N dollars on a cost in the entire year, which is to be displayed as N/12 on each month. Today, they need to put N into a cube with years, and have that pushed down to months by a procedure. It would be much easier for them to just put N into the Yearly total, select that they want to split and splat evenly, and have N/12 populated onto the months. We wouldn't need 2 data views or a procedure, decreasing maintenance and development need, all the while increasing clarity and flexibility for the end-user.

Note: Even distribution would also work for the first case, where we use the cube for flagging. It doesn't have to be 1 to be flagged, it has no be not 0.