Freeform SQL Essentials


Book Description

The MicroStrategy Freeform SQL Essentials course covers how to use Freeform SQL reports in a design concepts as well as knowledge of SQL. You will learn how to create and use Freeform SQL reports, including working with managed objects, incorporating prompts, using derived and common table expressions and stored procedures, accessing non-relational data sources, and configuring security.MicroStrategy project. The course assumes an understanding of basic report development and project







Basic Reporting Guide for MicroStrategy 9.5


Book Description

The Basic Reporting Guide provides instructions to get started with MicroStrategy Desktop and MicroStrategy Web, and how to analyze data in a report. It includes the basics for creating reports, metrics, filters, and prompts.







Basic Reporting Guide for MicroStrategy Analytics Enterprise


Book Description

The Basic Reporting Guide provides instructions to get started with MicroStrategy Desktop and MicroStrategy Web, and how to analyze data in a report. It includes the basics for creating reports, metrics, filters, and prompts.







Engine Essentials


Book Description

The MicroStrategy Engine Essentials course explains the inner workings of the MicroStrategy Engine. In this course, you will study specific reporting scenarios and the MicroStrategy Engine’s techniques for composing the SQL queries that produce MicroStrategy reports. You will study concepts such as level metrics, transformation metrics, custom groups, and relationship filters from a SQL point of view. The course also reviews the most commonly used VLDB Properties.




Customization Essentials for MicroStrategy Web SDK


Book Description

The MicroStrategy Web SDK Customization Essentials course teaches basic customizations of MicroStrategy Web™ using the MicroStrategy SDK. Topics covered include MicroStrategy Web architecture, the MicroStrategy Web Customization Editor, Web beans, essential configuration files, and the MicroStrategy Developer Library.







Project Design Essentials for MicroStrategy Architect


Book Description

The MicroStrategy Architect: Project Design Essentials course covers how to create a MicroStrategy project in MicroStrategy Architect™. First, students will learn how to design a logical data model and physical schema for the data warehouse. Next, students will learn about the project creation process, including how to use Architect graphical interface to work with tables, facts, attributes, and user hierarchies to create a fully-functioning project.