Advanced Reporting Guide

The MicroStrategy Advanced Reporting Guide provides comprehensive information on advanced topics for using the MicroStrategy query and reporting products. This guide builds on a basic understanding of information provided in the Basic Reporting Guide. Advanced topics include the following:

Introduction to Advanced Reporting, reviews the tasks and objects to create a basic report and previews advanced reporting concepts.
Advanced Metrics, explains level metrics, conditional metrics, transformation metrics, and compound metrics, which provide complex business measures and key performance indicators. Numerous examples provide real-life context for the explanations.
Advanced Filters: Filtering Data on Reports, describes how to create complex filters and how to apply them to reports.
Custom Groups and Consolidations, introduces and compares custom groups and consolidations and why to use each.
Drill Maps, describes how to customize drill paths to allow users to access additional information from reports.
Advanced Prompts: Enabling User Input, explains how to create dynamic report definitions through prompts.
Designing Reports, guides you through advanced reporting concepts in a hands-on way, providing a tutorial experience. The sample reports illustrate various reporting concepts such as the difference between report filters and report limits, while showing you how reports are built and generated. This section also introduces the concepts of the view definition and the data definition of a report, detailing the report execution steps that belong to each.
Graphing, discusses how to view, format, and manipulate MicroStrategy graph reports, introduces the graph styles available in MicroStrategy, and provides tips on how you can most effectively present your report data in a graph.
Displaying Information about Reports: Report Details, discusses how to customize the report details, which is the information that appears in the Report Details pane. For example, you can select whether to include view filter information or the attribute name in the filter details. For report details, you can choose whether to include information on prompts or filters.
Linking Reports and Documents, discusses how to create and use links. Links allow analysts to explore additional, related data by executing another document or report from within a document or report, in either MicroStrategy Developer or MicroStrategy Web. A link allows context to be passed to any prompted report or document, whether the destination report or document is related to the original.
Custom SQL Queries: Freeform SQL and Query Builder, discusses how to use Freeform SQL to access data from various data sources, including relational databases, Excel files, and flat files.
Accessing Subsets of Data: Data Marts, explains how to use relational tables known as data mart tables to create or update warehouse tables or integrate with third-party tools.
Data Mining Services, presents the data mining process, which leverages existing and historical data to create predictive models to project potential outcomes for business activities and transactions.
VLDB Properties, describes the most commonly-used VLDB properties relating to metrics and reports. VLDB properties allow you to customize the SQL that MicroStrategy generates.

You can also report on data returned from MDX cube sources such as SAP BW, Microsoft Analysis Services, and Hyperion Essbase. For information on integrating MicroStrategy with these MDX cube sources, see the MDX Cube Reporting Guide.

The appendixes contain the following information:

Logical and Mathematical Operators for Filtering, discusses operators and how to use them in filters and report limits.
Formatting Default Values, provides the default values for all the formatting options, to assist you in formatting reports and creating autostyles.
MicroStrategy Developer Commands, specifies the Developer commands used in MicroStrategy products, focusing on Developer home page usage and describing the commands from an HTML perspective.
Sorting and Browsing Standards, describes the sorting and browsing standards for characters and projects in MicroStrategy Developer and Web.
Using Secure Freeform SQL text prompts, describes how to define secure Freeform SQL text prompts to guard against malicious SQL injections.
Did you find this helpful?
Waren Ihnen die Informationen hilfreich?
Ces informations vous ont-elles été utiles ?
Questo contenuto ti è stato utile?
¿Le ha resultado útil?
Você achou isso útil?
도움이 되었습니까?