Skip to Content
0
Former Member
Nov 26, 2008 at 04:13 PM

Data Entry - fetch dimension members - similar to EVCVW but not quite

23 Views

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).