AO_PAI_PlannerWorkloadOrderSummary
View dashboard associations
Build information
Analytical Object | AO_PAI_PlannerWorkloadOrderSummary |
Query Object | QO_PAI_PlannerWorkloadOrderSummary |
Data Source | PAI Advanced |
Cab File | SPM_PAI_Advanced.cab |
Query Object Primary Table | IPCS_ORDER_PLAN |
Query Object Tables | IPCS_ORDER_PLAN IPCS_PP_SEGMENTS IPCS_PLANNER_COVG IPCS_PLANNER_COVG_MAP IPCS_PLANNER |
Parameters | Name | Description | Default |
---|
PO_PAI_PlannerWorkloadHorizonMonths | The number of months to build the analytical object | 6 | This parameter addresses performance issues during the building of the cube when there are large amounts of data being fetched by the query. Fetching more than 1 million records can result in performance issues during the cube build. Reducing the horizon months can resolve potential performance issues. |
|
|
Predecessor Jobs | None |
Build Type | The following build types are supported: • Full |
Build Frequency | These build frequencies are supported: • Daily • Weekly • Monthly |
| • Planner • Order Type • Date • Order Status |
| Measure | Mathematical Function |
---|
Total | Distinct Count of orders | Daily Average | Sum of Daily Average |
|