Databases Reference
In-Depth Information
MDX functions for ASO
As we said earlier, the MDX data query language is a useful tool in its own right.
In most cases, the MDX language has equivalent functions for each member set
function found in the Essbase Calculation Script language or the Essbase report
script language. The following screenshot shows the complete list of MDX data
query functions available:
Now, look at the functions listed here. They look like a hybrid between
Essbase member selection functions and typical SQL functions found in
any relational database.
Unfortunately, after all of the hard work we've been through getting you to think
and act like an Essbase programmer/administrator, we don't want you to slip back
into the relational way of thinking. This is only acceptable when querying an ASO
database, because it is indeed set up somewhat similar to a relational database in
terms of data structure.
