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
- 1.8K Forums
- 1.7K Platform
- 109 Academy
- 283 Resources
- 3 Community Captains
- 1 About Community Captains
- 1 Meet the Community Captains
- 1 Topics & Thought Starters
- Board Manual
- 50 Best Practices
- 42 How-To Guides
- 25 Board Advocacy Program
- 159 Blog
- 4 Groups Hub
- 4 About Groups
- New Community Members
- DACH
- Japan
- Academy
- 2 Board Academy
- 7 ILT/VILT Course Catalogue
- 13 e-Learning Course Catalogue
- 4 Academy Forum
- 1.1K Idea Exchange
- 310 Partner Hub
- 2 Solution Sales Toolkits
- 92 Support
- 14 FAQ's
- Customer Support Portal
- 54 Support Articles
- BEAP