Info | ||
---|---|---|
| ||
With Advanced settings for Custom Fields functionality you can: 1) create new data structures :
2) define custom views and advanced sharing
What is a considered as a "custom field" for flex.bi ?
Where to find Advanced settings ? How to use this function? STEP 1 Define what you want to add in “Advanced settings” sectioning XXX language. STEP 2 Select in Cube Properties section — Custom Fields section what you want to import and how. |
Watch a Demonstration here :
Youtube macro width 300 aspectRatio 4 / 3 url https://www.youtube.com/watch?v=BOmOgM-TLV8 height 200
...
Advanced setting key components & detailed instructions for Standard ERP
...
Code Block |
---|
[PLVc.F_PriceList] name = 'Price List Code' dimension_name = 'Price' cube_name = 'Hansaworld Invoices' level_name = 'Price list' rest_api_field = "PLCode" key_field = true dimension_in_separate_table = true [PLVc.F_PriceListName] name = 'Price List Name' dimension_name = 'Price' cube_name = 'Hansaworld Invoices' level_name = 'Price list' rest_api_field = "PLCode" name_field = true dimension_in_separate_table = true [PLVc.F_PriceItemCode] name = 'Price Item Code' dimension_name = 'Price' cube_name = 'Hansaworld Invoices' level_name = 'Item' rest_api_field = "ArtCode" key_field = true dimension_in_separate_table = true [PLVc.F_PriceItemName] name = 'Price Item Name' dimension_name = 'Price' cube_name = 'Hansaworld Invoices' level_name = 'Item' rest_api_field = "Comment" name_field = true dimension_in_separate_table = true [PLVc.F_PriceCustomerCode] name = 'Price Customer Code' dimension_name = 'Price' cube_name = 'Hansaworld Invoices' level_name = 'Customer' rest_api_field = "CustCode" key_field = true dimension_in_separate_table = true [PLVc.F_PriceCustomerName] name = 'Price Customer Name' dimension_name = 'Price' cube_name = 'Hansaworld Invoices' level_name = 'Customer' rest_api_field = "CustCode" name_field = true dimension_in_separate_table = true [IVVc.PriceListProperty] name = "Price list Property" cube_name = 'Hansaworld Invoices' data_type = "string" dimension_name = 'Invoice' level_name = 'Invoice' rest_api_field = 'PriceList' [IVVc.RowPriceListCode] name = 'Invoice Price List Code' dimension_name = 'Invoice' cube_name = 'Hansaworld Invoices' level_name = 'Invoice Item' for_custom_dimension = 'Price' for_custom_dimension_level = 'Price list' bind_field_name = 'F_PriceList' rest_api_item_field = "rows" javascript_code = ''' if (doc.rows) { doc.rows.forEach(function(row){ if (doc.PriceList){ row.RowPriceListCode = doc.PriceList; } }) } ''' [IVVc.ArtCode] name = 'Invoice Item Code' dimension_name = 'Invoice' cube_name = 'Hansaworld Invoices' level_name = 'Invoice Item' for_custom_dimension = 'Price' for_custom_dimension_level = 'Item' bind_field_name = 'F_PriceItemCode' rest_api_item_field = "rows" [IVVc.RowCustCode] name = 'Invoice Customer Code' dimension_name = 'Invoice' cube_name = 'Hansaworld Invoices' level_name = 'Invoice Item' for_custom_dimension = 'Price' for_custom_dimension_level = 'Customer' bind_field_name = 'F_PriceCustomerCode' rest_api_item_field = "rows" javascript_code = ''' if (doc.rows) { doc.rows.forEach(function(row){ if (doc.CustCode){ row.RowCustCode = doc.CustCode; } }) } ''' |
In the example below, account_code value will be populated from the credit_account_code for the credit transaction and from debit_account_code for debit transaction.
...