Skip to main content


Adaptive Insights LLC.

Add Element Labels to Reports

Explains how to add element labels to OfficeConnect reports.

After adding queries to your report,associated labels become available (see the following).

Add This Query And This Label Becomes Available With This Label Type Value
Level Level Structure {Level Structure Name}
Version Version {Version Name}
Custom Dimension Dimension. For example, Customer or Product {Dimension Name}
For example, {Customer Name} or {Product Name}
Currencies Currency {Currency Code}}, {Currency Name}

To add a label for the level, version, or dimension:

  1. Select a blank row or cell, preferably near the column query headings.
  2. From the OfficeConnect tab, Design group, select Labels.The Label Definition dialog box appears.

    In the Label Types box, notice that the label types are now available for the level, version, or dimension queries you’ve added to your report. These label types becomes available only after you add those specific query elements to your report.
  3. In the Label Types box, select the name of the label type you want to use. For example, Level Structure or Version.
  4. In the Label Type Values box, select the label value you want to add to your report. For example, {Level Structure Name} or {Version Name}.
  5. Click Add Expression and click OK.
  6. Select Refresh.
    The label reflecting your new query now appears in the selected row or cell. See Adding an Adaptive Label to a Report for more information.

When you add, change, or remove query elements, any associated labels are also changed or removed as soon as you refresh the report.

See Adding, Changing, or Removing a Query for more information about changing or deleting query elements.

  • Was this article helpful?