MDX Queries and Syntax

Basic MDX DDL Syntax

The SAS OLAP Server provides support for the MDX Data Definition Language (DDL). DDL enables users and administrators to manage the definitions of calculated members and named sets at either a session or a global level. Management of calculated members and named sets is provided by the CREATE and DROP DDL statements.

By using the CREATE DDL statement, a user can create definitions of calculated members or named sets for use within a client session or for use within a cube on a global scale. Here is the format for the CREATE DDL statement:

CREATE [global | session]   
  [MEMBER . AS '' |    
   SET  AS ''] . . .]

If GLOBAL or SESSION is not specified, then the default scope is SESSION. When a calculated member or named set is defined within the SESSION scope, the definition is available only for the lifetime of the user's client session. When a calculated member or named set is defined within the GLOBAL scope, the definition is permanently attached to the cube definition and is visible to all current and future client sessions.

By using the DROP DDL statement, a user can remove definitions of calculated members or a named set from use within a client session or from use within a cube on a global scale. Here is the format for the DROP DDL statement:

DROP [MEMBER . . . .] | 
     [SET ] . . .] .

When using the DROP statement, only calculated members or named sets can be dropped at the same time. However, a user cannot drop both calculated members and named sets in a single DROP statement.

Note: The name of the calculated member or named set must contain the cube name. [cautionend]

Top of Page