Populating Additional Metadata Objects - OLAP

Some of the metadata objects in an analytic workspace can only be populated after loading the data. Since you are creating a standard form analytic workspace, you can use the same OLAP DML programs as the DBMS_AWM package. These programs are stored in an analytic workspace named AWCREATE, which is owned by SYS. You can access the programs by attaching the workspace with this OLAP DML command:

AW ATTACH sys.awcreate

This chapter describes two programs:

  • ___POP.FMLYREL populates the member_gid variables and member_familyrel relations.
  • ___ORDER.HIERARCHIES populates the default_order variables. The program names have three initial underscores.

Using ___POP.FMLYREL

The ___POP.FMLYREL program populates the member_gid variable and member_familyrel variable for a dimension of a data cube. You must execute ___POP.FMLYREL for each dimension. Use this syntax to call ___POP.FMLYREL:

CALL ___POP.FMLYREL(aw, aw!dim, aw!dim_HIERLIST, aw!dim_LEVELLIST,aw!dim_LEVELREL, dim, aw!dim_PARENTREL, aw!dim_INHIER)

Where:
aw is the name of the analytic workspace.
dim is the name of a dimdef dimension.

All arguments are text expressions, so you must enclose literal text in single quotes. Use all upper-case letters for the arguments. For an example, see "Populating Additional Standard Form Metadata Objects".

Using ___ORDR.HIERARCHIES

The ORDR.HIERARCHIES program populates the default_order attribute of a data dimension. You must run it for each dimension of a data cube. Use this syntax to run ORDR.HIERARCHIES:

CALL ___ordr.hierarchies('aw!dim', 'aw!dim_HIERLIST','aw!dim_HIER_CREATEDBY', 'dim_PARENTREL', 'dim_ORDER', 'dim_INHIER')

Where:

aw is the name of the analytic workspace.
dim is the name of a dimdef dimension.

All arguments are text expressions, so you must enclose literal text in single quotes.Use all upper-case letters for the arguments.


All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

OLAP Topics