we are trying to submit data using smartview adhoc "submit data" button. However, instead of hard coded values in the data cell, we are using a formula to calculate the value to be submitted.
for example, in cell F24, instead of typing in 200, it uses a formula cell A10*2 to get to calculate a value to submit. When I click on Submit data with that formula there, it will not submit the data. I know the intersection points are valid because if I sumbit a hard coded value it is submitted successfully.
I do have the "Preserve Formula and Comments on Adhoc Operation (Except pivot) checked. If I uncheck this and click submit. it brings back the data from the cube and my formulas are gone. So I cannot remove the check for the "Preserve formula"
is there any way to submit data based on calculated value?
we will be submitting data to both Essbase and HFM cube.
The SV version we are using is 184.108.40.206.103 (Build 100)