The OLAP Procedure

Syntax: OLAP Procedure

PROC OLAP <option(s)>;

METASVR OLAP_SCHEMA='schema-name' <option(s)>;

DIMENSION dim-name HIERARCHIES=(hier-nam ... hier-nameN) <option(s)>;

LEVEL level-name <option(s)>;

PROPERTY prop-name LEVEL=level-name <option(s)>;

HIERARCHY hier-name LEVELS=(level-name1 <level-name2 ...level-nameN>) <option(s)>;

MEASURE measure-name STAT=statname <option(s)>;

AGGREGATION level-name <level-name2 level-name3 ...level-nameN> / <option(s)>;

DROP_AGGREGATION level-name1 < level-name2 ...level-nameN> / NAME=aggregation-name ;

DEFINE MEMBER | SET'member-or-set-name' AS 'mdx-expression' ;

UNDEFINE MEMBER | SET 'member-or-set-name' ;

USER_DEFINED_TRANSLATIONS locale <locale2 ...localeN> ;

REORGANIZE_LEVEL | REORG_LEVEL