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 a Freeform SQL report are:
Select File | New | Report. A new grid dialog box opens.
Select the Free Sources tab; on this tab, select or create the database instance using the new ODBC source.
Select create Freeform SQL report and click OK.
This opens...
