How are you performing the load? You can choose whether an error is logged or the whole load aborts.
Thanks Tim, for you response.
I am using batch and MXL script to load data to database.
import database 'OD'.'DA' data from local text data_file 'C:\input\loaddata.txt' using server rules_file 'Rul1' on error write to 'C:\log\err.txt';
I dont see anywhere in the maxl to abort the whole load if there is an error. Can you please advise.
your problem is the load process is shifting the data based on the blank value. If you go therough the DBAG, there is an example if filling in the blank with a value. That would at least get only the row to reject (or you could put it to a specific member)
to do this, in the load rule. add atext column with the text being a tilde (~). The do a merge join on that column and the column giving you issues. Next, for the column, in the replacement section replace ~ with something (zzzzzz or a member name in that dimension) and check replace whole word only. then on the next line replace ~ with nothing without replace whole word only checked. That iwll handle the blanks
Apologize if i didnt get your suggestion.. are you referring to the below link for the example that you are referring? Just wanted to make sure i dont miss anything...
yes that is the link. I gave you a shortened version of it. Instead of a sting (like temp) I prefer to use a tilde since that typically does not appear in data
Thanks a lot Glenn/Tim for your response. I will try suggestion.