Hi,
as the split and splat functionality goes, unless the cube 1 has some values, if we want to enable data entry at a higher level of aggregation than the cube 1 dimension itself, the data entry only becomes enabled if the cube as a value.
To resolve it, we flow a very small constant number (by opening up the calculation domains on the cube dimensions) to enable data entry or dataflow a cube 2 (that has a parent of the entity of cube 1) populated through a data reader with a constant into cube 1, or several other ways through which we can get some or the other value into cube 1 to open up data entry. There are pros and cons of each of this approach, but if the cube 1 dimensions have dimensions with a large number of active members, then often there are performance issues, or an error occurs that says tuples limits exceeded.
So, is there any solution where data entry is enabled even if the cube is blank, i.e. no constant value or any value needs to be dataflowed into cube 1. & the split and splat feature works as expected ?