We have to create a dynamic data entry report, where the user may have to actually choose different elements of the same dimension, but on different lines.
The problem with EVCVW is that once a line is changed (a new member is selected) all previous members selected also change, on all other lines (since they are still linked to the EVCVW function).
Is there a function, similar to EVCVW, which brings me the dimension members organized on the diverse hierarchies, but does not change the current view and instead saves the current member selection on the current cell?
(I'm trying not use some external trick to accomplish this task, such as excel comboboxes/validation).