Local Consolidation
Relational only
The Local Consolidation view specifies the default settings and the allowed members used on the Local Consolidation form.
You can choose which data is calculated when the consolidation process is run. This is set through the off-grid member of the Accumulation Method dimension. To default to a year-to-date consolidation, set the off-grid member to Year-to-date. To default to a periodic consolidation, set the off-grid member to Periodic.
The ConsolForm=Local parameter must be included. This parameter is required to have the ConsolidationForm.aspx page display as the Local Consolidation page.
Dimension information
The Schedules on the Local Consolidation page are the children of the Schedule.Master member.
| Dimension specifications | Applicable dimensions |
|---|---|
| Use allowed members to limit selection | Category
Other Period Period / Year Schedule Unit Version Year |
| Set on-grid members to specify a default selection | Category
Other Unit Version |
| Set drill mode to Member Select to allow user selection | Category
Other Period / Year Unit Version |
| Set the Dimension Bar layout to Display Button, Display Label, and Member on Label | Category
Other Unit Version |
| Not used | Accumulation Method Adjusted State |
Detail information
Page: ConsolidationForm.aspx
View: CT FP Local Consolidate
Dimension information
- The Schedule lines on the Local Consolidation form are the children of a schedule in the Schedule.Master hierarchy. When setting schedule lines as Allowed Members, you also need to Include Base Member (schedule name) in order for the Local Consolidation to run.
- The off-grid member for the Currency dimension (if present) must be set to the untranslated currency member (in the CTrain database, this is Local).
- The off-grid member for the Rate Set dimension (if present) must be set to the untranslated rate set member (in the CTrain database, this is Untranslated).
Example
/CPM/Workstation/ConsolidationForm.aspx?View=CT FP Local Consolidate&ConsolForm=Local