The OLAP Procedure
- Syntax
Procedure SyntaxPROC OLAP StatementMETASVR StatementDIMENSION StatementUSE_DIMENSION StatementHIERARCHY StatementLEVEL StatementPROPERTY StatementMEASURE StatementAGGREGATION StatementDROP_AGGREGATION StatementDEFINE StatementUNDEFINE StatementUSER_DEFINED_TRANSLATIONS StatementREORGANIZE_LEVEL Statement - Overview
- Using
Syntax
PROC OLAP <option(s)>;
METASVR OLAP_SCHEMA='schema-name' < option(s)>;
DIMENSION dim-name HIERARCHIES=(hier–nam ... hier-nameN)
<option(s)>;
<option(s)>;
USE_DIMENSION [dim-name |
"/folder/dim-name"] [OLAP_SCHEMA=schema-name ]
FACTKEY=fact-key column;
FACTKEY=fact-key column;
HIERARCHY hier-name LEVELS=(level–name1 <level–name2 ...level-nameN>)
<option(s)>;
<option(s)>;
LEVEL level-name <option(s)>;
PROPERTY prop-name LEVEL=level-name<option(s)>;
MEASURE measure-name STAT=statname <option(s)>;
AGGREGATION level-name <level-name2 level-name3 ...level-nameN> /
<option(s)>;
<option(s)>;
DROP_AGGREGATION level-name1 < level-name2 ...level-nameN> /
NAME=aggregation-name;
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 level-name