automatic `.all` entities as parent entities
Suppose you want to compare one customer with all the customers. You select one customer per pager and want to have a dataview with the sales of the one customer directly comparing it with all of them. You add two cubes, one with the sales for that customer and another with the sales of all customers. That second cube could have a 'refer to' to a parent entity of the customers. That parent entity encompasses all of the customers and would effectively show the result unfiltered.
In the cube query language MDX there are automatic parents for all hierarchies. Those parents are designated [hierarchy].[all]
If Board entities had an automatic .all parent, dataviews and procedures would have a more powerfull wayto modify the screen select.
Those entities can of course be created manually but that would entail tedious changes to a current hierarchy. Having an automatic element would mean easier database management.
Categories
- All Categories
- 2K Forums
- 1.8K Platform
- 164 Academy
- 329 Resources
- 1 Board Knowledge Base
- 50 Best Practices
- 49 How-To Guides
- 19 Board Advocacy Program
- 195 Blog
- 4 Groups Hub
- 4 About Groups
- New Community Members
- DACH
- Japan
- 5 Community Captains
- 1 About Community Captains
- 3 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.3K Idea Exchange
- 338 Partner Hub
- 94 Support
- 14 FAQ's
- Customer Support Portal
- 54 Support Articles
- BEAP