Account parameters for flex.bi Enterprise
Account parameter are specific textual values that when added can change different default values of the account as well as the way data is imported into the account.
Where to add plan parameters
Click on the account name and select Edit account.
Enter the parameters as text in the Plan parameters section. Note that this section is available only to system administrators.
Parameters list
| Parameter | Parameter value type | Example | Comment | Default value |
|---|---|---|---|---|
| yearly_price_multiplier | Number | yearly_price_multiplier = 12 | How many months are paid if yearly payment is done | 11 |
| max_source_applications | Integer | max_source_applications = 5 | Maximum amount of unique sources (Maximum count of source applications, as in if max_source = 2 then you can have 1 HW and 1 SQL, or 2 REST API, or 1 SQL and 1 REST API etc.) | See pricing |
| max_storage | Integer | max_storage = 4096 | Maximum amount of allowed space used (Cube size + File size) in megabytes | See pricing |
| max_users | Integer | max_users = 50 | Maximum amount of users per account | See pricing |
| max_source_selections | Integer | max_source_selections = 10 | Maximum amount of source selections for hansaworld (Maximum amount of enabled HW cubes) | See pricing |
| max_cubes | Integer | max_cubes = 10 | Maximum amount of cubes (Sum of all cubes that exist) | See pricing |
| subscripton_discount_percentage | Number | subscripton_discount_percentage = 50 | Adds discount percentage to subscription charges period fee for the account | 0 |
| export_results | true/false | export_results = false | Are exports to excel, png, csv allowed | See pricing |
| embed_reports | true/false | embed_reports = true | Is embedding in other web pages allowed | See pricing |
| email_dashboards | true/false | email_dashboards = true | Is e-mail scheduling allowed | See pricing |
| oauth_clients | true/false | oauth_clients = true | Is oAuth with Gmail, Salesforce etc. supported? | See pricing |
| import_thread_count | Integer | import_thread_count = 4 | On how many threads (i.e. faster or slower) to import data | See pricing |
| enable_sending_gauge_stats | URL | enable_sending_gauge_stats = "www.flex.bi/example" | Set the URL to where the data needs to be sent | - |
| use_wa_cost_price | true/false | use_wa_cost_price = true | Use the Weighted Average as the value of Total Cost price | false |
| debug_import | Array with registers as strings | debug_import = ["IVVc","CUVc","INVc"] | Prints out incoming record information in log files | - |
| debug_level | Integer | debug_level = 10 | Addition to debug_import parameters. Sets how many fields from registers should be printed | 100 |
| enable_geocoding | true/false | enable_geocoding = true | Enable geocoding to link customer addresses to longitude and latitude values | false |
| debug_geocoding | "all" or "error" | debug_geocoding = "error" | Will debug geocoding for the account | |
| import_historic_salesman_groups | true/false | import_historic_salesman_groups = false | If the historic import is enabled then the information in records (invoices, sales orders etc.) will be used for person sales group, name and e-mail during import. If historic import is disabled then person register (UserVc) will be used for the person sales group, name and e-mail during import. | true |
| bank_holiday_country_code | String | bank_holiday_country_code = "LV" | Gives an option to select which country's holidays to use. By default the first one is selected. | - |
| trial_until | Date string | trial_until = "2018-05-31" | Overrides the trial end date | - |
| reverse_vat_enabled | true/false | reverse_vat_enabled = true | Enables the Reverse VAT calculation. | false |
| debug_hansaworld_import | true/false | debug_hansaworld_import = true | Enables REST API request logging in log files for HansaWorld application. | false |
| debug_priority_import | true/false | debug_priority_import = true | Enables REST API request logging in log files for Priority application. | false |
| debug_horizon_import | true/false | debug_horizon_import = true | Enables REST API request logging in log files for Horizon application. | false |
| debug_jumis_import | true/false | debug_jumis_import = true | Enables REST API request logging in log files for Jumis application. | false |
| min_address_precision | Number | min_address_precision = 8 | Minimum geocoding result precision. | |
| min_address_similarity | Number | min_address_similarity = 0.8 | Minimum similarity between geocoding result and address data in flex.bi. | |
show_source_file_errors | true/false | show_source_file_errors = true | Enable source file error messages. | false |
| max_consolidated_companies | Number | max_consolidated_companies = 2 | Specifies what is the maximum count of companies that are available for consolidation | - |
| forced_default_company_code | String | forced_default_company_code ="10" | Specifies what company should be used by default when setting up HansaWorld application with REST API in case the user does not have access to the first company | 1 |
| max_unauthorized_request_count | Integer | max_unauthorized_request_count = 5 | Specifies the maximum count of REST API authentication retries in case of Unauthorized response from the HW server. | 3 |
| enable_custom_hierarchies | true/false | enable_custom_hierarchies = true | Enables the custom hierarchies functionality for consolidated account. | false |
| <register code>_refresh_days | Integer | IVVc_refresh_days = 30 | Overwrites the refresh period for the specified register. | 90 |
| <register code>_skip_import_count | Integer | IVVc_skip_import_count = 2 | Sets the number for how many imports the specified register has to be skipped before importing again. | 0 |
| <register code>_start_import_from | Date string | IVVc_start_import_from = "2020-01-01" | Overwrites the start import from parameter for the specified register. | |
| demo_account | true/false | demo_account = true | Every import generates one transaction with a random number of transaction lines with today's date. Works only for Tilde and Horizon applications. | false |
| demo_data_generation_period_start | Date string | demo_data_generation_period_start = "2020-01-01" | When running import for the first time or after emptying cube, generates one transaction with a random number of transaction lines every day from the specified date. Works only for Tilde and Horizon applications. | - |
| is_main_consolidated_account | true/false | is_main_consolidated_account = true | Sets the account as the main account for consolidating data from multiple HansaWorld servers. | false |
| consolidate_to_account | Integer | consolidate_to_account = 25 | Specifies what main account will be used for the account's multiple HansaWorld server consolidation. | - |
| advanced_settings | true/false | advanced_settings = true | Enabled Advanced setting for custom fields | false |
| token_refresh_sleep_secs | Integer | token_refresh_sleep_secs = 1 | Specifies how long will the application sleep after receiving a refresh token. This is useful for some HansaWorld versions where during consolidated data import, the next request after token refresh returns 401 “Unauthorized“ or 404 “File not found“ error. | 0 |
| disable_object_types | true/false | disable_object_types = true | Disables REST API request for object type (OTVc) data when opening source application edit page. | false |
| disable_customer_class_types | true/false | disable_customer_class_types = true | Disables REST API request for customer classification type (CTypeVc) data when opening source application edit page. | false |
| disable_item_class_types | true/false | disable_item_class_types = true | Disables REST API request for item classification type (CTypeVc) data when opening source application edit page. | false |
| disable_location_class_types | true/false | disable_location_class_types = true | Disables REST API request for location classification type (LocClTypeVc) data when opening source application edit page. | false |
| disable_item_variety_groups | true/false | disable_item_variety_groups = true | Disables REST API request for item variety (VARGVc) data when opening source application edit page. | false |
| disable_xml_validation = true | true/false | disable_xml_validation = true | If the xml data received from the SERP contains invalid characters error is raised and the import is stopped. The raised error can be disabled with this parameter. | false |
jumis_transaction_record_source | string | jumis_transaction_record_source = "FinancialDocLine LEFT JOIN FinancialDoc | Rewrites the default SQL statement for requesting Jumis application register FinancialDocLine. | "FinancialDocLine LEFT JOIN FinancialDoc ON FinancialDocLine.FinancialDocID = FinancialDoc.FinancialDocID JOIN CurrencyRates ON FinancialDocLine.CurrencyID = CurrencyRates.CurrencyID AND FinancialDocLine.LineDate = CurrencyRates.RateDate JOIN Account DebetAccount ON FinancialDocLine.DebetID = DebetAccount.AccountID JOIN Account CreditAccount ON FinancialDocLine.CreditID = CreditAccount.AccountID" |
| forecast_start_date | Date string | forecast_start_date = '2022-01-01' | Overrides the default weather forecast start date and also the default ML model prediction period start date. | Today's date |
| <prefix>_max_concurrency | string | hansaworld_max_concurrency = 1 IVVc_max_concurrency = 2 TDdmKlBaseSar_max_concurrency = 3 | Changes the maximum concurrent REST API request limit (thread count). Doesn't effect flex.bi import thread count. <prefix> can be application name, register code or register code for a custom field. | 2 |
| local_horizon_server | true/false | local_horizon_server = true | Enable simple authentication for local Horizon server without using the context parameter. | false |
| enable_time_sub_range_import | true/false | enable_time_sub_range_import = true | This parameter splits up REST API data requests into smaller data ranges. When the parameter is enabled the default range is 30 days but it can be changed with the parameter hansaworld_batch_days. | false |
| hansaworld_batch_days | Integer | hansaworld_batch_days = 365 | Changes the number of REST API request data range days when enable_time_sub_range_import is used. | 30 |
disable_hsession_cookie | true/false | disable_hsession_cookie = true | Disable session based authentication for HansaWorld application. | false |
| horizon_batch_size | Integer | horizon_batch_size = 1000 | Changes the batch size for the REST API requests for Horizon application import. | 100 |
| <application>_request_page_size_limit | Integer | horizon_request_page_size_limit = 600 | Changes the page size limit for the REST API requests during the application import. Replace <application> with the necessary application (hansaWorld, horizon, priority, etc.) | Depends on the application. |
| <register>_full_reimport | String | TRVc_full_reimport = '0 0 * * *' IVVc_full_reimport = 'after 4' | This parameter can be used to specify how often a register should be fully re-imported. This re-import also removes records from flex.bi that were deleted in the source system but during the triggered re-import the reports might show incomplete results. There are two ways how to specify how often the re-import should happen - by cron configuration or using "after". With cron the import will happen at the closest time near the date and time specified in cron depending on the import frequency. More specifically cron time +/- import frequency. The "after" can be used to specify after how many normal imports a full re-import will be triggered. | - |