MDX Language

Function Libraries

Semantic

VBA

Comments

MDX functions - which are predominantly semantic methods - are available in Pyramid when working with Microsoft Multidimensional (OLAP), Microsoft Tabular, and SAP BW data models.

  • Many of the main MDX methods work in SAP BW infocubes and BEX queries , however, not all are functional. (Please see the compatibility notes on each function).
  • Further, Microsoft VBA functions are generally not available in SAP BW. Instead, there is a small library of common functions available in SAP BW itself. Please see your BW documentation for more detail.

A deep, full explanation of MDX is beyond the scope of this topic. For greater insight into its function and operation, please review MDX help from Microsoft and SAP.