A Report Authoring Tips
This section provides tips and guidelines for creating effective and timely reports.
Common Report Authoring Tips
Improve all of your Oracle Fusion Analytics Warehouse reports with these recommendations and answers to 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.
Tips for Presentation Hierarchies
To improve performance, use presentation columns instead of presentation hierarchies. See Work with Presentation Tables and Columns.
Report Authoring Tips for Oracle Fusion ERP Analytics
Improve your Oracle Fusion ERP Analytics reports with these recommendations and answers to frequently asked questions regarding 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 Name and Description of qualified and non-qualified segments:
- Use List or is equal to/is
- Use filter type List or is equal to/is in for Balancing Segment, Natural Segment, Cost Center, and GL Segment 1 - 10
- For other filter types (e.g. begins with, IS LIKE) use Code.
- For all reports, use code attributes instead of the name or description when possible.
- For qualified or non-qualified segments, use Tree Code and Version instead of Tree Filter (23.R4.P3 or later).
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
Improve your Oracle Fusion Analytics Warehouse PPM reports with these recommendations and answers to frequently asked questions regarding 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.
Tips to Improve the Performance of PPM – Grants Award Funding Reports
To improve report performance in PPM - Grants Award Funding, follow these guidelines:
- Apply a filter on Award Business Unit for analyzing Award Funding information.
- When analyzing project level funding information or other Project metrics like Cost, Budget Amount etc., use the Project Business Unit filter.
Recommended Filters
Subject Area | Presentation Table (Recommended Filter) |
---|---|
PPM - Grants Award Funding |
|
PPM – Project Assets |
|
PPM – Project Budgets |
|
PPM – Project Costs |
|
PPM – Project Forecasts |
|
PPM – Project Funding |
|
PPM – Project Invoices |
|
PPM – Project Revenue |
|