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.