Reference: Report Label Types and Values
Some label types are available to all reports by default. As you build your specific reports using the elements from the Reporting pane, additional label types become available based on the applied elements.
Types of Labels | Description |
Time | The calendar defined for the instance. |
Account | The GL account code or account name. Example: 3900 or Net Income. If your model has contra accounts, you can use the {Account Contra Indicator}
label type value to identify these accounts in the report. After you refresh, an
indicator appears next to all contra accounts in the report. The indicator also
displays in the Review tab for Cell, Row, Column,
Worksheet, and Workbook nodes. |
Level | The full name or short name for the level applicable to the report. Example: Co. A or Company A (100% owned). This label is useful when you filter the report data by level. The label indicates the level by
which the data filters. |
Version | The version name for the version applicable to the report. Example: Actuals This label is useful when you filter the report data by version. The label indicates the version
by which the data filter. |
Currency | The currency code or currency name for the currency applicable to the report. Example: USD or United States of America, Dollars This label is useful when you filter the report data by currency. The label indicates the
currency by which the data filters. |
Attribute | The full name and short name for the attribute element added to the report. Example: Level Name and Level Short Name |
Dimension | The full name and short name for the custom dimension added to the report. Example: Customer Name and Customer Short Name |
Context | The time context name. Example: Quarter to Date |
System Variable | See System Variable Label Type in this article. |
System Variable Label Type
The System Variable label type includes values that are based on your OfficeConnect workbook
properties and your local system settings.
Label type value | Description |
Workbook Name | The reporting workbook filename. |
Creation Date | The reporting workbook creation date. |
Creation Time | The reporting workbook creation time. |
Last Modified Date | The date when you last saved the workbook. |
Last Modified Time | The time when you last saved the workbook. |
Last Refresh Date | The date when you last refreshed the workbook. |
Last Refresh Time | The time when you last refreshed the workbook. |
Magnitude | The Round to setting for the workbook such as Hundreds, Thousands.Example: If the actual value for an account is 1,500 and you set the rounding to display in
thousands, the report displays the value as 1.5 instead of 1,500. The magnitude label can return "in thousands" to indicate that the report displays values in thousands instead of the actual value. |
Repeating Report Element | The element that determines how to break out the reporting data into multiple worksheet tabs. Example: If you use level as the repeating report element, the report has separate tabs for each child level. The label indicates the element used to create the repeating reports or tabs. |
Report Date (Long) | Specified in the workbook properties and in the format of September 29, 2014 |
Report Date (Numeric) | Specified in the workbook properties and in the format of 09/29/2014 |
Report Date (Short) | Specified in the workbook properties and in the format of September 2014 |
System Date | The date as per your computer settings |
System Time | The time as per your computer settings |