Creating Freeform Sql Reports Introduction - Microstrategy

The Freeform SQL functionality adds great flexibility to MicroStrategy’s query and reporting capabilities. Traditionally, you use the MicroStrategy Engine to generate SQL to run against one specific relational database to get a desired report. Starting from 8.0, in addition to generating reports in the traditional way, you can also use your own customized SQL statements to generate reports from operational systems included in a MicroStrategy project. This capability could save you a tremendous amount of work time since you do not need to place the data into a data mart or data warehouse first.

Freeform SQL This chapter discusses different aspects of the Freeform SQL functionality, including the following:

  • Freeform SQL reporting
    • When should I use the Freeform SQL reporting feature?
    • SQL query syntax
    • SQL support
    • Freeform SQL reports vs. standard reports
    • Freeform SQL reports in Report Services documents
  • Reporting features
    • Filters
    • Prompts
    • Drilling
  • Security for data access
    • Access control list
    • Security filters
  • Managed objects
  • Creating Freeform SQL reports
    • Creating a Freeform SQL report from a database
    • Creating a Freeform SQL report from an Excel file
    • Creating a Freeform SQL report from a text file
    • Creating a Freeform SQL report using a stored procedure

The following graphic is an illustration of the Freeform SQL Editor, where you define the SQL statement for the report. Notice the different panels for different purposes.

microstrategy


All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

Microstrategy Topics