- You create a Multidimensional Expressions (MDX) script that contains custom calculations for a cube in Microsoft SQL Server Analysis Services (SSAS).
- You connect to the instance of Analysis Services from a client application. For example, you connect from Microsoft Excel.
- You create an MDX query that contains subselect expressions in the client application. To do this, you use multi-select filtering, for example.
- The hierarchy elements of the dimensions form an arbitrary shape set.
Note An arbitrary shape set is a set that cannot be easily expressed as a crossjoin set of two sets of attribute members. An example of an arbitrary shape set is the following:
Article ID: 3107431 - Last Review: Feb 14, 2017 - Revision: 1