Unbalanced hierarchies - Lock cells and Data Entry

AmirAbed
AmirAbed Active Partner
Level 300: Expanding Board in Your Organization Level 200: Building A Planning Solution in Board First Anniversary 5 Up Votes

Hello Team,

We noticed a limitation about "Unbalanced hierarchies" and "Cell lock" data entry.

Let's say we have :
An unbalanced entity (Account)
An “A” cube structured by (Month x Account)

In fact, when we display a layout containing our A cube (with data entry enabled), and axis by row: Account (which is unbalanced) and Axis by column: Month

We notice that we can't use the “Lock and Spread” feature on the month total.

Example:
We have the value 10 on all the months of the year 2022 (making a total of 120)
When we lock the total (120), and for example enter a value of 500 for one month (e.g. March 2022), the total increases to 620.

--> The total cell lock is ignored.

Best regards,

Amir

4
4 votes

Open For Voting · Last Updated