Demantra-Create series using SQL

DEMANTRA:Create series from backend




insert into COMPUTED_FIELDS (
FORECAST_TYPE_ID
, COMPUTED_NAME
, EXP_TEMPLATE
, DISP_COLOR
, DISP_LSTYLE
, DISP_LSYMBOL
, PRINT_COLOR
, PRINT_LSTYLE
, PRINT_LSYMBOL
, DISP_ORDER
, INFO_TYPE
, TABLE_FORMAT
, DO_HAVING
, COMPUTED_TITLE
, FIELD_TYPE
, SUM_FUNC
, MODE_1
, MODE_COLOR
, SCALEBLE
, TIME_AVG
, MODULE_TYPE
, DEPENDANTS
, EDITABLE
, IS_PROPORTION
, NULL_AS_ZERO
, DBNAME
, IS_DDLB
, IS_CHECK
, SERIES_WIDTH
, DROPDOWN_TABLE_NAME
, WEB_FORMULA
, IS_DEFAULT
, HINT_MESSAGE
, COMPUTEDFIELD_EXPRESSION
, CLIENT_EXP_DISP
, HIST_PRED_TYPE
, ITEMCHANGE
, LOCK_EXP
, DATA_TABLE_NAME
, COMP_DEPEND_ORDER
, DEPEND_ON_EXP_SERVER
, BACKGROUND_COLOR_EXP
, SYNCRO_FIELD
, LOCK_EXP_DISP
, BACKGROUND_EXP_DISP
, WEB_LOCK_EXPRESSION
, ATTRIBUTES_DEPENDENTS
, CALCULATION_METHOD
, LOOP_NUMBER
, MOVE_UPD_BET_FORE
, MOVE_FROM_SALES_TO_FOR
, LOOKUP_TYPE
, LOOKUP_TABLE
, LOOKUP_DISPLAY_FIELD
, LOOKUP_DATA_FIELD
, LOOKUP_EXTRA_FROM
, LOOKUP_EXTRA_WHERE
, COL_SERIES_WIDTH
, IS_RANKING
, PROP_CALC_SERIES
, UNLINKED_LEVEL_ID
, UPDATE_BY_SERIES_ID
, EXTRA_FROM
, EXTRA_WHERE
, BASE_LEVEL
, COLOR_DEPENDANTS
, LOCK_EXP_DEPENDANTS
, EXPRESSION_TYPE
, INT_AGGR_FUNC
, WAVG_BY_SERIES
, AGGR_BY
, SUMMARY_LINE_EXP
, SUMMARY_LINE_EXP_DISP
, SUMMARY_LINE_DEPENDENTS
, PRESERVATION_TYPE
, FILTER_EXP
, FILTER_EXP_DISP
, FILTER_EXP_DEPENDANTS
, FILTER_EXP_COL_DEPENDANTS
, IS_EDITABLE_SUMMARY
, MOVE_PRESERVATION_TYPE
, TABLE_ID
, DATA_TYPE
, SAME_VAL_UPDATE
, BM_VALIDATED
, MODIFIED_BY
, LOOKUP_SECURITY_TYPE_ID
, APPLICATION_ID
, LOOKUP_MIN_PERMISSION_ID)
VALUES
( 4961
, 'XXLOC_TEST_SER1'
, 'MAX(XXLOC_TEST(branch_daa.sales_date))'
, 255
, 1
, 1
, 255
, 1
, 1
, 11562
, 2
, 'Hyperlink'
, 0
, 'xxtest1'
, 1
, 'MAX'
, ''
, ''
, 0
, ''
, 0
, ''
, 3
, 0
, 0
, ''
, 0
, 0
, 250
, ''
, ''
, 0
, ''
, ''
, ''
, 3
, ''
, ''
, 'BRANCH_DATA'
, ''
, ''
, ''
, ''
, ''
, ''
, ''
, ''
, ''
, ''
, ''
, ''
, 0
, ''
, ''
, ''
, ''
, ''
, 10
, ''
, ''
, ''
, ''
, 'DUAL'
, ''
, 0
, ''
, ''
, 1
, 'MAX'
, ''
, 0
, ''
, ''
, ''
, 3
, ''
, ''
, ''
, ''
, 0
, 3
, 4806
, 1
, 0
, 1
, 'BM'
, ''
, 'D97B38AFAB9F416BB40F9AC317062327'
,''
);

INSERT INTO series_groups_m(group_id,series_id)
      VALUES(0,vi_forecast_type_id);

INSERT INTO SERIES_GROUPS_M(GROUP_ID,SERIES_ID)
      VALUES(0,4961);