Document toolboxDocument toolbox

(Before 7.0.2) Payment Order cube from custom fields

This is an example on how Payment Order cube can be build based on Jumis data.

[PaymentOrder.Amount] default_custom_field = true cube_name = 'Jumis Payment Order' name = 'Amount' dimension_name = 'Payment Order' measure = true [PaymentOrder.PaymentOrderID] default_custom_field = true name = 'Payment Order ID' dimension_name = 'Payment Order' cube_name = 'Jumis Payment Order' source_id_field = true rest_api_field = "PaymentOrderID" dimension_in_separate_table = true [PaymentOrder.PaymentOrderNo] default_custom_field = true name = 'Payment Order No' dimension_name = 'Payment Order' cube_name = 'Jumis Payment Order' rest_api_field = 'PaymentOrderNo' dimension_in_separate_table = true key_field = true [PaymentOrder.Comments] default_custom_field = true name = 'Payment Order Comments' dimension_name = 'Payment Order' cube_name = 'Jumis Payment Order' rest_api_field = 'Comments' dimension_in_separate_table = true name_field = true [PaymentOrder.PaymentOrderID2] default_custom_field = true name = 'Payment Order ID bind' dimension_name = 'Payment Order' cube_name = 'Jumis Payment Order' for_custom_dimension = 'Payment Order' bind_field_name = 'PaymentOrderID' rest_api_field = 'PaymentOrderID' [PaymentOrder.PaymentOrderDate] default_custom_field = true dimension_in_separate_table = true name = 'Payment Order Date' dimension_name = 'Payment Order' cube_name = 'Jumis Payment Order' rest_api_field = 'PaymentOrderDate' data_type = 'date' import_sort_date = true for_standard_dimension = "Time" [PaymentOrder.CurrencyID] default_custom_field = true name = 'Payment Order Currency ID' dimension_name = 'Payment Order' cube_name = 'Jumis Payment Order' for_custom_dimension = 'Currency' bind_field_name = 'currency_id' rest_api_field = 'CurrencyID' [PaymentOrder.PartnerID] default_custom_field = true name = 'Payment Order Partner ID' dimension_name = 'Payment Order' cube_name = 'Jumis Payment Order' for_custom_dimension = 'Partner' bind_field_name = 'partner_id' rest_api_field = 'PartnerID'