About Metadata Loop Components

Note:

Metadata loop components can be used in Oracle Hyperion Planning and Oracle Essbase block-storage, custom templates.

Metadata loop components enable you to assign a value to multiple members using either a function (Metadata) or a start and end value (Fixed).

For example, you may want to assign #missing to all the "level 0" accounts under the parent "Gross Profit". In this example, you would select the following in the metadata loop:

• Dimension—"Account"

• Function—@RELATIVE("GP",0)

• Variable—A "member" type design-time prompt