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