Strategy ONE

Create Transactions in Grids

Starting in MicroStrategy 2021 Update 6, you can create transaction grids for dashboards. This allows you to add, edit, or remove data from relational databases using the provided column mapper or your own defined SQL statements. Transaction grids for dashboards should be configured on live datasets.

To configure transaction grids in dashboards, you must at least have the Web configure Transaction privilege.

To interact with or use transaction grids in dashboards, you must at least have the Execute Transaction privilege.

Check out the video below to learn more!

Configure a Transaction Grid

  1. Open a dashboard.

  2. In the top toolbar, click Visualization .

  3. Choose Grid > Grid (Modern).

  4. In the Editor panel, add your rows and columns.

  5. Click More in the upper right corner of the visualization and choose Configure Transaction. Starting in MicroStrategy ONE Update 11, under Format Panel > Transaction Configuration tab > Configure Transaction, you can click Use SQL to start the configuration.

  6. Choose to update, insert, or delete data and click Add Table.

  7. Select a data source.

    The user selected to configure the data source must have permissions to update, insert, and delete data.

  8. Use the Object Browser panel to search for the desired attributes and metrics, and drag them into the Editor panel.

  9. To personalize the submissions settings, do one of the following:

    1. Click Settings in the upper right corner of the transaction configuration dialog to personalize the submission settings.

    2. Starting in MicroStrategy ONE Update 11, in the Format panel > Transaction Option tab, you can click More next to Transaction. Click After Submission and personalize your submission settings.

  10. Click Input Configuration to set rules and select the control type for your columns.

    1. Column selection and requiredness

    2. Data type selection

    3. Control type selection and configuration

      Textbox controls:

      For the Textbox control type, depending on the data type, number and string based configurations are provided with corresponding validations. Starting in MicroStrategy ONE Update 11, the text box input control supports line breaks when the data type is VarChar or NVarChar and no validation is defined for the text box.

      For most update and insert data cases, you can click Enter to start a new line. In bulk editing mode in Library and Workstation, you can click Alt + Enter for Windows or click Option + Enter for Mac (Library only) to start a new line.

      For the switch control type, both switch and checkbox styles are supported.

      For the Dropdown list control type, calculated list, manual input list, and a data driven input control list is supported. For the Calculated list, you can set the value range and interval size.

      For manual lists, you can define labels to display the data.

      From the DDIC (data driven input control) dropdown list, you can choose any dataset in the dashboard, an attribute from that dataset, and pick display attribute forms and the attribute form to write back.

  11. Click Done to complete your transaction and Save your dashboard.

  12. You can pause transaction manipulations to apply configuration changes. Perform one of the following:

    1. Click More in the upper right corner of the visualization and choose Edit Transaction. In the transaction configuration dialog, toggle the action that you want to pause.

    2. Select the grid. In the Format panel under the Transaction tab, toggle the action that you want to pause.

    3. Click More in the upper right corner of the grid. Choose Pause Actions then select the check box of the action that you want to pause.

Filter elements displayed in Transaction dropdown lists

Dynamically filter a Transaction element dropdown list using an Element Filter or a visualization. This feature enables users to limit the elements shown in the Transaction Services dropdown control based on a filter applied to the modern grid visualization. This streamlines the data entry experience for end users and reduces error rates when submitting transactions.

Filter using an Element Filter

  1. In the top toolbar, click Filter and choose Element/Value Filter. An empty selector is added to the dashboard.

  2. Drag the attribute to use as a filter from the Datasets panel.

  3. Click Select Targets.

  4. Click the Transaction Grid.

  5. Select the column in the grid that you want to allow the selector to filter and click OK.

  6. Click Apply.

Filter using a visualization

  1. Add a source visualization to the dashboard.

  2. Click More in the upper right corner of the visualization and chooseSelect Target Visualizations.

  3. Click the Transaction Grid.

  4. Select the column in the grid that you want to allow the selector to filter and click OK.

  5. Click Apply.

Related Topics

KB485696: Add automatic fields to transactional grids in dashboards