Examples of Using Dimension Values in Reporting
By using combinations of values for the Accounting Period, Balance Amount, and Amount Type dimensions, you can derive different amounts to meet financial reporting requirements. In some cases, more than one combination of query values can return the wanted information.
Some duplication in the calculations for the balances cube exists to ensure complete reporting requirements.
Reporting needs can be completed using the Balance Amount dimension, Amount Type equal to Base, and the Accounting Period equal to Year, Quarter, or Month.
However, the Amount Type dimension is still required for the following reasons:
-
To get the complete QTD (Quarter to Date) reporting requirements for the first and second month in a quarter. Complete QTD can only be achieved using QTD and Accounting Period = Month.
-
PTD (Period to Date) and YTD (Year to Date) are also available to ensure more consistency reporting with the E-Business Suite Release 12.
Obtaining Quarter Information
This example shows how to obtain quarter information.
-
QTD for the first and second months of a quarter can only be achieved using Amount Type dimension equal to QTD.
-
The end of quarter information can be derived from the Accounting Period dimension equal to Quarter or with the Amount Type equal QTD.
Obtaining End of Year Information
This example shows how to obtain end of year information.
-
Accounting Period equal to Year and Balance Amount equal to Ending Balance and Amount Type equal to Base or YTD.
-
Accounting Period equal to a specific month and Balance Amount equal to Period Activity and Amount Type equal to YTD.
-
When the Balance Amount equals the Balance Amount or the Balance Amount equals the Ending Balance, this results in an Ending Balance.