1. Creating and Administering Analytics and Reports for SCM
  2. How can I improve the performance of reports and analyses that are based on the Product Management - Structures and Components Real Time subject area?

How can I improve the performance of reports and analyses that are based on the Product Management - Structures and Components Real Time subject area?

In reports and analyses that are based on the Product Management - Structures and Components Real Time subject area, to improve the performance when they return the exploded view of a bill of material (BOM) or include Component Assembly Attributes > Reference Designator >

  • Add the following:

    SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1',
DISABLE_CACHE_HIT=1,
OBIS_ORACLEDB_HINTS_FOR_TOP_SELECT='OPT_PARAM(''_push_join_predicate'',''false'') OPT_PARAM(''_optimizer_push_pred_cost_based'',''false'') OPT_PARAM(''_complex_view_merging'',''false'')';

  • Add this filter:

    ("Structure Quick Preview"."Component AML Pending Revision Flag" = 'N')

  • Use the UPPER() function with the filter on the item name.