Thanks for your feedback.
Want to tell us more? Send us an email to leave your feedback.
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.|
Thanks for taking the time to give us some feedback.
Why wasn't this helpful? (check all that apply)
Vielen Dank, das Sie sich die Zeit genommen haben, uns Ihr Feedback mitzuteilen.
Warum waren diese Informationen nicht hilfreich? (Zutreffendes bitte auswählen)
Merci de nous avoir accordé un peu de votre temps.
Pourquoi ne vous ont-elles pas été utiles ? (cochez tous les choix applicables)
Grazie per avere dedicato del tempo per fornirci un tuo commento.
Perché non è stato utile? (selezionare tutte le risposte adeguate)
Gracias por dedicar su tiempo a proporcionarnos sus comentarios.
¿Por qué no ha sido útil? (Marque todos los que correspondan)
Obrigado por aproveitar o tempo para nos dar alguns comentários.
Por que isso não foi útil? (marque todas as que se aplicam)
피드백을 위해 시간 내 주셔서 감사합니다.
도움이 되지 않은 이유는 무엇입니까? (해당되는 모든 사항 선택)