Previous Page | Next Page

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

Previous Page | Next Page | Top of Page