Analyze and Manage Data with MDX
MDX (Multidimensional Expressions) is a powerful data manipulation and querying language.
With MDX, you can:
-
Query and report against data and metadata in Essbase cubes
-
Insert data into an Essbase cube
-
Export data from an Essbase cube
An MDX query is a single MDX statement, having exactly one result set, that applies to a single cube.
An MDX report is a single MDX query, saved in the cube context. You can access MDX reports from Smart View and from the Essbase web interface.
An MDX script is a file, with an .mdx
extension, that you can upload and then run from Jobs or in Smart View. Only MDX Insert and Export statements should be used in MDX scripts. To analyze grid data, use MDX reports rather than MDX scripts.
Topics: