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,
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