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 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