MicroStrategy ONE

Accessing attributes and metrics in Freeform SQL reports

In the Freeform SQL Editor, you can create new attributes, attribute forms, and metrics on the fly to which to map the columns in the SQL statement. These new objects are managed objects. Alternatively, you can use existing attributes (including project attributes) to map the columns in the SQL statement.

You can access managed attributes and metrics in the following ways:

  • Search for Objects: If you use the Search for Objects function in MicroStrategy Developer, make sure to select the Display Managed Objects option (in the Search for Objects dialog box, select Options from the Tools menu) so the managed objects will be displayed in the search result. In the search result you can delete, rename, or edit any one of the managed objects by right-clicking its name.

  • Report Editor: Managed objects can also be accessed from the Report Editor of a Freeform SQL report. Just right-click the object name and select an option for the object, for example, Remove, Edit, Search for dependents, or Properties.

  • Freeform SQL Editor: Managed objects can be viewed through the Freeform SQL Editor, when you are defining a Freeform SQL report. The Object Browser displays a Freeform Objects folder that contains all the managed objects created for all your Freeform SQL reports and Query Builder Reports, regardless of which database instance is used for which report. These objects do not have mappings outside of the Freeform SQL reports and Query Builder reports; therefore, they cannot be used in any standard reports; they can only be used in Freeform SQL reports and Query Builder reports. Right-click the object name and you can search for its dependents or check its properties.

When you delete a Query Builder report, all the associated managed attributes and metrics are not deleted automatically. You must use the Search for Objects function to make the deletion.

For more information on managed objects, refer to the Creating Freeform SQL Reports and Query Builder Reports chapter in the Advanced Reporting Help.