MicroStrategy ONE

Freeform SQL Editor toolbar options

The Freeform SQL Editor provides a set of toolbar icons to facilitate the tasks of creating Freeform SQL reports:

  • Show Object Browser: Shows or hides the Object Browser pane.

  • Undo: Cancels the most recent action taken.

  • Redo: Performs the most recent action that was undone.

  • Cut: Removes selected text from the SQL statement pane and keeps a copy in temporary storage. You can use the Paste option to copy the selected text to another location in the SQL statement pane.

  • Copy: Copies selected text from the SQL statement pane. You can use the Paste option to copy the selected text to another location in the SQL statement pane.

  • Paste: Inserts any copied text into the SQL statement pane at the cursor location.

  • Add New Prompt: Launches the Prompt Generation Wizard, which enables you to create a new attribute element list or value prompt and include it in your Freeform SQL statement, in the SQL statement pane. For information on including prompts in Freeform SQL reports, see Prompts in Freeform SQL reports.

  • Insert New Prompt: Enables you to browse for an existing attribute element list or value prompt and insert it into the Freeform SQL statement, in the SQL statement pane.

  • Add New Attribute Form: Inserts a new column in the Mapping pane, which enables you to map an attribute form to a column returned by your Freeform SQL statement. For information on mapping attribute forms to columns, see Mapping a new attribute form to a column and Steps to map an existing object to a column.

  • Add New Metric: Inserts a new column in the Mapping pane, which enables you to map a metric to a column returned by your Freeform SQL statement. For information on mapping metrics to columns, see Mapping a new metric to a column and Steps to map an existing object to a column.

  • Insert: Launches the Select an Object dialog box, which enables you to browse to an attribute or metric to map to a column of your Freeform SQL statement. For information on mapping objects to columns of your Freeform SQL statement, see Mapping columns to metadata objects.

  • Move Up: Moves the selected object to column mapping in the Mapping pane up one position in the column order, which decreases the column number. Objects mapped to columns of Freeform SQL statements must be mapped to the column that matches the order in which the column occurs in the SELECT clause.

  • Move Down: Moves the selected object to column mapping in the Mapping pane down one position in the column order, which increases the column number. Objects mapped to columns of Freeform SQL statements must be mapped to the column that matches the order in which the column occurs in the SELECT clause.

  • Delete: Removes the selected object to column mapping in the Mapping pane.

  • Rename: Places the cursor in the Object column for an object to column mapping in the Mapping pane, which enables you to rename the object mapped to a column. For information on renaming objects, see Steps to rename an object mapped to a column.