Consolidation parameter summary
This table shows a brief overview of the consolidation parameters.
The parameter names appear alphabetically according to the parameter name. If there is no parameter name, then the property name is used. If there are multiple sources, any alternate names are listed in parentheses. Click the parameter name to go to the section containing detailed information.
| Parameter | Description |
|---|---|
| AbortOnZeroExchangeFactor | Determines whether to continue a consolidation request if an exchange rate value is null (missing) or zero. |
| AggregateMissingData | Determines whether to prevent data submitted to a consolidated member from being aggregated to its ancestors. |
| CalculateFromStoredData | Determines whether existing data values in closed periods (outside the focus range or selected data slice) are re-evaluated or read from the database during a consolidation. |
| ConsolidationPassesNeeded | Performs the selected number of consolidation passes. |
| CrossProductThreshold | Specifies the minimum number of input sheets in one consolidation pass that is required before using a Select Distinct SQL query to assist in retrieving data entry values. |
| DefaultExchangeFactor | Applies the specified exchange rate factor to any null rate record. |
| DoLocalAuto | Determines whether to run a local consolidation before consolidating target currencies. |
| IncludeOffSheetLines | Determines whether to read local reported values for off-sheet lines all at once (and translate the values) or one at a time (and use existing translated values). |
| LargeConsCount | Controls the number of large consolidations allowed to run concurrently on a server. |
| LargeConsThreshold | Defines a large consolidation for the LargeConsCount parameter. |
| LevelDepth | Determines whether to start a level depth consolidation to avoid reconsolidating certain data. It is used in conjunction with the SuppressLeafProcessing parameter. |
| Local | Determines whether to run a local consolidation or a currency consolidation. |
| ManagerialOwnershipRollup | Determines whether the consolidation engine rolls up data to parent consolidation nodes in the Architect structure for a legal unit that does not share the same consolidation node parent as the unit that holds it and for which no calculated rollup percentage exists. |
| MaxOSRCacheRecords | Controls the number of records kept in the off-sheet reference cache before clearing the cache. |
| MeteringInterval | Determines how frequently the consolidation status dialog box should refresh during the consolidation and controls the consolidation progress entries written to the log file. |
| PointConsolidation | Determines whether to run a normal consolidation or a point consolidation (writes data back to the database only for the selected member and, optionally, its leaf members). It can also be used with the SuppressLeafWriteBack parameter. |
| ProcessUnsubmittedStatements | Determines whether to process all in-scope leaf member combinations or only those with data during a consolidation. |
| ReadConsMemberP0 | Determines whether to read P0 data for consolidation members from the database. |
| ReadSubmittedConsNodes | Determines whether to process local data submitted directly to non-leaf members (except for the Period dimension). |
| Report_FocusRange_Warnings | Determines whether to warn a user when any specified period for a consolidation is outside the focus range. |
| RollupLocalExchange | Determines whether the consolidation engine rolls up any dimensions beyond the unit level in the local, untranslated view. |
| SkipAllocationFormula | Determines whether to evaluate allocation formulas (type "A" lines) when evaluating other formulas for translated currencies during a consolidation. |
| SuppressLeafProcessing | Determines whether to consolidate leaf members within the scope of a level depth consolidation or to read and roll up existing data. It is used in conjunction with the LevelDepth parameter. |
| SuppressLeafWriteBack | Determines whether to suppress writeback to leaf members. |
| SuppressThreading | Determines whether to use a single thread to read data from and write back to the database. |
| SyntaxCheckOnly | Determines whether to run a consolidation or test the syntax of the consolidation request. |
| UnitHierarchy | Names the unit hierarchy for referencing the ownership properties of a unit being consolidated. |
| UseNetOffsheetData | Evaluates adjustment data and net data for formulas whose sources are not part of the consolidation scope but have been adjusted. |
| YTD | Determines whether to produce year-to-date data in addition to the periodic data during a consolidation. |
| ZeroSuppression | Determines whether to insert records that contain a mixture of zero and null values. This parameter has no effect on adjusted or net adjusted data. |