About This Book
This book provides information on the MDX expressions, statements, and functions supported in InterSystems IRIS Business Intelligence. It contains the following sections:
For a detailed outline, see the table of contents.
The other developer books for Business Intelligence are as follows:
Introduction to InterSystems Business Intelligence briefly introduces Business Intelligence and the tools that it provides.
Developer Tutorial for InterSystems Business Intelligence guides developers through the process of creating a sample that consists of a cube, subject areas, pivot tables, and dashboards.
Implementing InterSystems Business Intelligence describes how to implement Business Intelligence, apart from creating the model.
Defining Models for InterSystems Business Intelligence describes how to define the basic elements used in Business Intelligence queries: cubes and subject areas. It also describes how to define listing groups.
Advanced Modeling for InterSystems Business Intelligence describes how to use the more advanced and less common Business Intelligence modeling features: computed dimensions, unstructured data in cubes, compound cubes, cube relationships, term lists, quality measures, KPIs, plug-ins, and other special options.
Using InterSystems MDX introduces MDX and describes how to write MDX queries manually for use with cubes.
The following books are for both developers and users:
Using Dashboards and the User Portal describes how to use the Business Intelligence User Portal and dashboards.
Creating Dashboards describes how to create and modify dashboards in Business Intelligence.
Using the Analyzer describes how to create and modify pivot tables, as well as use the Analyzer in general.
Also see the article Using PMML Models in InterSystems IRIS®.
The system provides an implementation of MDX. Results may differ from other implementations.
Accessing the Samples Shown in This Book
Most of the samples in this book are part of the Samples-BI sample (https://github.com/intersystems/Samples-BIOpens in a new window) or the Samples-Aviation sample (https://github.com/intersystems/Samples-AviationOpens in a new window).
InterSystems recommends that you create a dedicated namespace called SAMPLES (for example) and load samples into that namespace. For the general process, see Downloading Samples for Use with InterSystems IRIS.