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 SCM Analytics and Fusion PROC Analytics
This section provides information about commonly encountered use cases and frequently asked questions regarding Oracle Fusion SCM Analytics reporting. The information isn’t exhaustive and is updated regularly with additional information and authoring tips.
Tips for Querying on the Common Fiscal Calendar Dimension
Select a Fiscal Calendar to analyze Purchase Order, Spend, Requisition, and Receipt to avoid aggregating data across different Fiscal Calendars.
Tips for reporting on the SCM — Manufacturing Work Orders Subject Area
- The granularity of the subject area is at the Operations level.
- The Metrics folder has measures at Work Order and Operations.
Tips for Querying on Balancing Segment, Natural Segment, Cost Center, and GL Segment 1 - 10 in relevant Supply Chain and Procurement Subject Areas
When reporting on qualified or non-qualified segments, use the segment code attributes instead of the name or description to improve performance.
Tips for Querying on SCM — Inventory Valuations
Use Cost Organization, Cost Book, Valuation Unit, and Valuation structure filters to ensure better performance when using a fiscal calendar filter.
Tips for Querying on SCM — Item Cost
Use Cost Organization, Cost Book, Valuation Unit, and Valuation structure filters to improve performance when using a fiscal calendar filter.
Tips for Querying on Spend Classification Categories in Procurement — Purchase Orders, Procurement — Requisitions, or Procurement — Spend
Select only one taxonomy dimension to analyze the fact metrics in one report to avoid joins across large data volume fact tables.
Recommended Filters
Subject Area | Presentation Table (Recommended Filter) |
---|---|
Procurement - Purchase Orders |
|
Procurement - Spend |
|
Procurement - Requisitions |
|
Procurement - Agreements |
|
Procurement - Receipts |
|
SCM – Cost Accounting |
|
SCM – Sales Orders |
|
SCM - Inventory Balances |
|
SCM – Inventory Valuations |
|
SCM – Picking and Shipping |
|
SCM – Transfer Orders |
|
SCM – Item Cost |
|
SCM - Inventory Receipts |
|
SCM – Sales Orders Holds |
|
SCM – Cogs and Gross Margin |
|
SCM – Inventory Transactions |
|
SCM – Manufacturing Work Orders |
|