Account parameters for flex.bi Enterprise

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
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
LEFT JOIN BudgetItem
ON FinancialDocLine.BudgetItemID = BudgetItem.BudgetItemID"

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.

-

[object_hierarchy_dimensions]

"<object dimension name>" = ["<object type1>", "<object type2>"]

String

[object_hierarchy_dimensions]

"Cities by size" = ["CSZ", "CTY"]

"Cities by region and country" = ["CTR", "RGN", "CTY"]

This parameter can be used to create hierarchies from objects in HansaWorld application. The definition needs to contain the new dimension name and list of object types that will be used in the hierarchy. Then flex.bi will use the “Hier. Tags/Objects” field to organise the objects accordingly.

-

application_name

String

application_name = "OGMS"

Changes the application name and icon for SQL Extended applications for the account. Currently available values are: OGMS

-