Unbalanced hierarchies - Lock cells and Data Entry
AmirAbed
Active Partner
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
Tagged:
4
Categories
- All Categories
- 2K Forums
- 1.8K Platform
- 159 Academy
- 324 Resources
- 1 Board Knowledge Base
- 50 Best Practices
- 49 How-To Guides
- 19 Board Advocacy Program
- 191 Blog
- 4 Groups Hub
- 4 About Groups
- New Community Members
- DACH
- Japan
- 4 Community Captains
- 1 About Community Captains
- 2 Meet the Community Captains
- 1 Topics & Thought Starters
- Learn from the Board Captains
- Release Notes
- Academy
- 2 Board Academy
- 8 ILT/VILT Course Catalogue
- 13 e-Learning Course Catalogue
- 4 Academy Forum
- 1.2K Idea Exchange
- 337 Partner Hub
- 94 Support
- 14 FAQ's
- Customer Support Portal
- 54 Support Articles
- BEAP