If I have two columns like a name and a rank in a table on the cube and both are editable is there a way to "bulk" edit them. Can I change both parameters and receive a single notification in my quick action that they were both modified? What is the Data Miner way of handling this paradigm? I know that I can save them both at once but that still activates the quick action twice.
Hi,
The answers of Miguel an Tiago provide a means to store the values before processing them in one go. However, if the read parameters of 'Name' and 'Rank' are re-used then it might become confusing if these displayed values are now the ones that are the actual values from the data source or the ones that are pending to be set. The solution to bulk set 'Name' and 'Rank' for one row is to use the custom context menu on the table and use dependencyValues.
Define the custom context menu parameter with the following options:
<Discreet options="table:singleSelection" dependencyValues="2013;2014">
<Display>Bulk Set...</Display>
<Value>bulkset</Value>
</Discreet>
-SingleSelection means that a row first need to be selected to be able to see the context meu item, else the QAction would not be aware for which row the values need to be set.
-DependencyValues means that there will be a pop-up shown where the write parameters with id 2013 (e.g. Name parameter) and 2014 (e.g. Rank parameter) will be shown that can be filled in. The values that are filled in this pop-up menu will then be passed to the QAction in one go and can be processed. By working with dependencyValues it will not conflict with the existing read values that are displayed in the table.
More info about the custom table context menu can be found here
Regards,
Hi William,
You can use the context menu feature to select the rows that will be processed by the QAction. Please refer to the documentation: https://docs.dataminer.services/develop/devguide/Connector/UIComponentsCustomTableContextMenu.html
Define your context menu parameter with the following discrete option and add its ID as a trigger for the QAction:
Please note that only the keys of the selected rows are passed as an object to the QAction. You will then need to retrieve the values, e.g.:
Hi William,
A possible option for your use case is to have an extra column that contains a button. A user can edit the columns 'Name' and 'Rank' at any time but only after pressing the button you could execute the QAction.
Hope it helps!
This wouldnt work across rows as the table needs to refresh after the update
This feels like a work around rather than making the tables work. I think SLC should look into a table trigger or something that fires when the save all parameters dialog is confirmed on a table