Skip to main content
Adaptive Insights
Knowledge and Support - Adaptive Insights

Report Elements Descriptions

Describes the  elements available for selection when building a matrix report
Element Description
Accounts Includes all accounts of all types. At least one account is required in a Matrix report.
Time Includes all time periods in the current model and the following special time elements:
  • Period to Date: Used to quickly specify the time strata and period to date of your choice. By default, the root stratum is selected. 
  • Timespan: Used to quickly specify a range of time periods.  
  • Time range of versions on the report:  Selected by default. Used to include all of the dates in all of the versions in the report.
  • From/to: Used to select a range of any two leaf time periods in your structure.
  • Includes: Used to select the time strata for value aggregation, typically Month, Quarter and Year. If you are using a custom calendar, all of your time strata appear as choices.
If no time period is specified in a report, all months in the report version's time range are included by default.
Organization  Includes all levels visible to you. If no levels are specified on a report, the default is to use all levels visible to the person running the report.
Versions Displays all versions visible to you, including Actuals. If no version is specified, the current working version of the person running the report is used by default.
Currencies Displays all currencies that are configured in your instance. If no currency is specified, the default currency is used based on the following rules:
  • If your report contains data from only a set of levels that are in the same currency, the currency for the levels is the default.
  • If the report contains levels with different currencies, the Corporate Currency is the default. 
Display As Allows you to display numbers as:
  • Value: Display the numbers as their normal values.
  • % of Account: Display as the percentage of a selected account in the Account tree.
  • Custom: Allows accessing the Formula Assistant to create expressions that evaluate at the current intersection. This Formula Assistant is not restrained to the elements on the report. A Custom element can be placed on the same tier as the Display As % of Account element.   It is possible to write an IF expression to generate values in a single column using different formulas on different rows.
Account Attributes Includes all account attributes in the current instance.

Level Attributes 

Includes all level attributes in the current instance.
Dimension Attributes Includes all Dimension Attributes in the current instance.
Dimensions Includes all Dimensions in the current instance.
Calculations Includes mathematical calculations for creating subtotals of the numbers for other dimensional elements:
  • The subtotal of other elements 
  • The difference between the numbers of two other elements 
  • A method for establishing custom calculations for elements of a dimension. 
All of the calculation options apply within a report tier and do not cross tiers within a report. See Report Calculations for more information
Reusable Reports Report Building Blocks: Includes all reports the user has access to that have been flagged as Reusable Reports.
  • Was this article helpful?