Context
- When designing data entry screens, we are often in the situation where we want to give a maximum flexibility to the end user to choose the most relevant axis. Quick layout is great for that.
Issue
- However we often have the situation where at least one dimension is mandatory, otherwise figures don't make sense. Typically, when entering data in a cube in reporting currency, we need to keep at least the currency in the dimensions.
Idea
: allow some entities to be set as "mandatory" in quick layout so the user can add / change other dimensions, but cannot remove the entities specified as "mandatory".
This could be generalized to the data model by specifying for some cubes which entities can be cumulated for the cube, and which cannot (ex. "phase" entity to split actual and budget, any report that does not select a phase or split by phase would be meaningless).