A Report Authoring Tips
This section provides tips and guidelines for creating effective and timely reports.
Common Report Authoring Tips
This section provides information about commonly encountered use cases and frequently asked questions regarding reporting. The information isn’t exhaustive and is updated regularly with additional information and authoring tips.
Tips for Filters
When applying filters to reports, follow these guidelines:
- Use dashboard filters instead of workbook or canvas filters for user interactions in analyses.
- Use workbook filters for hidden and non-interaction filters.
- Set the Limit by Values to None for all filters in custom workbooks or dashboards to improve performance of prompts.
Tips for Brushing
Disable brushing to improve report performance. See Update Canvas Properties.
Tips for Working with Currency
To display the currency format for currency amounts, set the number format in each visualization as a custom currency. Then in the subject area folder, select the currency column. See Set Currency Symbols for Visualizations.
Tips for Reporting on Attributes Across Multiple Dimensions
When reporting on attributes against multiple dimensions, always use a measure in the report. In subject areas with more than one fact, the measure sets the correct context in the query, builds an accurate navigational path, and returns the expected results. If you don’t want the measure to show in the report, hide it. See Hide or Delete a Column.
Report Authoring Tips for Oracle Fusion ERP Analytics
This section provides information about commonly encountered use cases and frequently asked questions regarding Oracle Fusion ERP Analytics reporting. The information isn’t exhaustive and is updated regularly with additional information and authoring tips.
Tips to Improve the Performance of Reports
- For qualified or non-qualified segments, use the segment code instead of the name or description.
- For all reports, use code attributes instead of the name or description when possible.
Recommended Filters
Subject Area | Presentation Columns |
---|---|
AP Aging |
|
AP Expense |
|
AP Holds |
|
AP Invoices |
|
AP Liabilities |
|
AP Payments |
|
GL Balance Sheet |
|
GL Budget |
|
GL Detail Transactions |
|
GL Account Analysis |
|
Configurable Account Analysis |
|
AR Transactions |
|
AR Receipts and Applications |
|
AR Credit Memo Applications |
|
AR Adjustments |
|
AR Aging |
|
AR Revenue |
|
Asset Analysis |
|
Asset Transactions |
|
EXM Employee Expenses |
|
GL Profitability |
|
Report Authoring Tips for Project Analytics
This section provides information about commonly encountered use cases and frequently asked questions regarding Project (PPM) Analytics reporting. The information isn’t exhaustive and is updated regularly with additional information and authoring tips.
Tips to Improve the Performance of xTD Metrics Queries
Select a Fiscal Period, Fiscal Quarter, or Fiscal Year along with a Project Business Unit to analyze xTD metrics for a specific subject area. To improve performance on cross-subject area analyses involving xTD metrics, apply a filter on the workbook.
Tips to Improve the Performance of PPM – Project Costs Reports
To improve report performance in PPM - Project Costs, follow these guidelines:
- Apply a filter on Ledger and Distribution accounting periods when analyzing accounting information that includes details about unaccounted transactions.
- When analyzing accounting information, use Code instead of Name or Description for qualified and non-qualified segments.
Tips to Improve the Performance of PPM – Project Revenue Reports
To improve report performance in PPM - Project Revenue, follow these guidelines:
- Apply a filter on Ledger and Distribution accounting periods when analyzing accounting information that includes details about unaccounted transactions.
- When analyzing accounting information, use Code instead of Name or Description for qualified and non-qualified segments.
Recommended Filters
Subject Area | Presentation Table (Recommended Filter) |
---|---|
PPM – Project Assets |
|
PPM – Project Budgets |
|
PPM – Project Costs |
|
PPM – Project Forecasts |
|
PPM – Project Funding |
|
PPM – Project Invoices |
|
PPM – Project Revenue |
|