ABSTRACT

While MDX’s primary purpose is to retrieve data from multidimensional databases using structured queries, it also serves another purpose for Essbase developers: MDX is the mechanism used to dene member formulas for aggregate storage option (ASO) databases. Leveraging the functionality of a subportion of an MDX query known as the WITH MEMBER specication, MDX is used within an Essbase ASO outline to dene calculations that range from simple equations to very complex formulas.