Edit Transactional Reports

Starting in MicroStrategy 2021 Update 9, you can edit transactional reports.

1. Log into an environment.

2. Use the Workstation window to navigate to your transactional report.

3. Right-click the transactional report and choose Edit.

4. Right-click in the SQL Editor to define new input for transactions with either an existing attribute or metric, or by creating one.

   

   A new line for the transaction appears.

5. Depending on the option you chose, you can either define new objects or search for existing ones.

   For existing objects you can also use drag objects from the left pane.

   

6. From the right side of the editor you can choose Insert Prompt or Insert Conditions.

Only value prompts are supported



7. A new section appears where you can define:

   • Value prompts

     

   • Conditions

     

8. Click Save .