Is it possible to load data from flat file into BPC using the *MVAL function for multiple time periods, where some time periods (historical ones) have blank cells, but do not overwrite the data?
In my tests, blank cells are overwriting data in the system with zeros, but I want it to preserve the data.
I have tested this by doing;
What I have tried so far;
The other option is that users have to provide the data in a different format - 1 record per row, which is very undesirable as the finance users don't have it in this format already. An option but undesirable.
Any sharing of experience would be much appreciated,