New "NA" or "BLANK" Mode for Data Reading CODEs
Pratik Tandale
Employee
Currently for a Code in Data Reader:
APPEND : Add a new code if it does not exist and record is valid
REJECT: Reject a new code if it does not exisit and record is invalid
Add a new
"NA" or "BLANK" mode: If code does not exist, read it as "_" or "Not Available" and record is valid
Use Cases:
1. Currently if there is a rejection of records due to any reason, we have to refer to logs or create procedures/datamodel to show this to the user. Loading it in an "_" entity member can be immediately used for alerting mechanism to highlight an invalid record.
2. We can even use the cube values loaded against "_" entity member so users can understand the importance of the missing dimension based on the weightage of the cube value
3. It can ensure the overall value of the table/datasource is loaded in Board even if against an "_" dimension
4. Use the "_" dimension as Other to group non important data. Eg. company wants to plan against 100 products and rest should be grouped in "_". Company can maintain this main product list and board will automatically load the remaining data (even new products) directly in "_"
APPEND : Add a new code if it does not exist and record is valid
REJECT: Reject a new code if it does not exisit and record is invalid
Add a new
"NA" or "BLANK" mode: If code does not exist, read it as "_" or "Not Available" and record is valid
Use Cases:
1. Currently if there is a rejection of records due to any reason, we have to refer to logs or create procedures/datamodel to show this to the user. Loading it in an "_" entity member can be immediately used for alerting mechanism to highlight an invalid record.
2. We can even use the cube values loaded against "_" entity member so users can understand the importance of the missing dimension based on the weightage of the cube value
3. It can ensure the overall value of the table/datasource is loaded in Board even if against an "_" dimension
4. Use the "_" dimension as Other to group non important data. Eg. company wants to plan against 100 products and rest should be grouped in "_". Company can maintain this main product list and board will automatically load the remaining data (even new products) directly in "_"
10
Categories
- All Categories
- 1.8K Forums
- 1.7K Platform
- 104 Academy
- 274 Resources
- 3 Community Captains
- 1 About Community Captains
- 1 Meet the Community Captains
- 1 Topics & Thought Starters
- Board Manual
- 50 Best Practices
- 41 How-To Guides
- 25 Board Advocacy Program
- 155 Blog
- 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
- 270 Partner Hub
- 1 Solution Sales Toolkits
- 91 Support
- 14 FAQ's
- Customer Support Portal
- 54 Support Articles
- BEAP