Create and Edit Transactional Reports

Starting in Strategy (October 2026), you can set advanced properties (also known as VLDB properties) for your transactional reports.

Use transactional reports to perform write-back operations to a database to enable real-time updates and interactions with data.

1. Open the Workstation page.

2. In the Navigation pane, click Objects.

3. Click Create New Object and choose Transaction Report.

   To edit a transaction report, right-click the report in the Objects page 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. Starting in Strategy (October 2026), to define advanced properties for control over the analytical calculations and query generation:

   1. Click Properties.

   2. Locate the desired property.

   3. Expand the Property Value drop-down list and select the desired Property Value.

   4. Click Done.

9. Click Save .