Essbase - MDX

> Database > Oracle Hyperion - Essbase

1 - About

When creating formulas for an aggregate storage database, you use MDX.

MDX is a standardized query and calculation language for multidimensional databases such as:

  • Essbase,
  • Microsoft Analysis Services,
  • and SAP BW.

When the aggregate storage option was added to Essbase, MDX was chosen over the Calc Scripting Language in order to embrace the industry-standard query methodology.

Although formulas created in MDX can be used only for aggregate storage databases, MDX can be used to query any Essbase database—block or aggregate storage. This is because the syntax and functions described in this section are universal, regardless of whether they are used in formulas or queries.

MDX request can be passed into Smart View via the Execute Free Form MDX.

The Administration Services console also includes an MDX editor and viewer. Follow these steps to create a sample MDX query using the Administrative Services console:

  • In the Administration Services console, select File | Editors | MDX Script Editor.
  • In the text editor, type a MDX query such as:
SELECT [YEAR].Children ON ROWS, 
[Profit].Children ON COLUMNS 
FROM [Sample].[Basic] 
WHERE [Actual]
  • From the menu bar, select MDX | Execute Script.

2 - Documentation / Reference

failed to fetch data: unkown error

Advertising