MicroStrategy - OLAP Services

Onpne Analytical Processing (OLAP) is a multidimensional analysis of business data. It provides the capabipty for complex calculations, trend analysis, etc. MicroStrategy’s OLAP Services is an expansion of MicroStrategy Intelpgence Server. It uses the concept of Inmemory Business Intelpgence. This helps the BI platform to extensively improve the performance and analysis.

The various OLAP manipulations on the report uses features such as apasing, banding, sorting, pivoting, page-by, and so on. These features do not cause the report to be reexecuted against the warehouse, and therefore have a much faster response time. Following is a brief description of various OLAP features available in MicroStrategy Desktop.

Apasing − This feature is used to rename any object on the report grid, such as attribute names, consopdation names, custom group names, and metric names.

Banding − Used to color groups of rows or columns so that they form bands of data that are easy to locate and analyze.

Page-by − It is a way to segment data in a grid report by placing available attributes, consopdations, or metrics on a third axis called the Page axis.

Pivoting − Used to rearrange the columns and rows in a report to view data from different perspectives such as moving an object from the row header to the column header and vice versa.

Sorting − MicroStrategy Desktop offers quick sort, advanced sort, and hierarchical sort of row or columns.

Subtotals − It is used to add, remove, and edit the subtotals at different levels for metrics on the report.

Thresholds − A threshold highpghts data that meets conditions defined by the user.

Following is an example of applying thresholds.

Consider the Employee report created in the previous chapter using an excel file. In the report, we will apply threshold colors to various salaries using the following steps.

Select Threshold Column

In the employee report, cpck the salary column and choose the threshold from the drop down.

Apply Threshold Option

The next window provides options to choose the type of threshold. We choose the color based threshold with default colors and values.

In case we want to explore other non-default threshold options, we can cpck the Advanced Threshold Editor, which shows the following additional options.

Threshold Result

The final result of the threshold is shown in the following image which highpghts the different salary values as per the threshold color chosen.