Mandatory dimensions / consistency checks in quick layout

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).

5
5 votes

Archived · Last Updated

Comments

  • Nicolas CHIGROS
    Nicolas CHIGROS Active Partner
    Fourth Anniversary 250 Up Votes 25 Likes 10 Comments
    edited June 2023

    I like the idea. However, in a slightly different context, I wouldn't mind users to still be able to remove the "mandatory" entities as long as it disable the data entry. Maybe having both possibility would be nice.

  • Product Management Team
    Product Management Team Employee, Group Leader
    250 Likes 500 Comments First Anniversary Name Dropper

    Thank you for sharing your insightful suggestion with us, @Etienne CAUSSE. Your time and effort are genuinely valued.  
     
    As of April 2023, we have implemented a thoughtful archiving process for Ideas that have received 5 or less than 5 votes and are more than 6 months old. This approach ensures that our Idea Exchange remains well-organized, highlighting the most sought-after suggestions and streamlining their accessibility for both our community and team (details in our Idea Exchange FAQs).  
     
    We're dedicated to offering the best user experience and prioritizing features and enhancements that significantly impact everyday usage of our software.  
     
    Please keep those creative ideas and feedback coming – we always look forward to hearing from you.  
     
    Thank you again for your understanding and continued support. 

  • Hi,

    is it archived or on the contrary implemented in Board 14 ? I understand the latter…