The income statements are analyzed by comparing different Scenario and Year combinations. For example, variance can be calculated between Actual 2010 and Actual 2009.
The report provides tabular view of the income statement information for the particular scenario such as: Actual, Plan, or Forecast. The report helps you to analyze the changes in the income statements across different scenario and year dimension combinations.
To compile the Profit and Loss Variance Analysis report:
From the Oracle BI EE Global Header, select the Dashboards link, then select the OFMA menu list, and then select Oracle Financial Management Analytics.
From Oracle Financial Management Analytics, select the Profit and Loss dashboard tab.
From POV Selector, select the required POV dimensions that you want to use for the dashboard, and then click Apply.
See Setting the Point of View in Oracle Financial Management Analytics.
In the Variance Analysis POV selector, select the following dimension members from the list:
Scenario 2 and Year 2 dimension combinations
Scenario 3 and Year 3 dimension combinations
The report displays the following information:
Table 12. Profit Loss Variance Analysis – Report Details
| Report in Detail | Description |
|---|---|
| Accounts | Account value details. From accounts column, you can click the expand icon |
| Accounts Name | The account description |
| Scenario and Year combination | The account value based on only dashboard POV selector - Scenario, and Year. |
| Scenario 2 and Year 2 combination | The column contains the account value based on report prompt POV- Scenario 2, and Year 2. |
| Variance Column | Information about the calculated variance between the Third column and Fourth column. Note: If the calculated variance contains negative values, then the value is represented in red within parentheses. In OFMA, the variance analysis reports exhibit the expense reporting behavior. The following are the expense reporting properties:
|
| Scenario and Year combination | The column contains the account value based on only dashboard POV selector - Scenario, and Year. |
| Scenario 3 and Year 3 combination | The column contains the account value based on report prompt POV - Scenario 3, and Year 3. |
| Variance Column | Information about the calculated variance between the sixth column and seventh column. Note: If the calculated variance contains negative values, then the value is represented in red within parentheses. In OFMA, the variance analysis reports exhibit the expense reporting behavior. The following are the expense reporting properties:
|
to display the hierarchy of the selected account.