MicroStrategy ONE

Steps to replace an object mapped to a column

You can replace an object mapped to a column with a different existing object. This can be helpful if you previously used managed object attributes to map your Freeform SQL data, but now you want to use project attributes that are part of your relational schema.

Prerequisites

  • The procedure below assumes you have already created a Freeform SQL report.

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

To replace an object mapped to a column

  1. Access the Freeform SQL Editor (How?)

  2. In the Mapping pane (the bottom pane on the right), right-click the row for the object you want to replace, and select Replace. The Select an Object dialog box opens.

  3. Select an object that you want to use and click OK. All references to the original object are replaced with the new object.