Advanced settings for Assets object attributes

eazyBI for Jira

You can modify Assets object attribute import options in two ways:

• account-specific advanced settings in account import options. This option affects data import in the particular account only, and is a more user-friendly alternative to configuring them through advanced settings.
• global advanced settings in eazyBI advanced settings for Data Center or Site settings for Cloud. This option affects all accounts that have the Asset attribute imported. 

Account-specific advanced settings for Assets object attributes

To add object attribute import options, head to the eazyBI import option Assets tab and find the desired attribute in the list. Hover the cursor over its entry and then click on Edit. Attributes with account-specific advanced settings or custom JavaScript code have the Edit button visible by default, indicating that this attribute already has some changes.

In the advanced setting screen, there is a list of settings, their default values, and an option to specify (overwrite) the default value. All attributes have a Display name and a Data type; the remaining settings vary depending on the selected data type:

• string supports additional settings: Limit, Dimension, and Multiple values.
• integer supports additional settings: BigInt and Dimension.
• decimal supports additional settings: Precision, Scale, and Dimension.
• text, date, and datetime do not support additional settings.

Global advanced settings for Assets object attributes

In the eazyBI advanced settings(for Data Center) orSite settings for Cloud to modify Assets attribute import options globally for the eazyBI instance.

First, determine the attribute's ID before modifying its import options. You can do that in Assets or the eazyBI Assets source data import options by hovering over the Assets attribute name. Then add the following line to advanced settings:

# parameter name for eazyBI version 6.6
[source_application.insight.customfield_NN]

# parameter name starting eazyBI version 7.0
[source_application.assets.customfield_NN]

where NN is the Assets attribute ID. That will start the block of configuration parameters for the NN attribute. After that line, specify the data type of this attribute:

data_type = "integer"

Other available types are string, text, decimal, date, datetime.

You can use the additional setting limit to extend the maximum length of string or the size of integer type attributes. By default, the maximum string length is 255 characters. The option limit = 300 would extend that. Integers are limited in the range of –2,147,483,648 to 2,147,483,647. To import larger numbers as integers, add the additional setting limit = 8 .

If you use the decimal data type, then by default, the precision (maximum number of digits) is 15, and the scale (digits after the decimal point) is 2. You can change these defaults with additional precision and scale settings.

If you would like to import an attribute as a measure, add the setting measure. Note you can import only integer, decimal, and date data types as measures.

measure = true

Here is an example of an integer type measure definition:

# parameter name for eazyBI version 6.6
[source_application.insight.customfield_89]
data_type = "integer"
measure = true

# parameter name starting eazyBI version 7.0
[source_application.assets.customfield_89]
data_type = "integer"
measure = true

Select the attribute for import after updating the eazyBI advanced settings. If you have already imported the attribute, first deselect it and import data. After that, select it back for import and import data.