Embed business intelligence into your applications so that your users can ask and answer sophisticated questions of their data. Typically, your application will include customizable dashboards that provide insight into data from Business Intelligence models known as cubes.
In contrast to traditional BI systems that use static data warehouses, Business Intelligence is kept closely in synchronization with the live transactional data, as required for your business.
Read all about it — developers
Using the Analyzer (a Business Intelligence tool that lets you create pivot tables)
Using InterSystems MDX (MultiDimensional eXpressions query language)
InterSystems MDX Reference