MicroStrategy ONE

Mapping a new attribute form to a column

You can map a column in the SQL statement to a new attribute form in the MicroStrategy environment. By default, every newly added attribute takes the ID form, but you can change that by using the Forms drop-down list in the Mapping pane (the bottom pane on the right) of the Freeform SQL Editor.

Prerequisites

  • The procedure below assumes you have already created a Freeform SQL report and it is open in the Freeform SQL Editor.

  • You must have the Define Freeform SQL report and Create schema objects privileges to access and use the Freeform SQL Editor.

To map a new attribute form to a column

  1. From the Mapping menu, select Add New Attribute Form. An attribute form is inserted into the Mapping pane.

  2. Type in the object name of your choice and make the selection for Form, Type, Data Type, Precision/Length, and Scale. Every attribute must map a column to the ID form.

  3. Ensure that the column number for the object matches the order of the column in the SQL statement. For example, an object is to be mapped to the second column listed in the SELECT clause. In the Mapping pane (the bottom pane on the right), the object must be included as column 2. You can use the Move Up and Move Down options in the toolbar to change the column position of an object.

    • If you use a stored procedure, it is important that you know its content in advance, including what exact columns the stored procedure retrieves. Otherwise, it may be difficult for you to correctly map the columns retrieved.

    • Use the ODBC Test Tool to test the validity of the stored procedure before creating any Freeform SQL report.

Related Topics