About Metadata Loop Components

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