New "NA" or "BLANK" Mode for Data Reading CODEs

Pratik Tandale
Pratik Tandale Employee
First Anniversary 5 Up Votes
edited April 2022 in Idea Exchange
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 "_"
10
10 votes

Archived · Last Updated