Hi there,
I'm actually writing a report that fills and changes a cube, I found a nice example here: jedox.com/de/jedox-web-adjusting-data-with-buttons
Something like this is what I want to do.
Now my problem: I have an attribute that can only contain A or B as value. I created a combobox with ={"A";"B"} to get a dropdown with these values. The combobox has @var as target.
Clicking "add" Button the @var target is written into the cube.
I display all existing elements of the cube via dynarange after the form that can insert new data into the cube.
I now want to implement a "load" button for each entry of my database that loads the selected element and its attribut into the "add" form. The user should be able to change the values and to update the data.
I use =HYPERLINK("SELF";"load";"Edit data";B26;C5;C26;C7;D26;@var) for this. I tried to make @var as target for the data. using cells as target works but the combobox element is not being updated.
Now my questions:
Florian
I'm actually writing a report that fills and changes a cube, I found a nice example here: jedox.com/de/jedox-web-adjusting-data-with-buttons
Something like this is what I want to do.
Now my problem: I have an attribute that can only contain A or B as value. I created a combobox with ={"A";"B"} to get a dropdown with these values. The combobox has @var as target.
Clicking "add" Button the @var target is written into the cube.
I display all existing elements of the cube via dynarange after the form that can insert new data into the cube.
I now want to implement a "load" button for each entry of my database that loads the selected element and its attribut into the "add" form. The user should be able to change the values and to update the data.
I use =HYPERLINK("SELF";"load";"Edit data";B26;C5;C26;C7;D26;@var) for this. I tried to make @var as target for the data. using cells as target works but the combobox element is not being updated.
Now my questions:
- 1st approach: is it possible to update the selected item of the combobox out of HYPERLINK function?
- 2nd aproach: is it possible to listen for changed cells in the sheet via macro? So I think I could change combobox selection listening on changed cells via sheet macros.
Florian