Hi Ken,
Another solution would be to build a stored procedure that takes as arguments the entries needed for creating a new row, if it doesn’t exist and/or filtering the rows upon those criteria, and use this stored procedure as source for your DataCube that returns the table you want to show (setting everything to bypass cache).
Like this each time there is a modification, the stored procedure will return a different set of data.
In the Dashboard you create parameterTextBox, parameterNumeric, parameterDateTime or parameterHierarchy, and link those parameters to Bridge Parameters in the DataCube in order to set the parameters of the stored procedure, they have to be out of the zone used for the visualisation, in order to hide them (do not use the hidden setting) from the end-user, depending on your needs, then you set thru javascript those parameters when the button “Update” is clicked with the values entered/selected by the end user in the parameters used by the end-user for setting the values in the visible part of the Dashboard, and you’ll just need to invoke the refreshAllAdapters(), after setting all the required parameters.
Like this you’ll decide what data will be returned by the stored procedure, and be also able to add values “on the fly”.
I hope this helps,
Olivier