{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["List Process","490000003","490000005","490000006","490000015"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"List Process","index":0,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["List Process"]
[490000003,"Sales Details"]
[490000005,"Sales vs Forecast (Calendar Month/Quarter Forecast)"]
[490000006,"Sales Invoice Analysis"]
[490000015,"Sales Order Analysis"]

{"sheet":"490000003","index":1,"n_rows":153,"n_cols":7,"rows_kept":153,"cut":false,"hidden":false,"merged":[]}
["Main Menu"]
["tableAlias","tableName","name","columnGroupHeading","columnHeading","calculation","Oncalculation"]
["*SERVER","*SERVER","FLD0000007","Fiscal","Year","CASE \nWHEN UDM_SALES.DS_TYPE = 'I' THEN UDM_DIMTIME.FISCALYEAR\nWHEN UDM_SALES.DS_TYPE = 'O' THEN UDM_DIMTIME_1.FISCALYEAR\nWHEN UDM_SALES.DS_TYPE = 'S' THEN UDM_DIMTIME_2.FISCALYEAR\nWHEN UDM_SALES.DS_TYPE = 'R' THEN UDM_DIMTIME_3.FISCALYEAR\nEND"]
["*SERVER","*SERVER","FLD0000008","Fiscal","Quarter","CASE \nWHEN UDM_SALES.DS_TYPE = 'I' THEN UDM_DIMTIME.FISCALQUARTER\nWHEN UDM_SALES.DS_TYPE = 'O' THEN UDM_DIMTIME_1.FISCALQUARTER\nWHEN UDM_SALES.DS_TYPE = 'S' THEN UDM_DIMTIME_2.FISCALQUARTER\nWHEN UDM_SALES.DS_TYPE = 'R' THEN UDM_DIMTIME_3.FISCALQUARTER\nEND"]
["*SERVER","*SERVER","FLD0000009","Fiscal","Period","CASE \nWHEN UDM_SALES.DS_TYPE  = 'I' THEN UDM_DIMTIME.FISCALPERIOD \nWHEN UDM_SALES.DS_TYPE  = 'O' THEN UDM_DIMTIME_1.FISCALPERIOD \nWHEN UDM_SALES.DS_TYPE  = 'S' THEN UDM_DIMTIME_2.FISCALPERIOD \nWHEN UDM_SALES.DS_TYPE  = 'R' THEN UDM_DIMTIME_3.FISCALPERIOD \nEND"]
["*SERVER","*SERVER","FLD0000004","Calendar","Year","UDM_SALES.CYEAR"]
["*SERVER","*SERVER","FLD0000005","Calendar","Quarter","CASE \nWHEN UDM_SALES.CPERIOD BETWEEN  1 AND  3 THEN 1\nWHEN UDM_SALES.CPERIOD BETWEEN  4 AND  6 THEN 2\nWHEN UDM_SALES.CPERIOD BETWEEN  7 AND  9 THEN 3\nWHEN UDM_SALES.CPERIOD BETWEEN 10 AND 12 THEN 4\nEND"]
["*SERVER","*SERVER","FLD0000006","Calendar","Period","UDM_SALES.CPERIOD"]
["UDM_SALES","UDM_SALES","COMPANYID","Company","ID"]
["UDM_DIMCOMPANY","UDM_DIMCOMPANY","COMPANYNAME","Company","Name"]
["UDM_SALES","UDM_SALES","SITEID","Site","ID"]
["UDM_DIMSITES","UDM_DIMSITES","FCYNAM","Site","Name"]
["UDM_SALES","UDM_SALES","SALESREPID1","Sales Rep","ID"]
["UDM_DIMSALESREP","UDM_DIMSALESREP","SALESREPNAME","Sales Rep","Name"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","DEFSALESREPID","Def Sales Rep","ID"]
["UDM_DIMSALESREP_1","UDM_DIMSALESREP","SALESREPNAME","Def Sales Rep","Name"]
["UDM_SALES","UDM_SALES","ACCOUNTID","Account","ID"]
["UDM_SALES","UDM_SALES","CLIENTID","Customer","ID"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","CLIENTNAME","Customer","Name"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","CLIENTTYPE","Customer","Type"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","STATGROUP1","Customer Stat Group","Code 1"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","STATGROUP2","Customer Stat Group","Code 2"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","STATGROUP3","Customer Stat Group","Code 3"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","STATGROUP4","Customer Stat Group","Code 4"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","STATGROUP5","Customer Stat Group","Code 5"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD01","Customer UDF 01","Code"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD01DESC","Customer UDF 01","Desc"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD02","Customer UDF 02","Code"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD02DESC","Customer UDF 02","Desc"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD03","Customer UDF 03","Code"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD03DESC","Customer UDF 03","Desc"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD04","Customer UDF 04","Code"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD04DESC","Customer UDF 04","Desc"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD05","Customer UDF 05","Code"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD05DESC","Customer UDF 05","Desc"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD06","Customer UDF 06","Code"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD06DESC","Customer UDF 06","Desc"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD07","Customer UDF 07","Code"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD07DESC","Customer UDF 07","Desc"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD08","Customer UDF 08","Code"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD08DESC","Customer UDF 08","Desc"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD09","Customer UDF 09","Code"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD09DESC","Customer UDF 09","Desc"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD10","Customer UDF 10","Code"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD10DESC","Customer UDF 10","Desc"]
["UDM_SALES","UDM_SALES","PRODUCTID","Product","ID"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","PRODUCTDESC","Product","Name"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","PRODUCTLINE","Product","Line"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","STATGROUP1","Product Stat Group","Code 1"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","STATGROUP2","Product Stat Group","Code 2"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","STATGROUP3","Product Stat Group","Code 3"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","STATGROUP4","Product Stat Group","Code 4"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","STATGROUP5","Product Stat Group","Code 5"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD01","Product UDF 01","Code"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD01DESC","Product UDF 01","Desc"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD02","Product UDF 02","Code"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD02DESC","Product UDF 02","Desc"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD03","Product UDF 03","Code"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD03DESC","Product UDF 03","Desc"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD04","Product UDF 04","Code"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD04DESC","Product UDF 04","Desc"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD05","Product UDF 05","Code"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD05DESC","Product UDF 05","Desc"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD06","Product UDF 06","Code"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD06DESC","Product UDF 06","Desc"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD07","Product UDF 07","Code"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD07DESC","Product UDF 07","Desc"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD08","Product UDF 08","Code"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD08DESC","Product UDF 08","Desc"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD09","Product UDF 09","Code"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD09DESC","Product UDF 09","Desc"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD10","Product UDF 10","Code"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD10DESC","Product UDF 10","Desc"]
["*SERVER","*SERVER","FLD0000002",null,"Dummy","CASE\nWHEN [Company ID] = [Company ID]\nTHEN 'Total Number of Orders'\nEND"]
["UDM_SALES","UDM_SALES","LEDCUR","Ledger","Currency"]
["UDM_SALES","UDM_SALES","CURRENCY","Local","Currency"]
["UDM_SALES","UDM_SALES","ORDERNO","Order","Number"]
["UDM_DIMTIME_1","UDM_DIMTIME","CALDATE","Order","Date"]
["UDM_SALES","UDM_SALES","ORDERQTY","Order","Quantity"]
["*SERVER","*SERVER","FLD0000001","Order Count","Product","CASE\nWHEN UDM_SALES_1.ORDERNO IS NOT NULL\nTHEN UDM_SALES_1.ORDERNO\nEND"]
["*SERVER","*SERVER","FLD0000003","Order Count","Distinct Customer","CASE\nWHEN UDM_SALES_1.ORDERNO IS NOT NULL\nTHEN UDM_SALES_1.CLIENTID\nEND"]
["UDM_SALES","UDM_SALES","ORDAMTLOC","Order","Amount (Local)"]
["UDM_SALES","UDM_SALES","ORDAMTLED","Order","Amount (Ledger)"]
["UDM_DIMTIME","UDM_DIMTIME","CALDATE","Invoice","Date"]
["UDM_SALES","UDM_SALES","INVAMTLED","Invoice","Amount (Ledger)"]
["UDM_SALES","UDM_SALES","INVOICENO","Invoice","Number"]
["UDM_SALES","UDM_SALES","INVAMTLOC","Invoice","Amount (Local)"]
["*SERVER","*SERVER","FLD00000010","Percentage","Amount Invoiced",0,"if ([Order Amount (Ledger)] !== 0)\n\nnecResult= [Invoice Amount (Ledger)] / [Order Amount (Ledger)];\nelse\nnecResult = 0;"]
["UDM_DIMADDRESS","UDM_DIMADDRESS","COUNTRY","Billing","Country"]
["UDM_DIMADDRESS","UDM_DIMADDRESS","COUNTRYDESC","Billing","Country Name"]
["UDM_DIMADDRESS","UDM_DIMADDRESS","PROVINCESTATE","Billing","State"]
["UDM_DIMADDRESS","UDM_DIMADDRESS","CITY","Billing","City"]
["UDM_DIMADDRESS","UDM_DIMADDRESS","POSTALCODEZIP","Billing","Postal Code"]
["UDM_DIMADDRESS","UDM_DIMADDRESS","ADDRESSLINE1","Billing","Address Line 1"]
["UDM_SALES","UDM_SALES","INVOICEQTY","Invoice","Qty"]
["UDM_SALES","UDM_SALES","SHIPNO","Shipping","Number"]
["UDM_DIMTIME_2","UDM_DIMTIME","CALDATE","Shipping","Date"]
["UDM_SALES","UDM_SALES","SHIPQTY","Shipping","Qty"]
["UDM_SALES","UDM_SALES","SHIPAMTLED","Shipping","Amount (Ledger)"]
["UDM_SALES","UDM_SALES","SHIPAMTLOC","Shipping","Amount (Local)"]
["*SERVER","*SERVER","FLD00000011","Percentage","Shipped Amount",0,"if ([Order Amount (Ledger)] !== 0)\nnecResult = [Shipping Amount (Ledger)] / [Order Amount (Ledger)];\n\nelse\nnecResult = 0;"]
["UDM_DIMADDRESS_1","UDM_DIMADDRESS","ADDRESSLINE1","Shipping","Address Line 1"]
["UDM_DIMADDRESS_1","UDM_DIMADDRESS","COUNTRY","Shipping","Country"]
["UDM_DIMADDRESS_1","UDM_DIMADDRESS","COUNTRYDESC","Shipping","Country Name"]
["UDM_DIMADDRESS_1","UDM_DIMADDRESS","PROVINCESTATE","Shipping","State"]
["UDM_DIMADDRESS_1","UDM_DIMADDRESS","CITY","Shipping","City"]
["UDM_DIMADDRESS_1","UDM_DIMADDRESS","POSTALCODEZIP","Shipping","Postal Code"]
["UDM_SALES","UDM_SALES","RETURNNO","Return","Number"]
["UDM_DIMTIME_3","UDM_DIMTIME","CALDATE","Return","Date"]
["UDM_SALES","UDM_SALES","RETQTY","Return","Qty"]
["UDM_SALES","UDM_SALES","RETAMTLOC","Return","Amount (Local)"]
["UDM_SALES","UDM_SALES","RETAMTLED","Return","Amount (Ledger)"]
["*SERVER","*SERVER","FLD00000012","Percentage","Returned Amount",0,"if ([Order Amount (Ledger)] !== 0)\nnecResult = [Return Amount (Ledger)] / [Order Amount (Ledger)];\n\nelse\nnecResult = 0;"]
["UDM_SALES","UDM_SALES","DIMENSION01","Dimension 01","Code"]
["UDM_DIMENSIONS","UDM_DIMENSIONS","DESCRIPTION","Dimension 01","Description"]
["UDM_SALES","UDM_SALES","DIMENSION02","Dimension 02","Code"]
["UDM_DIMENSIONS_1","UDM_DIMENSIONS","DESCRIPTION","Dimension 02","Description"]
["UDM_SALES","UDM_SALES","DIMENSION03","Dimension 03","Code"]
["UDM_DIMENSIONS_2","UDM_DIMENSIONS","DESCRIPTION","Dimension 03","Description"]
["UDM_SALES","UDM_SALES","DIMENSION04","Dimension 04","Code"]
["UDM_DIMENSIONS_3","UDM_DIMENSIONS","DESCRIPTION","Dimension 04","Description"]
["UDM_SALES","UDM_SALES","DIMENSION05","Dimension 05","Code"]
["UDM_DIMENSIONS_4","UDM_DIMENSIONS","DESCRIPTION","Dimension 05","Description"]
["UDM_SALES","UDM_SALES","DIMENSION06","Dimension 06","Code"]
["UDM_DIMENSIONS_5","UDM_DIMENSIONS","DESCRIPTION","Dimension 06","Description"]
["UDM_SALES","UDM_SALES","DIMENSION07","Dimension 07","Code"]
["UDM_DIMENSIONS_6","UDM_DIMENSIONS","DESCRIPTION","Dimension 07","Description"]
["UDM_SALES","UDM_SALES","DIMENSION08","Dimension 08","Code"]
["UDM_DIMENSIONS_7","UDM_DIMENSIONS","DESCRIPTION","Dimension 08","Description"]
["UDM_SALES","UDM_SALES","DIMENSION09","Dimension 09","Code"]
["UDM_DIMENSIONS_8","UDM_DIMENSIONS","DESCRIPTION","Dimension 09","Description"]
["UDM_SALES","UDM_SALES","DIMENSION10","Dimension 10","Code"]
["UDM_DIMENSIONS_9","UDM_DIMENSIONS","DESCRIPTION","Dimension 10","Description"]
["UDM_SALES","UDM_SALES","DIMENSION11","Dimension 11","Code"]
["UDM_DIMENSIONS_10","UDM_DIMENSIONS","DESCRIPTION","Dimension 11","Description"]
["UDM_SALES","UDM_SALES","DIMENSION12","Dimension 12","Code"]
["UDM_DIMENSIONS_11","UDM_DIMENSIONS","DESCRIPTION","Dimension 12","Description"]
["UDM_SALES","UDM_SALES","DIMENSION13","Dimension 13","Code"]
["UDM_DIMENSIONS_12","UDM_DIMENSIONS","DESCRIPTION","Dimension 13","Description"]
["UDM_SALES","UDM_SALES","DIMENSION14","Dimension 14","Code"]
["UDM_DIMENSIONS_13","UDM_DIMENSIONS","DESCRIPTION","Dimension 14","Description"]
["UDM_SALES","UDM_SALES","DIMENSION15","Dimension 15","Code"]
["UDM_DIMENSIONS_14","UDM_DIMENSIONS","DESCRIPTION","Dimension 15","Description"]
["UDM_SALES","UDM_SALES","DIMENSION16","Dimension 16","Code"]
["UDM_DIMENSIONS_15","UDM_DIMENSIONS","DESCRIPTION","Dimension 16","Description"]
["UDM_SALES","UDM_SALES","DIMENSION17","Dimension 17","Code"]
["UDM_DIMENSIONS_16","UDM_DIMENSIONS","DESCRIPTION","Dimension 17","Description"]
["UDM_SALES","UDM_SALES","DIMENSION18","Dimension 18","Code"]
["UDM_DIMENSIONS_17","UDM_DIMENSIONS","DESCRIPTION","Dimension 18","Description"]
["UDM_SALES","UDM_SALES","DIMENSION19","Dimension 19","Code"]
["UDM_DIMENSIONS_18","UDM_DIMENSIONS","DESCRIPTION","Dimension 19","Description"]
["UDM_SALES","UDM_SALES","DIMENSION20","Dimension 20","Code"]
["UDM_DIMENSIONS_19","UDM_DIMENSIONS","DESCRIPTION","Dimension 20","Description"]

{"sheet":"490000005","index":2,"n_rows":91,"n_cols":7,"rows_kept":91,"cut":false,"hidden":false,"merged":[]}
["Main Menu"]
["tableAlias","tableName","name","columnGroupHeading","columnHeading","calculation","Oncalculation"]
["*SERVER","*SERVER","FLD00000017","Calendar","Year","CASE\nWHEN UDM_FORECAST_JOIN.F_CUMYEAR IS NOT NULL\nTHEN UDM_FORECAST_JOIN.F_CUMYEAR \n\nELSE UDM_FORECAST.CALENDARYEAR\nEND"]
["*SERVER","*SERVER","FLD00000023","Calendar","Quarter","CASE\n\tCASE\n\tWHEN UDM_FORECAST_JOIN.F_CUMPERIOD IS NOT NULL\n\tTHEN UDM_FORECAST_JOIN.F_CUMPERIOD\n\t\n\tELSE UDM_FORECAST.CALENDARPERIOD\n\tEND\nWHEN 1 THEN 1\nWHEN 2 THEN 1\nWHEN 3 THEN 1\nWHEN 4 THEN 2\nWHEN 5 THEN 2\nWHEN 6 THEN 2\nWHEN 7 THEN 3\nWHEN 8 THEN 3\nWHEN 9 THEN 3\nWHEN 10 THEN 4\nWHEN 11 THEN 4\nWHEN 12 THEN 4\nEND"]
["*SERVER","*SERVER","FLD00000016","Calendar","Period","COALESCE(UDM_FORECAST_JOIN.F_CUMPERIOD,UDM_FORECAST.CALENDARPERIOD)"]
["*SERVER","*SERVER","FLD00000011","Calendar","Year-Period","CONCAT(\n\tCONCAT(CASE\n\t\t\tWHEN UDM_FORECAST_JOIN.F_CUMYEAR IS NOT NULL\n\t\t\tTHEN UDM_FORECAST_JOIN.F_CUMYEAR \n\t\t\tELSE UDM_FORECAST.CALENDARYEAR\n\t\tEND,'-'),\n\n\tCASE\n\t\tWHEN\n\t\t\t(CASE\n\t\t\t\tWHEN UDM_FORECAST_JOIN.F_CUMPERIOD IS NOT NULL\n\t\t\t\tTHEN UDM_FORECAST_JOIN.F_CUMPERIOD\n\t\t\t\tELSE UDM_FORECAST.CALENDARPERIOD\n\t\t\tEND) < 10\n\t\tTHEN CONCAT('0',\n\t\t\t\t\t(CASE\n\t\t\t\t\t\tWHEN UDM_FORECAST_JOIN.F_CUMPERIOD IS NOT NULL\n\t\t\t\t\t\tTHEN UDM_FORECAST_JOIN.F_CUMPERIOD\n\t\t\t\t\t\tELSE UDM_FORECAST.CALENDARPERIOD\n\t\t\t\t\tEND))\n\t\tELSE cast((CASE\n\t\t\t\t\tWHEN UDM_FORECAST_JOIN.F_CUMPERIOD IS NOT NULL\n\t\t\t\t\tTHEN UDM_FORECAST_JOIN.F_CUMPERIOD\n\t\t\t\t\tELSE UDM_FORECAST.CALENDARPERIOD\n\t\t\t\tEND) as char(2))\n\tEND)"]
["*SERVER","*SERVER","FLD00000026","Calendar","Year-Quarter","CONCAT(\n\tCONCAT(CASE\n\t\t\tWHEN UDM_FORECAST_JOIN.F_CUMYEAR IS NOT NULL\n\t\t\tTHEN UDM_FORECAST_JOIN.F_CUMYEAR \n\t\t\tELSE UDM_FORECAST.CALENDARYEAR\n\t\tEND,'-0')\n\t,CASE\n\t\tCASE\n\t\tWHEN UDM_FORECAST_JOIN.F_CUMPERIOD IS NOT NULL\n\t\tTHEN UDM_FORECAST_JOIN.F_CUMPERIOD\n\t\t\n\t\tELSE UDM_FORECAST.CALENDARPERIOD\n\t\tEND\n\tWHEN 1 THEN 1\n\tWHEN 2 THEN 1\n\tWHEN 3 THEN 1\n\tWHEN 4 THEN 2\n\tWHEN 5 THEN 2\n\tWHEN 6 THEN 2\n\tWHEN 7 THEN 3\n\tWHEN 8 THEN 3\n\tWHEN 9 THEN 3\n\tWHEN 10 THEN 4\n\tWHEN 11 THEN 4\n\tWHEN 12 THEN 4\n\tEND)"]
["UDM_FORECAST","UDM_FORECAST","FCST_TYPE","Forecast","Type"]
["UDM_FORECAST","UDM_FORECAST","FCST_NAME","Forecast","Name"]
["UDM_FORECAST","UDM_FORECAST","REVISION_NUM","Revision","Number"]
["UDM_FORECAST","UDM_FORECAST","COMPANYID","Company","ID"]
["UDM_DIMCOMPANY","UDM_DIMCOMPANY","COMPANYNAME","Company","Name"]
["UDM_FORECAST","UDM_FORECAST","LED_CUR","Ledger","Currency"]
["UDM_FORECAST","UDM_FORECAST","SITEID","Site","ID"]
["UDM_DIMSITES","UDM_DIMSITES","FCYNAM","Site","Name"]
["UDM_FORECAST","UDM_FORECAST","WAREHOUSEID","Warehouse","ID"]
["UDM_DIMWAREHOUSE","UDM_DIMWAREHOUSE","WRHNAM","Warehouse","Name"]
["UDM_FORECAST","UDM_FORECAST","SALESREP","Sales Rep","ID"]
["UDM_DIMSALESREP","UDM_DIMSALESREP","SALESREPNAME","Sales Rep","Name"]
["UDM_FORECAST","UDM_FORECAST","CUSTOMERID","Customer","ID"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","CLIENTNAME","Customer","Name"]
["UDM_FORECAST","UDM_FORECAST","CUST_STAT1","Customer Stat Group","Code 1"]
["UDM_DESCRIPTION_5","UDM_DESCRIPTION","DESCRIPTION","Customer Stat Group","Desc 1"]
["UDM_FORECAST","UDM_FORECAST","CUST_STAT2","Customer Stat Group","Code 2"]
["UDM_DESCRIPTION_6","UDM_DESCRIPTION","DESCRIPTION","Customer Stat Group","Desc 2"]
["UDM_FORECAST","UDM_FORECAST","CUST_STAT3","Customer Stat Group","Code 3"]
["UDM_DESCRIPTION_7","UDM_DESCRIPTION","DESCRIPTION","Customer Stat Group","Desc 3"]
["UDM_FORECAST","UDM_FORECAST","CUST_STAT4","Customer Stat Group","Code 4"]
["UDM_DESCRIPTION_8","UDM_DESCRIPTION","DESCRIPTION","Customer Stat Group","Desc 4"]
["UDM_FORECAST","UDM_FORECAST","CUST_STAT5","Customer Stat Group","Code 5"]
["UDM_DESCRIPTION_9","UDM_DESCRIPTION","DESCRIPTION","Customer Stat Group","Desc 5"]
["UDM_FORECAST","UDM_FORECAST","CUST_UDF01","Customer UDF 01","Code"]
["UDM_DESCRIPTION_15","UDM_DESCRIPTION","DESCRIPTION","Customer UDF 01","Desc"]
["UDM_FORECAST","UDM_FORECAST","CUST_UDF02","Customer UDF 02","Code"]
["UDM_DESCRIPTION_16","UDM_DESCRIPTION","DESCRIPTION","Customer UDF 02","Desc"]
["UDM_FORECAST","UDM_FORECAST","CUST_UDF03","Customer UDF 03","Code"]
["UDM_DESCRIPTION_17","UDM_DESCRIPTION","DESCRIPTION","Customer UDF 03","Desc"]
["UDM_FORECAST","UDM_FORECAST","CUST_UDF04","Customer UDF 04","Code"]
["UDM_DESCRIPTION_18","UDM_DESCRIPTION","DESCRIPTION","Customer UDF 04","Desc"]
["UDM_FORECAST","UDM_FORECAST","CUST_UDF05","Customer UDF 05","Code"]
["UDM_DESCRIPTION_19","UDM_DESCRIPTION","DESCRIPTION","Customer UDF 05","Desc"]
["UDM_FORECAST","UDM_FORECAST","COUNTRY","Bill-To","Country"]
["UDM_FORECAST","UDM_FORECAST","STATE","Bill-To","State"]
["UDM_FORECAST","UDM_FORECAST","CITY","Bill-To","City"]
["UDM_FORECAST","UDM_FORECAST","PRODUCTID","Product","ID"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","PRODUCTDESC","Product","Name"]
["UDM_FORECAST","UDM_FORECAST","PROD_STAT1","Product Stat Group","Code 1"]
["UDM_DESCRIPTION","UDM_DESCRIPTION","DESCRIPTION","Product Stat Group","Desc 1"]
["UDM_FORECAST","UDM_FORECAST","PROD_STAT2","Product Stat Group","Code 2"]
["UDM_DESCRIPTION_1","UDM_DESCRIPTION","DESCRIPTION","Product Stat Group","Desc 2"]
["UDM_FORECAST","UDM_FORECAST","PROD_STAT3","Product Stat Group","Code 3"]
["UDM_DESCRIPTION_2","UDM_DESCRIPTION","DESCRIPTION","Product Stat Group","Desc 3"]
["UDM_FORECAST","UDM_FORECAST","PROD_STAT4","Product Stat Group","Code 4"]
["UDM_DESCRIPTION_3","UDM_DESCRIPTION","DESCRIPTION","Product Stat Group","Desc 4"]
["UDM_FORECAST","UDM_FORECAST","PROD_STAT5","Product Stat Group","Code 5"]
["UDM_DESCRIPTION_4","UDM_DESCRIPTION","DESCRIPTION","Product Stat Group","Desc 5"]
["UDM_FORECAST","UDM_FORECAST","PROD_UDF01","Product UDF 01","Code"]
["UDM_DESCRIPTION_10","UDM_DESCRIPTION","DESCRIPTION","Product UDF 01","Desc"]
["UDM_FORECAST","UDM_FORECAST","PROD_UDF02","Product UDF 02","Code"]
["UDM_DESCRIPTION_11","UDM_DESCRIPTION","DESCRIPTION","Product UDF 02","Desc"]
["UDM_FORECAST","UDM_FORECAST","PROD_UDF03","Product UDF 03","Code"]
["UDM_DESCRIPTION_12","UDM_DESCRIPTION","DESCRIPTION","Product UDF 03","Desc"]
["UDM_FORECAST","UDM_FORECAST","PROD_UDF04","Product UDF 04","Code"]
["UDM_DESCRIPTION_13","UDM_DESCRIPTION","DESCRIPTION","Product UDF 04","Desc"]
["UDM_FORECAST","UDM_FORECAST","PROD_UDF05","Product UDF 05","Code"]
["UDM_DESCRIPTION_14","UDM_DESCRIPTION","DESCRIPTION","Product UDF 05","Desc"]
["UDM_FORECAST","UDM_FORECAST","DUMMY",null,"Dummy"]
["UDM_FORECAST_JOIN","UDM_FORECAST_JOIN","REVISION_NUM","For Join","Revision Number"]
["*SERVER","*SERVER","FLD0000009","Actual","Amount","CASE\nWHEN UDM_FORECAST_JOIN.TIME_TYPE = 'MONTH'\nAND UDM_FORECAST_JOIN.F_PERIOD = UDM_FORECAST_JOIN.F_CUMPERIOD\nTHEN [Actual Cumulative Amount]\n\nWHEN UDM_FORECAST_JOIN.TIME_TYPE = 'QUARTER'\nAND UDM_FORECAST_JOIN.F_PERIOD BETWEEN UDM_FORECAST_JOIN.F_CUMPERIOD - 2 AND UDM_FORECAST_JOIN.F_CUMPERIOD\nTHEN [Actual Cumulative Amount]\nEND"]
["*SERVER","*SERVER","FLD0000003","Forecast","Amount","CASE\nWHEN [Forecast Name] = '$$FORECAST_NAME'\nAND [Revision Number] = '$$REVISION_NUM'\nAND [Forecast Type] = 'AMT'\nAND UDM_FORECAST_JOIN.F_PERIOD = UDM_FORECAST_JOIN.F_CUMPERIOD\n\nTHEN UDM_FORECAST.FCSTAMT\nEND"]
["*SERVER","*SERVER","FLD0000007","Last Year","Amount","CASE\nWHEN [Forecast Name] = '$$FORECAST_NAME'\nAND [Revision Number] = '$$REVISION_NUM'\nAND [Forecast Type] = 'AMT'\nAND UDM_FORECAST_JOIN.F_PERIOD = UDM_FORECAST_JOIN.F_CUMPERIOD\n\nTHEN UDM_FORECAST.LYAMT\nEND"]
["*SERVER","*SERVER","FLD00000010","Actual","Quantity","CASE\nWHEN UDM_FORECAST_JOIN.TIME_TYPE = 'MONTH'\nAND UDM_FORECAST_JOIN.F_PERIOD = UDM_FORECAST_JOIN.F_CUMPERIOD\nTHEN [Actual Cumulative Quantity]\n\nWHEN UDM_FORECAST_JOIN.TIME_TYPE = 'QUARTER'\nAND UDM_FORECAST_JOIN.F_PERIOD BETWEEN UDM_FORECAST_JOIN.F_CUMPERIOD - 2 AND UDM_FORECAST_JOIN.F_CUMPERIOD\nTHEN [Actual Cumulative Quantity]\nEND"]
["*SERVER","*SERVER","FLD0000004","Forecast","Quantity","CASE\nWHEN [Forecast Name] = '$$FORECAST_NAME'\nAND [Revision Number] = '$$REVISION_NUM'\nAND [Forecast Type] = 'QTY'\nAND UDM_FORECAST_JOIN.F_PERIOD = UDM_FORECAST_JOIN.F_CUMPERIOD\n\nTHEN UDM_FORECAST.FCSTQTY\nEND"]
["*SERVER","*SERVER","FLD0000008","Last Year","Quantity","CASE\nWHEN [Forecast Name] = '$$FORECAST_NAME'\nAND [Revision Number] = '$$REVISION_NUM'\nAND [Forecast Type] = 'QTY'\nAND UDM_FORECAST_JOIN.F_PERIOD = UDM_FORECAST_JOIN.F_CUMPERIOD\n\nTHEN UDM_FORECAST.LYQTY\nEND"]
["UDM_FORECAST","UDM_FORECAST","SALESAMT","Actual","Cumulative Amount"]
["*SERVER","*SERVER","FLD0000005","Forecast","Cumulative Amount","CASE\nWHEN [Forecast Name] = '$$FORECAST_NAME'\nAND [Revision Number] = '$$REVISION_NUM'\nAND [Forecast Type] = 'AMT'\n\nTHEN UDM_FORECAST.FCSTAMT\nEND"]
["*SERVER","*SERVER","FLD0000001","Last Year","Cumulative Amount","CASE\nWHEN [Forecast Name] = '$$FORECAST_NAME'\nAND [Revision Number] = '$$REVISION_NUM'\nAND [Forecast Type] = 'AMT'\n\nTHEN UDM_FORECAST.LYAMT\nEND"]
["*SERVER","*SERVER","FLD00000013","Actual/Forecast Index","By Period",0,"if([Forecast Amount] !== 0)\nnecResult = [Actual Amount] / [Forecast Amount];\nelse\nnecResult = 0;"]
["*SERVER","*SERVER","FLD00000012","Actual/Forecast Index","Cumulative",0,"try {\nif([Forecast Cumulative Amount] !== 0)\nnecResult = [Actual Cumulative Amount] / [Forecast Cumulative Amount];\nelse\nnecResult = 0;\n}\ncatch(err) {\nnecResult = '';\n}"]
["*SERVER","*SERVER","FLD00000024","Actual/Last Year Index","By Period",0,"if([Last Year Amount] !== 0)\nnecResult = [Actual Amount] / [Last Year Amount];\nelse\nnecResult = 0;"]
["*SERVER","*SERVER","FLD00000025","Actual/Last Year Index","Cumulative",0,"try {\nif([Last Year Cumulative Amount] !== 0)\nnecResult = [Actual Cumulative Amount] / [Last Year Cumulative Amount];\nelse\nnecResult = 0;\n}\ncatch(err) {\nnecResult = '';\n}"]
["UDM_FORECAST","UDM_FORECAST","SALESQTY","Actual","Cumulative Quantity"]
["*SERVER","*SERVER","FLD0000006","Forecast","Cumulative Quantity","CASE\nWHEN [Forecast Name] = '$$FORECAST_NAME'\nAND [Revision Number] = '$$REVISION_NUM'\nAND [Forecast Type] = 'QTY'\n\nTHEN UDM_FORECAST.FCSTAMT\nEND"]
["*SERVER","*SERVER","FLD0000002","Last Year","Cumulative Quantity","CASE\nWHEN [Forecast Name] = '$$FORECAST_NAME'\nAND [Revision Number] = '$$REVISION_NUM'\nAND [Forecast Type] = 'QTY'\n\nTHEN UDM_FORECAST.LYAMT\nEND"]
["*SERVER","*SERVER","FLD00000014","Actual/Forecast","Type","CASE\nWHEN UDM_FORECAST_JOIN.TIME_TYPE = 'MONTH'\n\tAND ((UDM_FORECAST_JOIN.F_LASTPERIOD < $$CUT_OFF_PER\n\tAND UDM_FORECAST_JOIN.F_CUMPERIOD <= $$CUT_OFF_PER\n\tAND UDM_FORECAST_JOIN.F_CUMPERIOD > UDM_FORECAST_JOIN.F_LASTPERIOD)\n\n\tOR (UDM_FORECAST_JOIN.F_LASTPERIOD >= $$CUT_OFF_PER\n\tAND (UDM_FORECAST_JOIN.F_CUMPERIOD > UDM_FORECAST_JOIN.F_LASTPERIOD\n\tOR UDM_FORECAST_JOIN.F_CUMPERIOD <= $$CUT_OFF_PER)\n))\nAND UDM_FORECAST_JOIN.F_PERIOD = UDM_FORECAST_JOIN.F_CUMPERIOD\nTHEN 'Actual'\n\n\nWHEN UDM_FORECAST_JOIN.TIME_TYPE = 'QUARTER'\n\tAND ((UDM_FORECAST_JOIN.F_LASTPERIOD < $$CUT_OFF_PER * 3\n\tAND UDM_FORECAST_JOIN.F_CUMPERIOD <= $$CUT_OFF_PER * 3\n\tAND UDM_FORECAST_JOIN.F_CUMPERIOD > UDM_FORECAST_JOIN.F_LASTPERIOD)\n\n\tOR (UDM_FORECAST_JOIN.F_LASTPERIOD >= $$CUT_OFF_PER * 3\n\tAND (UDM_FORECAST_JOIN.F_CUMPERIOD > UDM_FORECAST_JOIN.F_LASTPERIOD\n\tOR UDM_FORECAST_JOIN.F_CUMPERIOD <= $$CUT_OFF_PER * 3)\n))\nAND UDM_FORECAST_JOIN.F_PERIOD BETWEEN UDM_FORECAST_JOIN.F_CUMPERIOD - 2 AND UDM_FORECAST_JOIN.F_CUMPERIOD\nTHEN 'Actual'\n\n\nWHEN UDM_FORECAST_JOIN.TIME_TYPE = 'MONTH'\n\tAND ((UDM_FORECAST_JOIN.F_LASTPERIOD < $$CUT_OFF_PER\n\tAND (UDM_FORECAST_JOIN.F_CUMPERIOD > $$CUT_OFF_PER\n\tOR UDM_FORECAST_JOIN.F_CUMPERIOD <= UDM_FORECAST_JOIN.F_LASTPERIOD))\n\n\tOR (UDM_FORECAST_JOIN.F_LASTPERIOD >= $$CUT_OFF_PER\n\tAND (UDM_FORECAST_JOIN.F_CUMPERIOD <= UDM_FORECAST_JOIN.F_LASTPERIOD\n\tAND UDM_FORECAST_JOIN.F_CUMPERIOD > $$CUT_OFF_PER)\n))\nAND UDM_FORECAST_JOIN.F_PERIOD = UDM_FORECAST_JOIN.F_CUMPERIOD\nAND [Forecast Name] = '$$FORECAST_NAME'\nAND [Revision Number] = $$REVISION_NUM\nAND [Forecast Type] = 'AMT'\nTHEN 'Forecast'\n\n\nWHEN UDM_FORECAST_JOIN.TIME_TYPE = 'QUARTER'\n\tAND ((UDM_FORECAST_JOIN.F_LASTPERIOD < $$CUT_OFF_PER * 3\n\tAND (UDM_FORECAST_JOIN.F_CUMPERIOD > $$CUT_OFF_PER * 3\n\tOR UDM_FORECAST_JOIN.F_CUMPERIOD <= UDM_FORECAST_JOIN.F_LASTPERIOD))\n\n\tOR (UDM_FORECAST_JOIN.F_LASTPERIOD >= $$CUT_OFF_PER * 3\n\tAND (UDM_FORECAST_JOIN.F_CUMPERIOD <= UDM_FORECAST_JOIN.F_LASTPERIOD\n\tAND UDM_FORECAST_JOIN.F_CUMPERIOD > $$CUT_OFF_PER * 3)\n))\nAND UDM_FORECAST_JOIN.F_PERIOD = UDM_FORECAST_JOIN.F_CUMPERIOD\nAND [Forecast Name] = '$$FORECAST_NAME'\nAND [Revision Number] = $$REVISION_NUM\nAND [Forecast Type] = 'AMT'\nTHEN 'Forecast'\nEND"]
["*SERVER","*SERVER","FLD00000015","Actual/Forecast","Amount","CASE\nWHEN UDM_FORECAST_JOIN.TIME_TYPE = 'MONTH'\n\tAND ((UDM_FORECAST_JOIN.F_LASTPERIOD < $$CUT_OFF_PER\n\tAND UDM_FORECAST_JOIN.F_CUMPERIOD <= $$CUT_OFF_PER\n\tAND UDM_FORECAST_JOIN.F_CUMPERIOD > UDM_FORECAST_JOIN.F_LASTPERIOD)\n\n\tOR (UDM_FORECAST_JOIN.F_LASTPERIOD >= $$CUT_OFF_PER\n\tAND (UDM_FORECAST_JOIN.F_CUMPERIOD > UDM_FORECAST_JOIN.F_LASTPERIOD\n\tOR UDM_FORECAST_JOIN.F_CUMPERIOD <= $$CUT_OFF_PER)\n))\nAND UDM_FORECAST_JOIN.F_PERIOD = UDM_FORECAST_JOIN.F_CUMPERIOD\nTHEN [Actual Cumulative Amount]\n\n\nWHEN UDM_FORECAST_JOIN.TIME_TYPE = 'QUARTER'\n\tAND ((UDM_FORECAST_JOIN.F_LASTPERIOD < $$CUT_OFF_PER * 3\n\tAND UDM_FORECAST_JOIN.F_CUMPERIOD <= $$CUT_OFF_PER * 3\n\tAND UDM_FORECAST_JOIN.F_CUMPERIOD > UDM_FORECAST_JOIN.F_LASTPERIOD)\n\n\tOR (UDM_FORECAST_JOIN.F_LASTPERIOD >= $$CUT_OFF_PER * 3\n\tAND (UDM_FORECAST_JOIN.F_CUMPERIOD > UDM_FORECAST_JOIN.F_LASTPERIOD\n\tOR UDM_FORECAST_JOIN.F_CUMPERIOD <= $$CUT_OFF_PER * 3)\n))\nAND UDM_FORECAST_JOIN.F_PERIOD BETWEEN UDM_FORECAST_JOIN.F_CUMPERIOD - 2 AND UDM_FORECAST_JOIN.F_CUMPERIOD\nTHEN [Actual Cumulative Amount]\n\n\nWHEN UDM_FORECAST_JOIN.TIME_TYPE = 'MONTH'\n\tAND ((UDM_FORECAST_JOIN.F_LASTPERIOD < $$CUT_OFF_PER\n\tAND (UDM_FORECAST_JOIN.F_CUMPERIOD > $$CUT_OFF_PER\n\tOR UDM_FORECAST_JOIN.F_CUMPERIOD <= UDM_FORECAST_JOIN.F_LASTPERIOD))\n\n\tOR (UDM_FORECAST_JOIN.F_LASTPERIOD >= $$CUT_OFF_PER\n\tAND (UDM_FORECAST_JOIN.F_CUMPERIOD <= UDM_FORECAST_JOIN.F_LASTPERIOD\n\tAND UDM_FORECAST_JOIN.F_CUMPERIOD > $$CUT_OFF_PER)\n))\nAND UDM_FORECAST_JOIN.F_PERIOD = UDM_FORECAST_JOIN.F_CUMPERIOD\nAND [Forecast Name] = '$$FORECAST_NAME'\nAND [Revision Number] = $$REVISION_NUM\nAND [Forecast Type] = 'AMT'\nTHEN UDM_FORECAST.FCSTAMT\n\n\nWHEN UDM_FORECAST_JOIN.TIME_TYPE = 'QUARTER'\n\tAND ((UDM_FORECAST_JOIN.F_LASTPERIOD < $$CUT_OFF_PER * 3\n\tAND (UDM_FORECAST_JOIN.F_CUMPERIOD > $$CUT_OFF_PER * 3\n\tOR UDM_FORECAST_JOIN.F_CUMPERIOD <= UDM_FORECAST_JOIN.F_LASTPERIOD))\n\n\tOR (UDM_FORECAST_JOIN.F_LASTPERIOD >= $$CUT_OFF_PER * 3\n\tAND (UDM_FORECAST_JOIN.F_CUMPERIOD <= UDM_FORECAST_JOIN.F_LASTPERIOD\n\tAND UDM_FORECAST_JOIN.F_CUMPERIOD > $$CUT_OFF_PER * 3)\n))\nAND UDM_FORECAST_JOIN.F_PERIOD = UDM_FORECAST_JOIN.F_CUMPERIOD\nAND [Forecast Name] = '$$FORECAST_NAME'\nAND [Revision Number] = $$REVISION_NUM\nAND [Forecast Type] = 'AMT'\nTHEN UDM_FORECAST.FCSTAMT\nEND"]
["*SERVER","*SERVER","FLD00000022",null,"Expected Sales","CASE\nWHEN UDM_FORECAST_JOIN.TIME_TYPE = 'MONTH'\n\tAND ((UDM_FORECAST_JOIN.F_LASTPERIOD < $$CUT_OFF_PER\n\tAND UDM_FORECAST_JOIN.F_PERIOD <= $$CUT_OFF_PER\n\tAND UDM_FORECAST_JOIN.F_PERIOD > UDM_FORECAST_JOIN.F_LASTPERIOD)\n\n\tOR (UDM_FORECAST_JOIN.F_LASTPERIOD >= $$CUT_OFF_PER\n\tAND (UDM_FORECAST_JOIN.F_PERIOD > UDM_FORECAST_JOIN.F_LASTPERIOD\n\tOR UDM_FORECAST_JOIN.F_PERIOD <= $$CUT_OFF_PER)\n))\nTHEN [Actual Cumulative Amount]\n\nWHEN UDM_FORECAST_JOIN.TIME_TYPE = 'MONTH'\n\tAND ((UDM_FORECAST_JOIN.F_LASTPERIOD < $$CUT_OFF_PER\n\tAND (UDM_FORECAST_JOIN.F_PERIOD > $$CUT_OFF_PER\n\tOR UDM_FORECAST_JOIN.F_PERIOD <= UDM_FORECAST_JOIN.F_LASTPERIOD))\n\n\tOR (UDM_FORECAST_JOIN.F_LASTPERIOD >= $$CUT_OFF_PER\n\tAND (UDM_FORECAST_JOIN.F_PERIOD <= UDM_FORECAST_JOIN.F_LASTPERIOD\n\tAND UDM_FORECAST_JOIN.F_PERIOD > $$CUT_OFF_PER)\n))\nAND [Forecast Name] = '$$FORECAST_NAME'\nAND [Revision Number] = $$REVISION_NUM\nAND [Forecast Type] = 'AMT'\nTHEN UDM_FORECAST.FCSTAMT\n\n\nWHEN UDM_FORECAST_JOIN.TIME_TYPE = 'QUARTER'\n\tAND ((UDM_FORECAST_JOIN.F_LASTPERIOD < $$CUT_OFF_PER * 3\n\tAND UDM_FORECAST_JOIN.F_PERIOD <= $$CUT_OFF_PER * 3\n\tAND UDM_FORECAST_JOIN.F_PERIOD > UDM_FORECAST_JOIN.F_LASTPERIOD)\n\n\tOR (UDM_FORECAST_JOIN.F_LASTPERIOD >= $$CUT_OFF_PER * 3\n\tAND (UDM_FORECAST_JOIN.F_PERIOD > UDM_FORECAST_JOIN.F_LASTPERIOD\n\tOR UDM_FORECAST_JOIN.F_PERIOD <= $$CUT_OFF_PER * 3)\n))\nTHEN [Actual Cumulative Amount]\n\nWHEN UDM_FORECAST_JOIN.TIME_TYPE = 'QUARTER'\n\tAND ((UDM_FORECAST_JOIN.F_LASTPERIOD < $$CUT_OFF_PER * 3\n\tAND (UDM_FORECAST_JOIN.F_PERIOD > $$CUT_OFF_PER * 3\n\tOR UDM_FORECAST_JOIN.F_PERIOD <= UDM_FORECAST_JOIN.F_LASTPERIOD))\n\n\tOR (UDM_FORECAST_JOIN.F_LASTPERIOD >= $$CUT_OFF_PER * 3\n\tAND (UDM_FORECAST_JOIN.F_PERIOD <= UDM_FORECAST_JOIN.F_LASTPERIOD\n\tAND UDM_FORECAST_JOIN.F_PERIOD > $$CUT_OFF_PER * 3)\n))\nAND [Forecast Name] = '$$FORECAST_NAME'\nAND [Revision Number] = $$REVISION_NUM\nAND [Forecast Type] = 'AMT'\nTHEN UDM_FORECAST.FCSTAMT\nEND"]
["*SERVER","*SERVER","FLD00000018","Cut Off","Actual Amount","CASE\nWHEN UDM_FORECAST_JOIN.TIME_TYPE = 'MONTH'\n\tAND ((UDM_FORECAST_JOIN.F_LASTPERIOD < $$CUT_OFF_PER\n\tAND UDM_FORECAST_JOIN.F_CUMPERIOD <= $$CUT_OFF_PER\n\tAND UDM_FORECAST_JOIN.F_CUMPERIOD > UDM_FORECAST_JOIN.F_LASTPERIOD)\n\n\tOR (UDM_FORECAST_JOIN.F_LASTPERIOD >= $$CUT_OFF_PER\n\tAND (UDM_FORECAST_JOIN.F_CUMPERIOD > UDM_FORECAST_JOIN.F_LASTPERIOD\n\tOR UDM_FORECAST_JOIN.F_CUMPERIOD <= $$CUT_OFF_PER)\n))\nAND UDM_FORECAST_JOIN.F_PERIOD = UDM_FORECAST_JOIN.F_CUMPERIOD\nTHEN [Actual Cumulative Amount]\n\nWHEN UDM_FORECAST_JOIN.TIME_TYPE = 'QUARTER'\n\tAND ((UDM_FORECAST_JOIN.F_LASTPERIOD < $$CUT_OFF_PER * 3\n\tAND UDM_FORECAST_JOIN.F_CUMPERIOD <= $$CUT_OFF_PER * 3\n\tAND UDM_FORECAST_JOIN.F_CUMPERIOD > UDM_FORECAST_JOIN.F_LASTPERIOD)\n\n\tOR (UDM_FORECAST_JOIN.F_LASTPERIOD >= $$CUT_OFF_PER * 3\n\tAND (UDM_FORECAST_JOIN.F_CUMPERIOD > UDM_FORECAST_JOIN.F_LASTPERIOD\n\tOR UDM_FORECAST_JOIN.F_CUMPERIOD <= $$CUT_OFF_PER * 3)\n))\nAND UDM_FORECAST_JOIN.F_PERIOD BETWEEN UDM_FORECAST_JOIN.F_CUMPERIOD - 2 AND UDM_FORECAST_JOIN.F_CUMPERIOD\nTHEN [Actual Cumulative Amount]\nEND"]
["*SERVER","*SERVER","FLD00000019","Cut Off","Forecast Amount","CASE\nWHEN UDM_FORECAST_JOIN.TIME_TYPE = 'MONTH'\n\tAND ((UDM_FORECAST_JOIN.F_LASTPERIOD < $$CUT_OFF_PER\n\tAND (UDM_FORECAST_JOIN.F_CUMPERIOD > $$CUT_OFF_PER\n\tOR UDM_FORECAST_JOIN.F_CUMPERIOD <= UDM_FORECAST_JOIN.F_LASTPERIOD))\n\n\tOR (UDM_FORECAST_JOIN.F_LASTPERIOD >= $$CUT_OFF_PER\n\tAND (UDM_FORECAST_JOIN.F_CUMPERIOD <= UDM_FORECAST_JOIN.F_LASTPERIOD\n\tAND UDM_FORECAST_JOIN.F_CUMPERIOD > $$CUT_OFF_PER)\n))\nAND UDM_FORECAST_JOIN.F_PERIOD = UDM_FORECAST_JOIN.F_CUMPERIOD\nAND [Forecast Name] = '$$FORECAST_NAME'\nAND [Revision Number] = $$REVISION_NUM\nAND [Forecast Type] = 'AMT'\nTHEN UDM_FORECAST.FCSTAMT\n\nWHEN UDM_FORECAST_JOIN.TIME_TYPE = 'QUARTER'\n\tAND ((UDM_FORECAST_JOIN.F_LASTPERIOD < $$CUT_OFF_PER * 3\n\tAND (UDM_FORECAST_JOIN.F_CUMPERIOD > $$CUT_OFF_PER * 3\n\tOR UDM_FORECAST_JOIN.F_CUMPERIOD <= UDM_FORECAST_JOIN.F_LASTPERIOD))\n\n\tOR (UDM_FORECAST_JOIN.F_LASTPERIOD >= $$CUT_OFF_PER * 3\n\tAND (UDM_FORECAST_JOIN.F_CUMPERIOD <= UDM_FORECAST_JOIN.F_LASTPERIOD\n\tAND UDM_FORECAST_JOIN.F_CUMPERIOD > $$CUT_OFF_PER * 3)\n))\nAND UDM_FORECAST_JOIN.F_PERIOD = UDM_FORECAST_JOIN.F_CUMPERIOD\nAND [Forecast Name] = '$$FORECAST_NAME'\nAND [Revision Number] = $$REVISION_NUM\nAND [Forecast Type] = 'AMT'\nTHEN UDM_FORECAST.FCSTAMT\nEND"]
["*SERVER","*SERVER","FLD00000020","Cumulative Cut Off","Actual Amount","CASE\nWHEN UDM_FORECAST_JOIN.TIME_TYPE = 'MONTH'\n\tAND ((UDM_FORECAST_JOIN.F_LASTPERIOD < $$CUT_OFF_PER\n\tAND UDM_FORECAST_JOIN.F_PERIOD <= $$CUT_OFF_PER\n\tAND UDM_FORECAST_JOIN.F_PERIOD > UDM_FORECAST_JOIN.F_LASTPERIOD)\n\n\tOR (UDM_FORECAST_JOIN.F_LASTPERIOD >= $$CUT_OFF_PER\n\tAND (UDM_FORECAST_JOIN.F_PERIOD > UDM_FORECAST_JOIN.F_LASTPERIOD\n\tOR UDM_FORECAST_JOIN.F_PERIOD <= $$CUT_OFF_PER)\n))\nTHEN [Actual Cumulative Amount]\n\n\nWHEN UDM_FORECAST_JOIN.TIME_TYPE = 'QUARTER'\n\tAND ((UDM_FORECAST_JOIN.F_LASTPERIOD < $$CUT_OFF_PER * 3\n\tAND UDM_FORECAST_JOIN.F_PERIOD <= $$CUT_OFF_PER * 3\n\tAND UDM_FORECAST_JOIN.F_PERIOD > UDM_FORECAST_JOIN.F_LASTPERIOD)\n\n\tOR (UDM_FORECAST_JOIN.F_LASTPERIOD >= $$CUT_OFF_PER * 3\n\tAND (UDM_FORECAST_JOIN.F_PERIOD > UDM_FORECAST_JOIN.F_LASTPERIOD\n\tOR UDM_FORECAST_JOIN.F_PERIOD <= $$CUT_OFF_PER * 3)\n))\nTHEN [Actual Cumulative Amount]\nEND"]
["*SERVER","*SERVER","FLD00000021","Cumulative Cut Off","Forecast Amount","CASE\nWHEN UDM_FORECAST_JOIN.TIME_TYPE = 'MONTH'\n\tAND ((UDM_FORECAST_JOIN.F_LASTPERIOD < $$CUT_OFF_PER\n\tAND (UDM_FORECAST_JOIN.F_PERIOD > $$CUT_OFF_PER\n\tOR UDM_FORECAST_JOIN.F_PERIOD <= UDM_FORECAST_JOIN.F_LASTPERIOD))\n\n\tOR (UDM_FORECAST_JOIN.F_LASTPERIOD >= $$CUT_OFF_PER\n\tAND (UDM_FORECAST_JOIN.F_PERIOD <= UDM_FORECAST_JOIN.F_LASTPERIOD\n\tAND UDM_FORECAST_JOIN.F_PERIOD > $$CUT_OFF_PER)\n))\nAND [Forecast Name] = '$$FORECAST_NAME'\nAND [Revision Number] = $$REVISION_NUM\nAND [Forecast Type] = 'AMT'\nTHEN UDM_FORECAST.FCSTAMT\n\nWHEN UDM_FORECAST_JOIN.TIME_TYPE = 'QUARTER'\n\tAND ((UDM_FORECAST_JOIN.F_LASTPERIOD < $$CUT_OFF_PER * 3\n\tAND (UDM_FORECAST_JOIN.F_PERIOD > $$CUT_OFF_PER * 3\n\tOR UDM_FORECAST_JOIN.F_PERIOD <= UDM_FORECAST_JOIN.F_LASTPERIOD))\n\n\tOR (UDM_FORECAST_JOIN.F_LASTPERIOD >= $$CUT_OFF_PER * 3\n\tAND (UDM_FORECAST_JOIN.F_PERIOD <= UDM_FORECAST_JOIN.F_LASTPERIOD\n\tAND UDM_FORECAST_JOIN.F_PERIOD > $$CUT_OFF_PER * 3)\n))\nAND [Forecast Name] = '$$FORECAST_NAME'\nAND [Revision Number] = $$REVISION_NUM\nAND [Forecast Type] = 'AMT'\nTHEN UDM_FORECAST.FCSTAMT\nEND"]

{"sheet":"490000006","index":3,"n_rows":192,"n_cols":7,"rows_kept":192,"cut":false,"hidden":false,"merged":[]}
["Main Menu"]
["tableAlias","tableName","name","columnGroupHeading","columnHeading","calculation","Oncalculation"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","CALENDARYEAR","Calendar","Year"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","CALENDARQUARTER","Calendar","Quarter"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","CALENDARPERIOD","Calendar","Period"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","COMPANYID","Company","ID"]
["UDM_DIMCOMPANY","UDM_DIMCOMPANY","COMPANYNAME","Company","Name"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","SITEID","Site","ID"]
["UDM_DIMSITES","UDM_DIMSITES","FCYNAM","Site","Name"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","WAREHOUSEID","Warehouse","ID"]
["UDM_DIMWAREHOUSE","UDM_DIMWAREHOUSE","WRHNAM","Warehouse","Name"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","SALESREPID1","Sales Rep","ID"]
["UDM_DIMSALESREP","UDM_DIMSALESREP","SALESREPNAME","Sales Rep","Name"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","DEFSALESREPID","Default Sales Rep","ID"]
["UDM_DIMSALESREP_1","UDM_DIMSALESREP","SALESREPNAME","Default Sales Rep","Name"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","PRODUCTID","Product","ID"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","PRODUCTDESC","Product","Name"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","PRODUCTLINE","Product","Line"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","STATGROUP1","Product Stat Group","Code 1"]
["UDM_DESCRIPTION","UDM_DESCRIPTION","DESCRIPTION","Product Stat Group","Desc 1"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","STATGROUP2","Product Stat Group","Code 2"]
["UDM_DESCRIPTION_1","UDM_DESCRIPTION","DESCRIPTION","Product Stat Group","Desc 2"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","STATGROUP3","Product Stat Group","Code 3"]
["UDM_DESCRIPTION_2","UDM_DESCRIPTION","DESCRIPTION","Product Stat Group","Desc 3"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","STATGROUP4","Product Stat Group","Code 4"]
["UDM_DESCRIPTION_3","UDM_DESCRIPTION","DESCRIPTION","Product Stat Group","Desc 4"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","STATGROUP5","Product Stat Group","Code 5"]
["UDM_DESCRIPTION_4","UDM_DESCRIPTION","DESCRIPTION","Product Stat Group","Desc 5"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD01","Product UDF 01","Code"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD01DESC","Product UDF 01","Desc"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD02","Product UDF 02","Code"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD02DESC","Product UDF 02","Desc"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD03","Product UDF 03","Code"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD03DESC","Product UDF 03","Desc"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD04","Product UDF 04","Code"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD04DESC","Product UDF 04","Desc"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD05","Product UDF 05","Code"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD05DESC","Product UDF 05","Desc"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD06","Product UDF 06","Code"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD06DESC","Product UDF 06","Desc"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD07","Product UDF 07","Code"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD07DESC","Product UDF 07","Desc"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD08","Product UDF 08","Code"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD08DESC","Product UDF 08","Desc"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD09","Product UDF 09","Code"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD09DESC","Product UDF 09","Desc"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD10","Product UDF 10","Code"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD10DESC","Product UDF 10","Desc"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","CLIENTID","Customer","ID"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","CLIENTNAME","Customer","Name"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","CLIENTGROUP","Customer","Group"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","CLIENTRISK","Customer","Risk"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","CLIENTTYPE","Customer","Type"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","STATGROUP1","Customer Stat Group","Code 1"]
["UDM_DESCRIPTION_10","UDM_DESCRIPTION","DESCRIPTION","Customer Stat Group","Desc 1"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","STATGROUP2","Customer Stat Group","Code 2"]
["UDM_DESCRIPTION_11","UDM_DESCRIPTION","DESCRIPTION","Customer Stat Group","Desc 2"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","STATGROUP3","Customer Stat Group","Code 3"]
["UDM_DESCRIPTION_12","UDM_DESCRIPTION","DESCRIPTION","Customer Stat Group","Desc 3"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","STATGROUP4","Customer Stat Group","Code 4"]
["UDM_DESCRIPTION_13","UDM_DESCRIPTION","DESCRIPTION","Customer Stat Group","Desc 4"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","STATGROUP5","Customer Stat Group","Code 5"]
["UDM_DESCRIPTION_14","UDM_DESCRIPTION","DESCRIPTION","Customer Stat Group","Desc 5"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD01","Customer UDF 01","Code"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD01DESC","Customer UDF 01","Desc"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD02","Customer UDF 02","Code"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD02DESC","Customer UDF 02","Desc"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD03","Customer UDF 03","Code"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD03DESC","Customer UDF 03","Desc"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD04","Customer UDF 04","Code"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD04DESC","Customer UDF 04","Desc"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD05","Customer UDF 05","Code"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD05DESC","Customer UDF 05","Desc"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD06","Customer UDF 06","Code"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD06DESC","Customer UDF 06","Desc"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD07","Customer UDF 07","Code"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD07DESC","Customer UDF 07","Desc"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD08","Customer UDF 08","Code"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD08DESC","Customer UDF 08","Desc"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD09","Customer UDF 09","Code"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD09DESC","Customer UDF 09","Desc"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD10","Customer UDF 10","Code"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD10DESC","Customer UDF 10","Desc"]
["UDM_DIMADDRESS","UDM_DIMADDRESS","COUNTRY","Bill-To","Country Code"]
["UDM_DIMADDRESS","UDM_DIMADDRESS","COUNTRYDESC","Bill-To","Country Name"]
["UDM_DIMADDRESS","UDM_DIMADDRESS","PROVINCESTATE","Bill-To","State Code"]
["UDM_DIMADDRESS","UDM_DIMADDRESS","PROVINCESTATEDESC","Bill-To","State Name"]
["UDM_DIMADDRESS","UDM_DIMADDRESS","CITY","Bill-To","City"]
["UDM_POSTALCODE_ZIP_LAT_LNG","UDM_POSTALCODE_ZIP_LAT_LNG","POSTALCODEZIP","Bill-To","Postal Code"]
["UDM_POSTALCODE_ZIP_LAT_LNG","UDM_POSTALCODE_ZIP_LAT_LNG","LAT","Bill-To","Latitude"]
["UDM_POSTALCODE_ZIP_LAT_LNG","UDM_POSTALCODE_ZIP_LAT_LNG","LNG","Bill-To","Longitude"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","LEDCUR","Ledger","Currency"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","INVOICEQTY","Invoice","Quantity"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","INVOICEQTYLM","Invoice","Quantity LM"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","INVOICEQTYLQ","Invoice","Quantity LQ"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","INVOICEQTYLY","Invoice","Quantity LY"]
["*SERVER","*SERVER","FLD0000008","Invoice Quantity","M to M Growth %",0,"if ([Invoice Quantity LM] !== 0)\nnecResult = ([Invoice Quantity] / [Invoice Quantity LM]) - 1;\n\nelse\nnecResult = 0;"]
["*SERVER","*SERVER","FLD0000009","Invoice Quantity","Q to Q Growth %",0,"if ([Invoice Quantity LQ] !== 0)\nnecResult = ([Invoice Quantity] / [Invoice Quantity LQ]) - 1;\n\nelse\nnecResult = 0;"]
["*SERVER","*SERVER","FLD00000010","Invoice Quantity","Y to Y Growth %",0,"if ([Invoice Quantity LY] !== 0)\nnecResult = ([Invoice Quantity] / [Invoice Quantity LY]) - 1;\n\nelse\nnecResult = 0;"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","INVAMTLED","Invoice","Amount"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","INVAMTLM","Invoice","Amount LM"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","INVAMTLQ","Invoice","Amount LQ"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","INVAMTLY","Invoice","Amount LY"]
["*SERVER","*SERVER","FLD0000001","Invoice Amount","M to M Growth %",0,"if([Invoice Amount LM] !== 0)\nnecResult= ([Invoice Amount] - [Invoice Amount LM])/[Invoice Amount LM];\n\nelse\nnecResult = 0;"]
["*SERVER","*SERVER","FLD0000002","Invoice Amount","Q to Q Growth %",0,"if([Invoice Amount LQ] !== 0)\nnecResult= ([Invoice Amount] - [Invoice Amount LQ])/[Invoice Amount LQ] ;\n\nelse\nnecResult = 0;"]
["*SERVER","*SERVER","FLD0000003","Invoice Amount","Y to Y Growth %",0,"if([Invoice Amount LY] !== 0)\nnecResult= ([Invoice Amount] - [Invoice Amount LY])/[Invoice Amount LY] ;\n\nelse\nnecResult = 0;"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","EXTCST","Invoice","Cost"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","EXTCSTLM","Invoice","Cost LM"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","EXTCSTLQ","Invoice","Cost LQ"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","EXTCSTLY","Invoice","Cost LY"]
["*SERVER","*SERVER","FLD00000011","Invoice Cost","M to M Growth %",0,"if([Invoice Cost LM] !== 0)\nnecResult= ([Invoice Cost] / [Invoice Cost LM]) - 1;\n\nelse\nnecResult = 0;"]
["*SERVER","*SERVER","FLD00000012","Invoice Cost","Q to Q Growth %",0,"if([Invoice Cost LQ] !== 0)\nnecResult= ([Invoice Cost] / [Invoice Cost LQ]) - 1;\n\nelse\nnecResult = 0;"]
["*SERVER","*SERVER","FLD00000013","Invoice Cost","Y to Y Growth %",0,"if([Invoice Cost LY] !== 0)\nnecResult= ([Invoice Cost] / [Invoice Cost LY]) - 1;\n\nelse\nnecResult = 0;"]
["*SERVER","*SERVER","FLD0000005","Invoice","Margin","[Invoice Amount] - UDM_SALES_SUMMARIZED.EXTCST"]
["*SERVER","*SERVER","FLD0000004","Invoice","Margin %",0,"if([Invoice Amount] !== 0)\nnecResult= ([Invoice Amount] - [Invoice Cost])/[Invoice Amount] ;\n\nelse\nnecResult = 0;"]
["*SERVER","*SERVER","FLD00000014","Invoice","Margin LM","[Invoice Amount LM] - UDM_SALES_SUMMARIZED.EXTCSTLM"]
["*SERVER","*SERVER","FLD00000019","Invoice","Margin % LM",0,"if([Invoice Amount LM]!== 0)\nnecResult= ([Invoice Amount LM] - [Invoice Cost LM])/[Invoice Amount LM];\n\nelse\nnecResult = 0;"]
["*SERVER","*SERVER","FLD00000015","Invoice","Margin LQ","[Invoice Amount LQ] - UDM_SALES_SUMMARIZED.EXTCSTLQ"]
["*SERVER","*SERVER","FLD00000020","Invoice","Margin % LQ",0,"if([Invoice Amount LQ]!== 0)\nnecResult= ([Invoice Amount LQ] - [Invoice Cost LQ])/[Invoice Amount LQ];\n\nelse\nnecResult = 0;"]
["*SERVER","*SERVER","FLD0000006","Invoice","Margin LY","[Invoice Amount LY] - UDM_SALES_SUMMARIZED.EXTCSTLY"]
["*SERVER","*SERVER","FLD0000007","Invoice","Margin % LY",0,"if([Invoice Amount LY]  !== 0)\nnecResult = ([Invoice Amount LY]  - [Invoice Cost LY])/[Invoice Amount LY]  ;\n\nelse\nnecResult = 0;"]
["*SERVER","*SERVER","FLD00000016","Invoice Margin","M to M Growth %",0,"if([Invoice Amount] - [Invoice Cost] !== 0)\nnecResult= ([Invoice Amount] - [Invoice Cost])/([Invoice Amount LM] - [Invoice Cost]LM) - 1;\n\nelse\nnecResult = 0;"]
["*SERVER","*SERVER","FLD00000017","Invoice Margin","Q to Q Growth %",0,"if([Invoice Amount] - [Invoice Cost] !== 0)\nnecResult= ([Invoice Amount] - [Invoice Cost])/([Invoice Amount LQ] - [Invoice Cost]LQ) - 1;\n\nelse\nnecResult = 0;"]
["*SERVER","*SERVER","FLD00000018","Invoice Margin","Y to Y Growth %",0,"if([Invoice Amount] - [Invoice Cost] !== 0)\nnecResult= ([Invoice Amount] - [Invoice Cost])/([Invoice Amount LY] - [Invoice Cost]LY) - 1;\n\nelse\nnecResult = 0;"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","INVQTYROLL3","Rolling 3","Invoice Quantity"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","INVAMTROLL3","Rolling 3","Invoice Amount"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","EXTCSTROLL3","Rolling 3","Invoice Cost"]
["*SERVER","*SERVER","FLD00000021","Rolling 3","Invoice Margin","[Rolling 3 Invoice Amount] - UDM_SALES_SUMMARIZED.EXTCSTROLL3"]
["*SERVER","*SERVER","FLD00000022","Rolling 3","Invoice Margin %",0,"if ([Rolling 3 Invoice Amount] !== 0)\nnecResult = ([Rolling 3 Invoice Amount] - [Rolling 3 Invoice Cost]) / [Rolling 3 Invoice Amount];\n\nelse\nnecResult = 0;"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","INVQTYROLL12","Rolling 12","Invoice Quantity"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","INVAMTROLL12","Rolling 12","Invoice Amount"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","EXTCSTROLL12","Rolling 12","Invoice Cost"]
["*SERVER","*SERVER","FLD00000023","Rolling 12","Invoice Margin","[Rolling 12 Invoice Amount] - UDM_SALES_SUMMARIZED.EXTCSTROLL12"]
["*SERVER","*SERVER","FLD00000024","Rolling 12","Invoice Margin %",0,"if ([Rolling 12 Invoice Amount] !== 0)\nnecResult = ([Rolling 12 Invoice Amount] - [Rolling 12 Invoice Cost]) / [Rolling 12 Invoice Amount];\n\nelse\nnecResult = 0;"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","INVQTYROLL12LY","Rolling 12 LY","Invoice Quantity"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","INVAMTROLL12LY","Rolling 12 LY","Invoice Amount"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","EXTCSTROLL12LY","Rolling 12 LY","Invoice Cost"]
["*SERVER","*SERVER","FLD00000025","Rolling 12 LY","Invoice Margin","[Rolling 12 LY Invoice Amount] - UDM_SALES_SUMMARIZED.EXTCSTROLL12LY"]
["*SERVER","*SERVER","FLD00000026","Rolling 12 LY","Invoice Margin %",0,"if ([Rolling 12 Invoice Amount] !== 0)\nnecResult = ([Rolling 12 Invoice Amount]LY - [Rolling 12 LY Invoice Cost]) / [Rolling 12 Invoice Amount]LY;\n\nelse\nnecResult = 0;"]
["*SERVER","*SERVER","FLD00000027","MA 3 Months","Invoice Quantity","[Rolling 3 Invoice Quantity] / 3"]
["*SERVER","*SERVER","FLD00000028","MA 3 Months","Invoice Amount","[Rolling 3 Invoice Amount] / 3"]
["*SERVER","*SERVER","FLD00000029","MA 3 Months","Invoice Cost","[Rolling 3 Invoice Cost] / 3"]
["*SERVER","*SERVER","FLD00000030","MA 3 Months","Invoice Margin","([Rolling 3 Invoice Amount] - [Rolling 3 Invoice Cost]) / 3"]
["*SERVER","*SERVER","FLD00000031","MA 12 Months","Invoice Quantity","[Rolling 12 Invoice Quantity] / 12"]
["*SERVER","*SERVER","FLD00000032","MA 12 Months","Invoice Amount","[Rolling 12 Invoice Amount] / 12"]
["*SERVER","*SERVER","FLD00000033","MA 12 Months","Invoice Cost","[Rolling 12 Invoice Cost] / 12"]
["*SERVER","*SERVER","FLD00000034","MA 12 Months","Invoice Margin","([Rolling 12 Invoice Amount] - [Rolling 12 Invoice Cost]) / 12"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","INVQTYYTD","Year to Date","Invoice Quantity"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","INVAMTYTD","Year to Date","Invoice Amount"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","EXTCSTYTD","Year to Date","Invoice Cost"]
["*SERVER","*SERVER","FLD00000035","Year to Date","Invoice Margin","[Year to Date Invoice Amount] - UDM_SALES_SUMMARIZED.EXTCSTYTD"]
["*SERVER","*SERVER","FLD00000036","Year to Date","Invoice Quantity",0,"if ([Year to Date Invoice Amount] !== 0)\nnecResult = ([Year to Date Invoice Amount] - [Year to Date Invoice Cost]) / [Year to Date Invoice Amount];\n\nelse\nnecResult = 0;"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","DIMENSION01","Dimension 01","Code"]
["UDM_DIMENSIONS","UDM_DIMENSIONS","DESCRIPTION","Dimension 01","Description"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","DIMENSION02","Dimension 02","Code"]
["UDM_DIMENSIONS_1","UDM_DIMENSIONS","DESCRIPTION","Dimension 02","Description"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","DIMENSION03","Dimension 03","Code"]
["UDM_DIMENSIONS_2","UDM_DIMENSIONS","DESCRIPTION","Dimension 03","Description"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","DIMENSION04","Dimension 04","Code"]
["UDM_DIMENSIONS_3","UDM_DIMENSIONS","DESCRIPTION","Dimension 04","Description"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","DIMENSION05","Dimension 05","Code"]
["UDM_DIMENSIONS_4","UDM_DIMENSIONS","DESCRIPTION","Dimension 05","Description"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","DIMENSION06","Dimension 06","Code"]
["UDM_DIMENSIONS_5","UDM_DIMENSIONS","DESCRIPTION","Dimension 06","Description"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","DIMENSION07","Dimension 07","Code"]
["UDM_DIMENSIONS_6","UDM_DIMENSIONS","DESCRIPTION","Dimension 07","Description"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","DIMENSION08","Dimension 08","Code"]
["UDM_DIMENSIONS_7","UDM_DIMENSIONS","DESCRIPTION","Dimension 08","Description"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","DIMENSION09","Dimension 09","Code"]
["UDM_DIMENSIONS_8","UDM_DIMENSIONS","DESCRIPTION","Dimension 09","Description"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","DIMENSION10","Dimension 10","Code"]
["UDM_DIMENSIONS_9","UDM_DIMENSIONS","DESCRIPTION","Dimension 10","Description"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","DIMENSION11","Dimension 11","Code"]
["UDM_DIMENSIONS_10","UDM_DIMENSIONS","DESCRIPTION","Dimension 11","Description"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","DIMENSION12","Dimension 12","Code"]
["UDM_DIMENSIONS_11","UDM_DIMENSIONS","DESCRIPTION","Dimension 12","Description"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","DIMENSION13","Dimension 13","Code"]
["UDM_DIMENSIONS_12","UDM_DIMENSIONS","DESCRIPTION","Dimension 13","Description"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","DIMENSION14","Dimension 14","Code"]
["UDM_DIMENSIONS_13","UDM_DIMENSIONS","DESCRIPTION","Dimension 14","Description"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","DIMENSION15","Dimension 15","Code"]
["UDM_DIMENSIONS_14","UDM_DIMENSIONS","DESCRIPTION","Dimension 15","Description"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","DIMENSION16","Dimension 16","Code"]
["UDM_DIMENSIONS_15","UDM_DIMENSIONS","DESCRIPTION","Dimension 16","Description"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","DIMENSION17","Dimension 17","Code"]
["UDM_DIMENSIONS_16","UDM_DIMENSIONS","DESCRIPTION","Dimension 17","Description"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","DIMENSION18","Dimension 18","Code"]
["UDM_DIMENSIONS_17","UDM_DIMENSIONS","DESCRIPTION","Dimension 18","Description"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","DIMENSION19","Dimension 19","Code"]
["UDM_DIMENSIONS_18","UDM_DIMENSIONS","DESCRIPTION","Dimension 19","Description"]
["UDM_SALES_SUMMARIZED","UDM_SALES_SUMMARIZED","DIMENSION20","Dimension 20","Code"]
["UDM_DIMENSIONS_19","UDM_DIMENSIONS","DESCRIPTION","Dimension 20","Description"]

{"sheet":"490000015","index":4,"n_rows":226,"n_cols":7,"rows_kept":226,"cut":false,"hidden":false,"merged":[]}
["Main Menu"]
["tableAlias","tableName","name","columnGroupHeading","columnHeading","calculation","Oncalculation"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","CYEAR","Calendar","Year"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","CPERIOD","Calendar","Period"]
["*SERVER","*SERVER","FLD00000046","Calendar","Quarter","CASE\nWHEN [Calendar Period] BETWEEN 1 AND 3 THEN 1\nWHEN [Calendar Period] BETWEEN 4 AND 6 THEN 2\nWHEN [Calendar Period] BETWEEN 7 AND 9 THEN 3\nWHEN [Calendar Period] BETWEEN 10 AND 12 THEN 4\nEND"]
["*SERVER","*SERVER","FLD00000012","Calendar","Period ID","CONCAT(CONCAT([Calendar Year],'-'),CASE WHEN [Calendar Period] < 10 THEN CONCAT('0',[Calendar Period]) ELSE CAST([Calendar Period] as char(2)) END)"]
["*SERVER","*SERVER","FLD00000047","Calendar","Quarter ID","CASE\nWHEN [Calendar Period] BETWEEN 1 AND 3 THEN CONCAT(CONCAT([Calendar Year],'-0'),1)\nWHEN [Calendar Period] BETWEEN 4 AND 6 THEN CONCAT(CONCAT([Calendar Year],'-0'),2)\nWHEN [Calendar Period] BETWEEN 7 AND 9 THEN CONCAT(CONCAT([Calendar Year],'-0'),3)\nWHEN [Calendar Period] BETWEEN 10 AND 12 THEN CONCAT(CONCAT([Calendar Year],'-0'),4)\nEND"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","COMPANYID","Company","ID"]
["UDM_DIMCOMPANY","UDM_DIMCOMPANY","COMPANYNAME","Company","Name"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","SITEID","Site","ID"]
["UDM_DIMSITES","UDM_DIMSITES","FCYNAM","Site","Name"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","CUSTOMERID","Customer","ID"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","CLIENTNAME","Customer","Name"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","CLIENTTYPE","Customer","Type"]
["*SERVER","*SERVER","FLD00000031","Customer","Category","CASE\nWHEN UDM_CUSTANALYSIS.FLAGORDERLY = 1\nAND UDM_CUSTANALYSIS.FLAGORDERTY = 1\nTHEN 'Returning'\n\nWHEN UDM_CUSTANALYSIS.FLAGORDERLY = 0\nAND UDM_CUSTANALYSIS.FLAGORDERTY = 1\nTHEN 'New'\n\nWHEN UDM_CUSTANALYSIS.FLAGORDERLY = 1\nAND UDM_CUSTANALYSIS.FLAGORDERTY = 0\nTHEN 'Churned'\nEND"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","CLIENTGROUP","Customer","Group"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","CLIENTRISK","Customer","Risk"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","STATGROUP1","Customer Stat Group","Code 1"]
["UDM_DESCRIPTION","UDM_DESCRIPTION","DESCRIPTION","Customer Stat Group","Desc 1"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","STATGROUP2","Customer Stat Group","Code 2"]
["UDM_DESCRIPTION_1","UDM_DESCRIPTION","DESCRIPTION","Customer Stat Group","Desc 2"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","STATGROUP3","Customer Stat Group","Code 3"]
["UDM_DESCRIPTION_2","UDM_DESCRIPTION","DESCRIPTION","Customer Stat Group","Desc 3"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","STATGROUP4","Customer Stat Group","Code 4"]
["UDM_DESCRIPTION_3","UDM_DESCRIPTION","DESCRIPTION","Customer Stat Group","Desc 4"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","STATGROUP5","Customer Stat Group","Code 5"]
["UDM_DESCRIPTION_4","UDM_DESCRIPTION","DESCRIPTION","Customer Stat Group","Desc 5"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD01","Customer UDF 01","Code"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD01DESC","Customer UDF 01","Desc"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD02","Customer UDF 02","Code"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD02DESC","Customer UDF 02","Desc"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD03","Customer UDF 03","Code"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD03DESC","Customer UDF 03","Desc"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD04","Customer UDF 04","Code"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD04DESC","Customer UDF 04","Desc"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD05","Customer UDF 05","Code"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD05DESC","Customer UDF 05","Desc"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD06","Customer UDF 06","Code"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD06DESC","Customer UDF 06","Desc"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD07","Customer UDF 07","Code"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD07DESC","Customer UDF 07","Desc"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD08","Customer UDF 08","Code"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD08DESC","Customer UDF 08","Desc"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD09","Customer UDF 09","Code"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD09DESC","Customer UDF 09","Desc"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD10","Customer UDF 10","Code"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","UDFIELD10DESC","Customer UDF 10","Desc"]
["UDM_DIMADDRESS","UDM_DIMADDRESS","COUNTRY","Country","Code"]
["UDM_DIMADDRESS","UDM_DIMADDRESS","COUNTRYDESC","Country","Name"]
["UDM_DIMADDRESS","UDM_DIMADDRESS","PROVINCESTATE","State","Code"]
["UDM_DIMADDRESS","UDM_DIMADDRESS","PROVINCESTATEDESC","State","Name"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","CURLED","Ledger","Currency"]
["UDM_DIMCLIENT","UDM_DIMCLIENT","DEFSALESREPID","Default Sales Rep","ID"]
["UDM_DIMSALESREP_1","UDM_DIMSALESREP","SALESREPNAME","Default Sales Rep","Name"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","SALESREP1ID","Sales Rep 1","ID"]
["UDM_DIMSALESREP","UDM_DIMSALESREP","SALESREPNAME","Sales Rep 1","Name"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","PRODUCTID","Product","ID"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","PRODUCTDESC","Product","Name"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","PRODUCTLINE","Product","Line"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","STATGROUP1","Product Stat Group","Code 1"]
["UDM_DESCRIPTION_10","UDM_DESCRIPTION","DESCRIPTION","Product Stat Group","Desc 1"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","STATGROUP2","Product Stat Group","Code 2"]
["UDM_DESCRIPTION_11","UDM_DESCRIPTION","DESCRIPTION","Product Stat Group","Desc 2"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","STATGROUP3","Product Stat Group","Code 3"]
["UDM_DESCRIPTION_12","UDM_DESCRIPTION","DESCRIPTION","Product Stat Group","Desc 3"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","STATGROUP4","Product Stat Group","Code 4"]
["UDM_DESCRIPTION_13","UDM_DESCRIPTION","DESCRIPTION","Product Stat Group","Desc 4"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","STATGROUP5","Product Stat Group","Code 5"]
["UDM_DESCRIPTION_14","UDM_DESCRIPTION","DESCRIPTION","Product Stat Group","Desc 5"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD01","Product UDF 01","Code"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD01DESC","Product UDF 01","Desc"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD02","Product UDF 02","Code"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD02DESC","Product UDF 02","Desc"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD03","Product UDF 03","Code"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD03DESC","Product UDF 03","Desc"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD04","Product UDF 04","Code"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD04DESC","Product UDF 04","Desc"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD05","Product UDF 05","Code"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD05DESC","Product UDF 05","Desc"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD06","Product UDF 06","Code"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD06DESC","Product UDF 06","Desc"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD07","Product UDF 07","Code"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD07DESC","Product UDF 07","Desc"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD08","Product UDF 08","Code"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD08DESC","Product UDF 08","Desc"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD09","Product UDF 09","Code"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD09DESC","Product UDF 09","Desc"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD10","Product UDF 10","Code"]
["UDM_DIMPRODUCT","UDM_DIMPRODUCT","UDFIELD10DESC","Product UDF 10","Desc"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","ORDERQTY","Order","Quantity"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","ORDERQTYLM","Order","Quantity LM"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","ORDERQTYLQ","Order","Quantity LQ"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","ORDERQTYLY","Order","Quantity LY"]
["*SERVER","*SERVER","FLD00000048","Order Quantity","M to M Growth %",0,"if ([Order Quantity LM] !== 0)\nnecResult = ([Order Quantity]-[Order Quantity LM])/[Order Quantity LM];\n\nelse\nnecResult=0;"]
["*SERVER","*SERVER","FLD00000044","Order Quantity","Q to Q Growth %",0,"if ([Order Quantity LQ] !== 0)\nnecResult = ([Order Quantity]-[Order Quantity LQ])/[Order Quantity LQ];\n\nelse\nnecResult=0;"]
["*SERVER","*SERVER","FLD00000045","Order Quantity","Y to Y Growth %",0,"if ([Order Quantity LY] !== 0)\nnecResult = ([Order Quantity]-[Order Quantity LY])/[Order Quantity LY];\n\nelse\nnecResult=0;"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","ORDERAMOUNT","Order","Amount"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","ORDERAMOUNTLM","Order","Amount LM"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","ORDERAMOUNTLQ","Order","Amount LQ"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","ORDERAMOUNTLY","Order","Amount LY"]
["*SERVER","*SERVER","FLD00000049","Order Amount","M to M Growth %",0,"if([Order Amount LM] !== 0)\nnecResult = ([Order Amount] - [Order Amount LM]) / [Order Amount LM];\n\nelse\nnecResult=0;"]
["*SERVER","*SERVER","FLD00000032","Order Amount","Q to Q Growth %",0,"if([Order Amount LQ] !== 0)\nnecResult = ([Order Amount] - [Order Amount LQ]) / [Order Amount LQ];\n\nelse\nnecResult=0;"]
["*SERVER","*SERVER","FLD00000033","Order Amount","Y to Y Growth %",0,"if([Order Amount LY] !== 0)\nnecResult = ([Order Amount] - [Order Amount LY]) / [Order Amount LY];\n\nelse\nnecResult=0;"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","ORDERCOST","Order","Cost"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","ORDERCOSTLM","Order","Cost LM"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","ORDERCOSTLQ","Order","Cost LQ"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","ORDERCOSTLY","Order","Cost LY"]
["*SERVER","*SERVER","FLD00000050","Order Cost","M to M Growth %",0,"if([Order Cost LM] !== 0)\nnecResult = ([Order Cost] - [Order Cost LM]) / [Order Cost LM];\n\nelse\nnecResult=0;"]
["*SERVER","*SERVER","FLD00000034","Order Cost","Q to Q Growth %",0,"if([Order Cost LQ] !== 0)\nnecResult = ([Order Cost] - [Order Cost LQ]) / [Order Cost LQ];\n\nelse\nnecResult=0;"]
["*SERVER","*SERVER","FLD00000035","Order Cost","Y to Y Growth %",0,"if([Order Cost LY] !== 0)\nnecResult = ([Order Cost] - [Order Cost LY]) / [Order Cost LY];\n\nelse\nnecResult=0;"]
["*SERVER","*SERVER","FLD00000024","Order","Margin","[Order Amount] - UDM_CUSTANALYSIS.ORDERCOST"]
["*SERVER","*SERVER","FLD00000026","Order","Margin %",0,"if([Order Amount] !== 0)\nnecResult = ([Order Amount] - [Order Cost]) / [Order Cost];\n\nelse\nnecResult = 0;"]
["*SERVER","*SERVER","FLD00000051","Order","Margin LM","[Order Amount LM] - UDM_CUSTANALYSIS.ORDERCOSTLM"]
["*SERVER","*SERVER","FLD00000055","Order","Margin LM %",0,"if([Order Amount LM] !== 0)\nnecResult = ([Order Amount LM] - [Order Cost LM]) / [Order Cost LM];\n\nelse\nnecResult = 0;"]
["*SERVER","*SERVER","FLD00000036","Order","Margin LQ","[Order Amount LQ] - UDM_CUSTANALYSIS.ORDERCOSTLQ"]
["*SERVER","*SERVER","FLD00000056","Order","Margin LQ %",0,"if([Order Amount LQ] !== 0)\nnecResult = ([Order Amount LQ] - [Order Cost LQ]) / [Order Cost LQ];\n\nelse\nnecResult = 0;"]
["*SERVER","*SERVER","FLD00000037","Order","Margin LY","[Order Amount LY] - UDM_CUSTANALYSIS.ORDERCOSTLY"]
["*SERVER","*SERVER","FLD00000057","Order","Margin LY %",0,"if([Order Amount LY] !== 0)\nnecResult = ([Order Amount LY] - [Order Cost LY]) / [Order Cost LY];\n\nelse\nnecResult = 0;"]
["*SERVER","*SERVER","FLD00000052","Order Margin","M to M Growth %",0,"if([Order Amount LM] - [Order Cost LM] !== 0)\n\nnecResult = (([Order Amount] - [Order Cost]) - ([Order Amount LM] - [Order Cost LM])) / ([Order Amount LM] - [Order Cost LM]);\n\nelse\nnecResult=0;"]
["*SERVER","*SERVER","FLD00000038","Order Margin","Q to Q Growth %",0,"if([Order Amount LQ] - [Order Cost LQ] !== 0)\n\nnecResult = (([Order Amount] - [Order Cost]) - ([Order Amount LQ] - [Order Cost LQ])) / ([Order Amount LQ] - [Order Cost LQ]);\n\nelse\nnecResult=0;"]
["*SERVER","*SERVER","FLD00000039","Order Margin","Y to Y Growth %",0,"if([Order Amount LY] - [Order Cost LY] !== 0)\nnecResult = (([Order Amount] - [Order Cost]) - ([Order Amount LY] - [Order Cost LY])) / ([Order Amount LY] - [Order Cost LY]);\n\nelse\nnecResult=0;"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","NBROFORDER","Order","Count"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","NBROFORDERLM","Order","Count LM"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","NBROFORDERLQ","Order","Count LQ"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","NBROFORDERLY","Order","Count LY"]
["*SERVER","*SERVER","FLD00000053","Order Count","M to M Growth %",0,"if ([Order Count LM] !== 0)\nnecResult = ([Order Count] - [Order Count LM]) / [Order Count LM];\n\nelse\nnecResult = 0;"]
["*SERVER","*SERVER","FLD00000040","Order Count","Q to Q Growth %",0,"if ([Order Count LQ] !== 0)\nnecResult = ([Order Count] - [Order Count LQ]) / [Order Count LQ];\n\nelse\nnecResult = 0;"]
["*SERVER","*SERVER","FLD00000041","Order Count","Y to Y Growth %",0,"if ([Order Count LY] !== 0)\nnecResult = ([Order Count] - [Order Count LY]) / [Order Count LY];\n\nelse\nnecResult = 0;"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","NBROFPRODORDER","Product","Count"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","NBROFPRODORDERLM","Product","Count LM"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","NBROFPRODORDERLQ","Product","Count LQ"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","NBROFPRODORDERLY","Product","Count LY"]
["*SERVER","*SERVER","FLD00000054","Product Count","M to M Growth %",0,"if ([Product Count LM] !== 0)\nnecResult = ([Product Count] - [Product Count LM]) / [Product Count LM];\n\nelse\nnecResult = 0;"]
["*SERVER","*SERVER","FLD00000042","Product Count","Q to Q Growth %",0,"if ([Product Count LQ] !== 0)\nnecResult = ([Product Count] - [Product Count LQ]) / [Product Count LQ];\n\nelse\nnecResult = 0;"]
["*SERVER","*SERVER","FLD00000043","Product Count","Y to Y Growth %",0,"if ([Product Count LY] !== 0)\nnecResult = ([Product Count] - [Product Count LY]) / [Product Count LY];\n\nelse\nnecResult = 0;"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","ORDERQTYYTD","Year To Date","Quantity"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","ORDERAMOUNTYTD","Year To Date","Order Amount"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","ORDERCOSTYTD","Year To Date","Order Cost"]
["*SERVER","*SERVER","FLD00000025","Year To Date","Order Margin","[Year To Date Order Amount] - UDM_CUSTANALYSIS.ORDERCOSTYTD"]
["*SERVER","*SERVER","FLD00000027","Year To Date","Order Margin %",0,"if([Year To Date Order Amount] !== 0)\nnecResult = ([Year To Date Order Amount] - [Year To Date Order Cost]) / [Year To Date Order Amount];\n\nelse\nnecResult = 0;"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","NBROFORDERYTD","Year To Date","Order Count"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","NBROFPRODORDERYTD","Year To Date","Product Count"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","ORDERQTYROLL12","Rolling 12","Quantity"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","ORDERAMOUNTROLL12","Rolling 12","Order Amount"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","ORDERCOSTROLL12","Rolling 12","Order Cost"]
["*SERVER","*SERVER","FLD00000020","Rolling 12","Order Margin","[Rolling 12 Order Amount] - UDM_CUSTANALYSIS.ORDERCOSTROLL12"]
["*SERVER","*SERVER","FLD00000028","Rolling 12","Order Margin %",0,"if([Rolling 12 Order Amount] !== 0)\nnecResult = ([Rolling 12 Order Amount] - [Rolling 12 Order Cost]) / [Rolling 12 Order Amount];\n\nelse\nnecResult = 0;"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","NBROFORDERROLL12","Rolling 12","Order Count"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","NBROFPRODORDERROLL12","Rolling 12","Product Count"]
["*SERVER","*SERVER","FLD0000003",null,"Last Year","CASE\nWHEN UDM_CUSTANALYSIS.FLAGORDERLY = 1\nTHEN [Customer ID]\nEND"]
["*SERVER","*SERVER","FLD0000004",null,"This Year","CASE\nWHEN UDM_CUSTANALYSIS.FLAGORDERTY = 1\nTHEN [Customer ID]\nEND"]
["*SERVER","*SERVER","FLD0000002",null,"Returning","CASE\nWHEN UDM_CUSTANALYSIS.FLAGORDERLY = 1\nAND UDM_CUSTANALYSIS.FLAGORDERTY = 1\nTHEN [Customer ID]\nEND"]
["*SERVER","*SERVER","FLD00000014",null,"New","CASE\nWHEN UDM_CUSTANALYSIS.FLAGORDERLY = 0\nAND UDM_CUSTANALYSIS.FLAGORDERTY = 1\nTHEN [Customer ID]\nEND"]
["*SERVER","*SERVER","FLD00000015",null,"Churned","CASE\nWHEN UDM_CUSTANALYSIS.FLAGORDERLY = 1\nAND UDM_CUSTANALYSIS.FLAGORDERTY = 0\nTHEN [Customer ID]\nEND"]
["*SERVER","*SERVER","FLD0000001","By Year","Churn Rate",0,"if([Last Year] !== 0)\nnecResult= 1 - [Returning] / [Last Year];\nelse\nnecResult = 0;"]
["*SERVER","*SERVER","FLD00000013","By Year","Customer Retention Rate",0,"if([Last Year] !== 0)\nnecResult= [Returning] / [Last Year];\nelse\nnecResult = 0;"]
["*SERVER","*SERVER","FLD0000005","By Year","Customer Average Lifespan",0,"if([Last Year] - [Returning] !== 0)\nnecResult= [Last Year] / ([Last Year] - [Returning]);\nelse\nnecResult = '∞';"]
["*SERVER","*SERVER","FLD0000006","By Year","Average Order Frequency",0,"if ([This Year] !== 0)\nnecResult=[Rolling 12 Order Count] / [This Year];\nelse\nnecResult= 0;"]
["*SERVER","*SERVER","FLD0000007","Order Amount","Average Per Order",0,"if ([Rolling 12 Order Count] !== 0)\nnecResult = ([Rolling 12 Order Amount] / [Rolling 12 Order Count]);\nelse\nnecResult = 0;"]
["*SERVER","*SERVER","FLD0000008","Order Amount","Average Customer Value",0,"if ([This Year] !== 0)\nnecResult=([Rolling 12 Order Amount]) / [This Year];\nelse\nnecResult= 0;"]
["*SERVER","*SERVER","FLD0000009","Order Amount","Customer Lifetime Value",0,"if([Last Year] - [Returning] !== 0 && [This Year] !== 0)\nnecResult= ([Last Year] / ([Last Year] - [Returning])) * (([Rolling 12 Order Amount]) / [This Year]);\nelse\nnecResult = '∞';"]
["*SERVER","*SERVER","FLD00000016","Margin","Average Per Order",0,"if ([Rolling 12 Order Count] !== 0)\nnecResult = (([Rolling 12 Order Amount] - [Rolling 12 Order Cost]) / [Rolling 12 Order Count]);\nelse\nnecResult = 0;"]
["*SERVER","*SERVER","FLD00000017","Margin","Average Customer Value",0,"if ([This Year] !== 0)\nnecResult=([Rolling 12 Order Amount] - [Rolling 12 Order Cost]) / [This Year];\nelse\nnecResult= 0;"]
["*SERVER","*SERVER","FLD00000018","Margin","Customer Lifetime Value",0,"if([Last Year] - [Returning] !== 0 && [This Year] !== 0)\nnecResult= ([Last Year] / ([Last Year] - [Returning])) * (([Rolling 12 Order Amount] - [Rolling 12 Order Cost]) / [This Year]);\nelse\nnecResult = '∞';"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","ORDERQTYROLL3","Rolling 3","Quantity"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","ORDERAMOUNTROLL3","Rolling 3","Order Amount"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","ORDERCOSTROLL3","Rolling 3","Order Cost"]
["*SERVER","*SERVER","FLD00000021","Rolling 3","Order Margin","[Rolling 3 Order Amount] - UDM_CUSTANALYSIS.ORDERCOSTROLL3"]
["*SERVER","*SERVER","FLD00000029","Rolling 3","Order Margin %",0,"if([Rolling 3 Order Amount] !== 0)\nnecResult = ([Rolling 3 Order Amount] - [Rolling 3 Order Cost]) / [Rolling 3 Order Amount];\n\nelse\nnecResult = 0;"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","NBROFORDERROLL3","Rolling 3","Order Count"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","NBROFPRODORDERROLL3","Rolling 3","Product Count"]
["*SERVER","*SERVER","FLD00000059","MA 12 Months","Order Quantity","[Rolling 12 Quantity] / 12"]
["*SERVER","*SERVER","FLD00000010","MA 12 Months","Order Armount","[Rolling 12 Order Amount] / 12"]
["*SERVER","*SERVER","FLD00000058","MA 12 Months","Order Cost","[Rolling 12 Order Cost] / 12"]
["*SERVER","*SERVER","FLD00000022","MA 12 Months","Order Margin","([Rolling 12 Order Amount] - [Rolling 12 Order Cost])/12"]
["*SERVER","*SERVER","FLD00000060","MA 3 Months","Order Quantity","[Rolling 3 Quantity] / 3"]
["*SERVER","*SERVER","FLD00000011","MA 3 Months","Order Armount","[Rolling 3 Order Amount]/3"]
["*SERVER","*SERVER","FLD00000061","MA 3 Months","Order Cost","[Rolling 3 Order Cost] / 3"]
["*SERVER","*SERVER","FLD00000023","MA 3 Months","Order Margin","([Rolling 3 Order Amount] - [Rolling 3 Order Cost])/3"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","ORDERQTYROLL12LY","Rolling 12 LY","Quantity"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","ORDERAMOUNTROLL12LY","Rolling 12 LY","Order Amount"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","ORDERCOSTROLL12LY","Rolling 12 LY","Order Cost"]
["*SERVER","*SERVER","FLD00000019","Rolling 12 LY","Order Margin","[Rolling 12 LY Order Amount] - UDM_CUSTANALYSIS.ORDERCOSTROLL12LY"]
["*SERVER","*SERVER","FLD00000030","Rolling 12 LY","Order Margin %",0,"if([Rolling 12 LY Order Amount] !== 0)\nnecResult = ([Rolling 12 LY Order Amount] - [Rolling 12 LY Order Cost]) / [Rolling 12 LY Order Amount];\n\nelse\nnecResult = 0;"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","NBROFORDERROLL12LY","Rolling 12 LY","Order Count"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","NBROFPRODORDERROLL12LY","Rolling 12 LY","Product Count"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","DIMENSION01","Dimension 01","Code"]
["UDM_DIMENSIONS","UDM_DIMENSIONS","DESCRIPTION","Dimension 01","Description"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","DIMENSION02","Dimension 02","Code"]
["UDM_DIMENSIONS_1","UDM_DIMENSIONS","DESCRIPTION","Dimension 02","Description"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","DIMENSION03","Dimension 03","Code"]
["UDM_DIMENSIONS_2","UDM_DIMENSIONS","DESCRIPTION","Dimension 03","Description"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","DIMENSION04","Dimension 04","Code"]
["UDM_DIMENSIONS_3","UDM_DIMENSIONS","DESCRIPTION","Dimension 04","Description"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","DIMENSION05","Dimension 05","Code"]
["UDM_DIMENSIONS_4","UDM_DIMENSIONS","DESCRIPTION","Dimension 05","Description"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","DIMENSION06","Dimension 06","Code"]
["UDM_DIMENSIONS_5","UDM_DIMENSIONS","DESCRIPTION","Dimension 06","Description"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","DIMENSION07","Dimension 07","Code"]
["UDM_DIMENSIONS_6","UDM_DIMENSIONS","DESCRIPTION","Dimension 07","Description"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","DIMENSION08","Dimension 08","Code"]
["UDM_DIMENSIONS_7","UDM_DIMENSIONS","DESCRIPTION","Dimension 08","Description"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","DIMENSION09","Dimension 09","Code"]
["UDM_DIMENSIONS_8","UDM_DIMENSIONS","DESCRIPTION","Dimension 09","Description"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","DIMENSION10","Dimension 10","Code"]
["UDM_DIMENSIONS_9","UDM_DIMENSIONS","DESCRIPTION","Dimension 10","Description"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","DIMENSION11","Dimension 11","Code"]
["UDM_DIMENSIONS_10","UDM_DIMENSIONS","DESCRIPTION","Dimension 11","Description"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","DIMENSION12","Dimension 12","Code"]
["UDM_DIMENSIONS_11","UDM_DIMENSIONS","DESCRIPTION","Dimension 12","Description"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","DIMENSION13","Dimension 13","Code"]
["UDM_DIMENSIONS_12","UDM_DIMENSIONS","DESCRIPTION","Dimension 13","Description"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","DIMENSION14","Dimension 14","Code"]
["UDM_DIMENSIONS_13","UDM_DIMENSIONS","DESCRIPTION","Dimension 14","Description"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","DIMENSION15","Dimension 15","Code"]
["UDM_DIMENSIONS_14","UDM_DIMENSIONS","DESCRIPTION","Dimension 15","Description"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","DIMENSION16","Dimension 16","Code"]
["UDM_DIMENSIONS_15","UDM_DIMENSIONS","DESCRIPTION","Dimension 16","Description"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","DIMENSION17","Dimension 17","Code"]
["UDM_DIMENSIONS_16","UDM_DIMENSIONS","DESCRIPTION","Dimension 17","Description"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","DIMENSION18","Dimension 18","Code"]
["UDM_DIMENSIONS_17","UDM_DIMENSIONS","DESCRIPTION","Dimension 18","Description"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","DIMENSION19","Dimension 19","Code"]
["UDM_DIMENSIONS_18","UDM_DIMENSIONS","DESCRIPTION","Dimension 19","Description"]
["UDM_CUSTANALYSIS","UDM_CUSTANALYSIS","DIMENSION20","Dimension 20","Code"]
["UDM_DIMENSIONS_19","UDM_DIMENSIONS","DESCRIPTION","Dimension 20","Description"]