MSC_FCSTPRF_ENG_PARAM_VALUES
Engine Parameter Values for Profiles.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
MSC_FCSTPRF_ENG_PARAM_VAL_PK |
PROFILE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PROFILE_ID | NUMBER | 18 | Yes | Profile identifier for Engine Profile Parameters Configuration. | |
| SUPERSESSIONLEVEL | NUMBER | 12 | SUPER_SESSION_LEVEL for Engine Profile Parameters Configuration. | ||
| WRITECOMBINATIONRESULTS | NUMBER | 12 | WRITE_COMBINATION_RESULTS: Flag Parameter for engine to write out node forecast results. | ||
| WRITEINTERMEDIATERESULTS | NUMBER | 12 | WRITE_INTERMEDIATE_RESULTS: Flag Parameter for engine to write out intermediate results. | ||
| ENABLEFITVALIDATION | NUMBER | 12 | ENABLE_FIT_VALIDATION for Engine Profile Parameters Configuration. | ||
| FITVALIDATIONSENSITIVITY | NUMBER | 12 | FIT_VALIDATION_SENSITIVITY for Engine Profile Parameters Configuration. | ||
| FITTESTPERIOD | NUMBER | 12 | FIT_TEST_PERIOD for Engine Profile Parameters Configuration. | ||
| DEVIATIONFACTOR | NUMBER | 12 | DEVIATION_FACTOR for Engine Profile Parameters Configuration. | ||
| STDRATIO | NUMBER | 12 | STD_RATIO for Engine Profile Parameters Configuration. | ||
| ENABLEFORECASTVALIDATION | NUMBER | 12 | ENABLE_FORECAST_VALIDATION for Engine Profile Parameters Configuration. | ||
| FORECASTVALIDATIONSENSITIVITY | NUMBER | 12 | FORECAST_VALIDATION_SENSITIVITY for Engine Profile Parameters Configuration. | ||
| FORECASTTESTPERIOD | NUMBER | 12 | FORECAST_TEST_PERIOD for Engine Profile Parameters Configuration. | ||
| ENABLEMODELVALIDATION | NUMBER | 12 | ENABLE_MODEL_VALIDATION for Engine Profile Parameters Configuration. | ||
| MODELVALIDATIONSENSITIVITY | NUMBER | 12 | MODEL_VALIDATION_SENSITIVITY for Engine Profile Parameters Configuration. | ||
| REMOVERESIDOUTLIER | NUMBER | 12 | REMOVE_RESID_OUTLIER for Engine Profile Parameters Configuration. | ||
| METRICSPERIOD | NUMBER | 12 | METRICS_PERIOD for Engine Profile Parameters Configuration. | ||
| DETECTOUTLIER | NUMBER | 12 | DETECT_OUTLIER for Engine Profile Parameters Configuration. | ||
| OUTLIERSENSITIVITY | NUMBER | 12 | OUTLIER_SENSITIVITY for Engine Profile Parameters Configuration. | ||
| REMOVEEXTREMEOUTLIER | NUMBER | 12 | REMOVE_EXTREME_OUTLIER for Engine Profile Parameters Configuration. | ||
| OUTLIERSPERCENT | NUMBER | 12 | OUTLIERS_PERCENT for Engine Profile Parameters Configuration. | ||
| OUTLIERSTDERR | NUMBER | 12 | OUTLIER_STD_ERR for Engine Profile Parameters Configuration. | ||
| DETECTREGIMECHANGE | NUMBER | 12 | DETECT_REGIME_CHANGE for Engine Profile Parameters Configuration. | ||
| REGIMESENSITIVITY | NUMBER | 12 | REGIME_SENSITIVITY for Engine Profile Parameters Configuration. | ||
| MINLENGTHFORDATASMOOTHING | NUMBER | 12 | MIN_LENGTH_FOR_DATA_SMOOTHING for Engine Profile Parameters Configuration. | ||
| FILLMISSINGMETHOD | NUMBER | 12 | FILL_MISSING_METHOD for Engine Profile Parameters Configuration. | ||
| ENABLENONNEGREGR | NUMBER | 12 | ENABLE_NON_NEG_REGR for Engine Profile Parameters Configuration. | ||
| ENABLEWEIGHTEDREGR | NUMBER | 12 | ENABLE_WEIGHTED_REGR for Engine Profile Parameters Configuration. | ||
| ENABLENAIVEFORECAST | NUMBER | 12 | ENABLE_NAIVE_FORECAST for Engine Profile Parameters Configuration. | ||
| WRITEFIT | NUMBER | 12 | WRITE_FIT for Engine Profile Parameters Configuration. | ||
| ENABLEMODIFIEDVARIANCE | NUMBER | 12 | ENABLE_MODIFIED_VARIANCE for Engine Profile Parameters Configuration. | ||
| HIGHESTSQUARING | NUMBER | 12 | HIGHEST_SQUARING for Engine Profile Parameters Configuration. | ||
| NONNEGREGRITERATIONS | NUMBER | 12 | NON_NEG_REGR_ITERATIONS for Engine Profile Parameters Configuration. | ||
| NUMOFSHAPES | NUMBER | 12 | NUM_OF_SHAPES for Engine Profile Parameters Configuration. | ||
| SHAPESIGN | NUMBER | 12 | SHAPE_SIGN for Engine Profile Parameters Configuration. | ||
| DAMPPERIOD | NUMBER | 12 | DAMP_PERIOD for Engine Profile Parameters Configuration. | ||
| DAMPSTEP | NUMBER | 12 | DAMP_STEP for Engine Profile Parameters Configuration. | ||
| PERIODSUNTILINACTIVE | NUMBER | 12 | PERIODS_UNTIL_INACTIVE for Engine Profile Parameters Configuration. | ||
| PERIODSUNTILACTIVE | NUMBER | 12 | PERIODS_UNTIL_ACTIVE for Engine Profile Parameters Configuration. | ||
| GLOBALALLOCATIONPERIODS | NUMBER | 12 | GLOBAL_ALLOCATION_PERIODS for Engine Profile Parameters Configuration. | ||
| GLOBALALLLOCTREATMISSING | NUMBER | 12 | GLOBAL_ALLLOC_TREAT_MISSING for Engine Profile Parameters Configuration. | ||
| SUPERSESSIONMETHOD | NUMBER | 12 | SUPER_SESSION_METHOD for Engine Profile Parameters Configuration. | ||
| ENABLEADJUSTMENT | NUMBER | 12 | ENABLE_ADJUSTMENT for Engine Profile Parameters Configuration. | ||
| ALLOWNEGATIVEFORECAST | NUMBER | 12 | ALLOW_NEGATIVE_FORECAST for Engine Profile Parameters Configuration. | ||
| LOGCORRECTION | NUMBER | 12 | LOG_CORRECTION for Engine Profile Parameters Configuration. | ||
| DOWNTREND | NUMBER | 12 | DOWN_TREND for Engine Profile Parameters Configuration. | ||
| UPTREND | NUMBER | 12 | UP_TREND for Engine Profile Parameters Configuration. | ||
| PERCENTOFZEROS | NUMBER | 12 | PERCENT_OF_ZEROS for Engine Profile Parameters Configuration. | ||
| INTERMITCRITERION | NUMBER | 12 | INTERMIT_CRITERION for Engine Profile Parameters Configuration. | ||
| SMOOTHINTERMITTENT | NUMBER | 12 | SMOOTH_INTERMITTENT for Engine Profile Parameters Configuration. | ||
| INTUPDATE | NUMBER | 12 | INT_UPDATE for Engine Profile Parameters Configuration. | ||
| INTERMITCROSTONUNSPREAD | NUMBER | 12 | INTERMIT_CROSTON_UNSPREAD for Engine Profile Parameters Configuration. | ||
| CUTLEADINGZEROS | NUMBER | 12 | CUT_LEADING_ZEROS for Engine Profile Parameters Configuration. | ||
| ENABLECAUSALSSHIFT | NUMBER | 12 | ENABLE_CAUSALS_SHIFT for Engine Profile Parameters Configuration. | ||
| SHIFTBASECAUSALS | NUMBER | 12 | SHIFT_BASE_CAUSALS for Engine Profile Parameters Configuration. | ||
| TOOFEW | NUMBER | 12 | TOO_FEW for Engine Profile Parameters Configuration. | ||
| TRENDPREESTIMATION | NUMBER | 12 | TREND_PRE_ESTIMATION for Engine Profile Parameters Configuration. | ||
| TRENDDAMPPERIOD | NUMBER | 12 | TREND_DAMP_PERIOD for Engine Profile Parameters Configuration. | ||
| TRENDDAMPSTEP | NUMBER | 12 | TREND_DAMP_STEP for Engine Profile Parameters Configuration. | ||
| TRENDMODELFORSHORT | NUMBER | 12 | TREND_MODEL_FOR_SHORT for Engine Profile Parameters Configuration. | ||
| TRENDOUTLIERRATIO | NUMBER | 12 | TREND_OUTLIER_RATIO for Engine Profile Parameters Configuration. | ||
| TRENDPERIOD | NUMBER | 12 | TREND_PERIOD for Engine Profile Parameters Configuration. | ||
| TRENDSHORTRATIO | NUMBER | 12 | TREND_SHORT_RATIO for Engine Profile Parameters Configuration. | ||
| TESTOUTOFSAMPLEDURATION | NUMBER | 12 | TEST_OUT_OF_SAMPLE_DURATION: Feature - Intermittent Results. TestOutOfSampleDuration parameter for Intermittent results feature. | ||
| TESTMODE | NUMBER | 12 | TEST_MODE: Feature - Intermittent Results. TestMode parameter for Intermittent results feature. | ||
| ENGINERUNDATE | DATE | ENGINE_RUN_DATE: Feature - Net Change. Indication of the date and time the engine profile completed successfully | |||
| COLLINEARITYUSERIDGE | NUMBER | 12 | COLLINEARITY_USE_RIDGE: Feature - Colinearity. A flag controlling use of Ridge regression or QR/SVD decomposition in cases of collinearity. If set to 0 - Ridge Service is not used. 1(default) - use Ridge for cases of collinearity. 2 - use QR instead SVD for cases of collinearity and NonNegRegr. | ||
| COLLINEARITYTOLERANCE | NUMBER | 12 | COLLINEARITY_TOLERANCE: Feature - Colinearity. Parameter controlling sensitivity of collinearity detection. Default value of 1 detects very strong cases. Large values such as 1000 would detect weaker cases. Can be set between 1 and 100,000 | ||
| COLLINEARITYMAXRATIO | NUMBER | 12 | COLLINEARITY_MAX_RATIO: Feature - Colinearity. Maximum ratio allowed between base or lift elements and total demand. Can be set to any integer greater than one. | ||
| POPULATIONFILTER | VARCHAR2 | 2000 | POPULATION_FILTER: Feature - Population Filter. 'Applies a filter on a batch profile. Default- No filter. Example: MDP_MATRIX .PREDICTION_STATUS=1. Syntax must include the tables for the from clause. Example: ITEMS.ITEM_ID=MDP_MATRIX.ITEM_ID AND ITEMS.ITEM_ID<100.'. | ||
| INTERMITTENCYOUTPUTTYPE | NUMBER | 12 | INTERMITTENCY_OUTPUTTYPE : Feature - Safety Stock. The data for which intermittency information will be calculated and reported. 1 =history,2 = historical fit, 3= forecast | ||
| TRAININGPERCENT | NUMBER | 12 | TRAINING_PERCENT : The values should be between 0.5 and 0.9. | ||
| OUTOFSAMPLETESTSETS | NUMBER | 6 | OUT_OF_SAMPLE_TEST_SETS: Specifies the number of valid historical test sets for out of sample error calculation. Use 0 to disable the out of sample data set. Use 2-N to determine the number of data sets. When choosing 1, engine will use 2 instead. | ||
| ACCURACYTHRESHOLD | NUMBER | 12 | ACCURACY_THRESHOLD : Specifies the minimum acceptable forecast accuracy required for cross-product machine learning forecasting methods. The values should be between 0.4 and 0.9. | ||
| ACCURACYSTRATIFICATIONLEVEL | NUMBER | 18 | ACCURACY_STRATIFICATION_LEVEL : Specifies the product dimension level to use for forecast accuracy calculation by cross-product machine learning forecasting methods. | ||
| PLANADVISORNOTIFLAYOUTID | NUMBER | 18 | PLAN_ADVISOR_NOTIF_LAYOUT_ID: Specifies the name of the page layout to open from the Planning Advisor dialog box when the suggestion for a new product is clicked. | ||
| EXTSTORAGESVCNAME | VARCHAR2 | 50 | EXT_STORAGE_SVC_NAME: Specifies the name of the external storage service of the BI Cloud Connector. Data files from Demand Management are extracted to the external storage service. | ||
| FORECASTOUTPUTFILTER | NUMBER | 18 | Specifies the measure that filters the combinations that receive the disaggregated forecast | ||
| LAUNCHDATEMEASUREID | NUMBER | 18 | LAUNCH_DATE_MEASURE_ID: Specifies the measure that contains the product launch date which will be used by engine for forecasting. | ||
| DISCONTINUEDATEMEASUREID | NUMBER | 18 | DISCONTINUE_DATE_MEASURE_ID: Specifies the measure that contains the product discontinuation date which will be used by engine for forecasting. | ||
| SUPERSESSIONMEASUREID | NUMBER | 18 | Specifies the measure that contains the inventory ID for the latest revision of an item in a supersession chain. | ||
| OPTIMIZERIDGEK | NUMBER | 12 | Specifies whether to automatically optimize the RIDGEK method parameter's value for the Modified Ridge Regression forecasting method during the forecast run. | ||
| OPTIMIZEDIMENSIONREDUCTION | NUMBER | 12 | Specifies whether to optimize the collinearity and near-collinearity treatment for forecasting methods and method parameters during the forecast run. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | ||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | |
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. | |
| ENABLENODALTUNING | NUMBER | Specifies whether to use nodal forecast parameter values during a forecast run. If hypertuning is turned on then nodal tuning should also be turned on. Parameter values may be 0 or 1. 0 for not using nodal tuning,1 for using nodal tuning | |||
| HYPERTUNESAMPLEPERCENT | NUMBER | Specifies the percentage of the plan population for which hyperparameter tuning is done during the forecast generation. Parameter values may be 0, n, 100. 0 for no hyperparameter tuning, N for random sample of population for hyperparameter tuning, 100 for hyperparameter tuning for all of the plan population. | |||
| HYPERTUNEOUTPUTMODE | NUMBER | Specifies whether to save the results of hyperparameter tuning in the output measures. Parameter values may be 0, 1, 2. 0 for no saving, 1 for saving optimal settings, MAPE metrics and optimal forecast in profile output measure, 2 for saving the optimal settings, MAPE metrics and optimal forecast in separate hypertuning forecast measure. | |||
| HYPERTUNEADVISOR | NUMBER | Specifies whether to provide notifications through the Planning Advisor when better forecasting results are available because of hyperparameter tuning. Parameter values may be 0, 1. 0 for no notifications through the Planning Advisor, 1 for providing notifications through the Planning Advisor. | |||
| HYPERTUNEHOLDBACK | NUMBER | Specifies the number of days before the plan start date to use for holdback validation (out-of-sample testing) of the results of hyperparameter tuning. | |||
| HYPERTUNEHOLDBACKPERCENT | NUMBER | Specifies the maximum percentage of history to use for holdback validation (out-of-sample testing) for each combination during hyperparameter tuning. Holdback period will never be greater than this percent of history if specified. | |||
| HYPERTUNEMAPETHRESHOLD | NUMBER | Specifies the minimum percentage of change required between the default mean absolute percentage error (MAPE) and the MAPE after hyperparameter tuning for a combination for the optimization to be successful. If the percentage of change is below the threshold, the optimization is ignored. | |||
| HYPERTUNEHALFLIFE | NUMBER | Specifies the number of days that the output of hyperparameter tuning is considered as fresh. After this time period the hypertuning feature will retune any nodes where their hypertuning output is older than this. | |||
| SETNODALTUNINGSOURCE | NUMBER | Specifies which measure to use to get the nodal forecast parameter values for forecast runs. Parameter values may be 0, or a selected user-defined measure. The 0 value denotes that the predefined hypertuning measure for that profile will be used, other values mean that the other user-specified measure will be used as the source for the forecast parameter values. This parameter will only be used if EnableNodalTuning is set to 1. | |||
| HYPERTUNEPARAMSET | VARCHAR2 | 2000 | Specifies a default set of parameter values to be used for hyperparameter tuning if it's enabled but no values have been entered in the Hyperparameter Tuning Values column on the Forecasting Parameters tab on the Manage Forecasting Profiles page. This default set of parameter values shouldn't be edited. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| MSC_FCSTPRF_ENG_PARAM_VALUES | msc_forecast_profiles_b | PROFILE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MSC_FCSTPRF_ENG_PARAM_VAL_PK | Unique | Default | PROFILE_ID, ORA_SEED_SET1 |
| MSC_FCSTPRF_ENG_PARAM_VAL_PK1 | Unique | Default | PROFILE_ID, ORA_SEED_SET2 |