Flex Grid Configuration Issues : Locked Cells and By Column properties issues.

Oussama BENAKMOUME

Hi everyone, I'm trying to recreate the Flex Grid layout shown in the screenshot (I've hidden the cube names, hopefully that's not an issue). 

In Cube 3 (Block C), I enabled Data Entry and set Detail By = Column: Month. Data entry is locked by Condition Block G, which is an algorithm also configured by Month. Due to the validation conflicts I encountered, I had to set Detail By = Month for all cubes to resolve those issues. 

The only remaining problem is with Entities. They are not configured by Month, and if I try to set them by Month, I get another validation error saying that **Entities cannot be entered by Month**.

 I'd also like to mention that I implemented the exact same layout in a Data View on Board 12, and it works without any issues. The problem only occurs with the Flex Grid on Board 15.

 Has anyone faced this issue before, or does anyone know of a workaround or the correct approach? 

Thank you in advance!

Hamza Mesbahi

Hi @Oussama BENAKMOUME ,

Based on the documentation for the Flex Grid By Column functionality, this is a known limitation. You can find it here: Flex Grid By Column

Entity blocks are not supported in the By Column configuration, which is why you're unable to configure them by Month and encounter the validation error.

If your use case requires this functionality, I'd recommend using a standard Data View instead. You may also want to raise a Support ticket so the team can review your specific implementation and advise you with a suitable workaround.

Kind regards,

Hamza