Unit Contribution report
Financial Consolidation on Relational
The Unit Contribution report provides visibility to the adjustment and net consolidated data without having to run multiple audit and web reports. The Unit Contribution report uses a view for connection information and the allowed members.
A default report using the members specified in the view is generated when the task is accessed. The InitialLoad parameter enables you to bypass the initial load. The valid values for InitialLoad are Y or N. Add InitialLoad=Y to the URL for the page and the data is automatically loaded. If you skip the initial load, you must manually generate the report. The AutomaticReload parameter is used refresh the report after any selection is made. The valid values for AutomaticReload are Y or N. We recommend you set both parameters to N.
Dimension information
Schedule and Unit must be on-grid. The sample report is set up with the Unit dimension as the across dimension and the Schedule dimension as the down dimension. If you have a large number of units, you can switch the dimensions and have the Unit dimension down and the Schedule dimension across.
For the Currency dimension and the Rate Set dimension, do not include the untranslated member in the allowed members.
For the Schedule dimension, only schedule names (children) of the Schedule.Master hierarchy should be allowed. Line items are not allowed. The base member must be excluded.
For the Accumulation dimension, do not include the period-to-date member in the allowed members.
| Dimension specifications | Applicable dimensions |
|---|---|
| Use allowed members to limit selection | Accumulation Method
Adjusted State Category Currency Other Period Period / Year Rate Set Schedule Unit Version Year |
| Set off-grid members to specify a default selection | Accumulation Method
Adjusted State Category Currency Other Period Period / Year Rate Set Schedule Unit Version Year |
| Set drill mode to Member Select to allow user selection | Accumulation Method
Adjusted State Category Currency Other Period Period / Year Rate Set Schedule Unit Version Year |
| Set the Dimension Bar layout to Display Button, Display Label, and Member on Label | Accumulation Method
Adjusted State Category Currency Other Period Period / Year Rate Set Schedule Unit Version Year |
Detail information
Page: ContributionReport.aspx
View: CT FP Unit Contribution Report
Example
/CPM/Workstation/ContributionReport.aspx?View=CT FP Unit Contribution Report&InitialLoad=N&AutomaticReload=N