Mastering Business Intelligence with MicroStrategy

Freeform SQL

Freeform SQL gives you full control over accessing data; you can run your query directly against a data warehouse, bypassing the MicroStrategy SQL engine. Using Freeform SQL, you can access data from several ODBC sources such as Excel flat files. After writing the query in the Freeform SQL editor, we create a managed object or map it to an existing attribute. It is good to use Freeform SQL while creating static reports, fetching data from other sources, or using OLTP tables that are not set up for OLAP analysis.

You can have element prompts or security filters on Freeform reports, but you cannot include custom groups, consolidations, transformations, and existing filters on the report.

Creating a Freeform SQL report

The steps to create ...