How
to create a Freeform SQL Report in MicroStrategy Desktop 8.x and 9.x. ?
The editor to create a
Freeform SQL report in MicroStrategy Desktop 9.x no longer has the Freeform SQL
template under the general section when creating a new report.
In MicroStrategy 8.x, the following
templates could be selected from in order to define a new Freeform SQL report:
However, when defining a new report
in MicroStrategy Desktop 9.x the following options are available:
The option to define a Freeform SQL
report has been moved into the "ODBC Sources" tab of this window, as
shown below:
By enabling the radio button to
"Use Freeform SQL Editor" a new Freeform SQL report can be defined.
How many types of engines available in MSTR?
3 Main engine
SQL Engine - to generate query
Query Engine - SQL code to Db
Analytical Engine -for advance analytic s function
Apart from this
•Server Delivery Engine for Narrow cast
• Security Engine – manages user authentication and authorization
•Object Browsing Engine – presents
the folder navigation of the BI applications
• Prompting Engine – manages the presentation and resolution of prompts
• Resolution Engine – interprets business definitions for efficient execution
• Command Engine – manages all engine capacities and job queues.
• Cache Management Engine – retrieves report data from caches and history lists
• Dynamic SQL Engine – generates optimized SQL for relational data sources
• Dynamic MDX Engine – generates optimized MDX for multidimensional cubes
• Free form SQL Engine -- bridges business definitions with relational data sources
• Formatting Engine – adds rich formatting and converts results to the required output format
• Monitoring Engine – displays and logs current Intelligence Server activity
• Scheduling Engine – gathers and runs reports attached to time and event schedules
• Prompting Engine – manages the presentation and resolution of prompts
• Resolution Engine – interprets business definitions for efficient execution
• Command Engine – manages all engine capacities and job queues.
• Cache Management Engine – retrieves report data from caches and history lists
• Dynamic SQL Engine – generates optimized SQL for relational data sources
• Dynamic MDX Engine – generates optimized MDX for multidimensional cubes
• Free form SQL Engine -- bridges business definitions with relational data sources
• Formatting Engine – adds rich formatting and converts results to the required output format
• Monitoring Engine – displays and logs current Intelligence Server activity
• Scheduling Engine – gathers and runs reports attached to time and event schedules
What is mean by Report , Template , Report Filter and View Filter?
Report:
A report is a request for specific, formatted data from the data warehouse.It consists of a template plus any desired filtering criteria
Template:
A template specifies what information to retrieve from the data warehouse and how this information will be displayed in the report results.
Report Filter:
A report filter specifies the condition that data must meet to be included in the report results.
View Filter
A view filter enables you to create a filter on the fly , based only on those objects that exist in the report objects window. View filters do not appear in the report sql .
