All eazyBI for Jira eazyBI for Confluence Private eazyBI

Assets
eazyBI for Jira

On this page:

Overview

In eazyBI, Assets (former Insight Asset management) data can be imported into eazyBI in two ways: Assets data structure as a separate data source or part of the Jira data source as Assets custom fields. Both data sources are available in eazyBI for Jira Server, Data Center, and Cloud.

Jira Cloud access

In Jira Cloud, eazyBI uses the "Jira Service Management Assets" REST API for data import. Currently, it only supports authentication using the Atlassian user email and API token. Specify the "Jira Service Management Assets" REST API user email and API token granting eazyBI access to Assets data during import.

If the Assets data source or Assets custom fields are not available in eazyBI for Jira Cloud, check the Atlassian IP allowlist settings. If this option is enabled, add the eazyBI IP addresses to the allowlist to import data from Assets: 130.211.91.121,35.233.55.20,35.189.226.204,34.78.73.253

For the Assets source application:

In the Jira Source application, the option to add the user email and API token will be available if you have at least one "Assets objects" type custom field in Jira:

 

Assets source application

You can use eazyBI to analyze Assets objects by selected object attributes. If Assets is installed, you can see Assets available as a new source application in the eazyBI Source Data tab:


eazyBI recommends creating a separate eazyBI account for Assets data import to avoid conflicts with dimension names from other data cubes. You can import only one Assets schema objects in one eazyBI account. Please create separate eazyBI accounts for each Assets schema you would like to import data.

Import options

After selecting the Assets data source, you will see the import options page. There, you can select the Assets object schema [1] from which you would like to import all objects. To analyze data from other Assets schemas, create separate eazyBI accounts.

To analyze a subset of objects from the selected schema, you can specify an AQL query [2] filter limiting which objects are imported.

AQL query filter is available only in eazyBI for Jira Cloud.

Specify the regular import frequency [3] for the automatic data import. The initial data import will perform a full import of all schema objects. The subsequent imports (if import options are not changed) will be incremental and will process only created and updated objects.

You can specify the time zone [4], the first day of the week [5], and non-working days [6] [7] of the Time dimension.

You can use only one time zone in each eazyBI account. The time zone of the Time dimension will be used to determine the date member in the Time dimension when importing object measures (e.g. Objects created, Objects changed, and others) and object properties. If a time zone is not specified, then the default Jira server time zone will be used. If a different time zone will be selected, then all date timestamps will be converted to this time zone.

The first day of the week  [5] is used for the Time dimension Weekly hierarchy and also Week Day dimension.

Non-working days (standard non-working days of the week and additional non-working days/holidays) will be used for DateDiffWorkdays and DateAddWorkdays MDX functions as a default non-working days argument.

If you have a long list of additional non-working days [7], then you can copy the list and paste it into the time dimension options for other eazyBI accounts.

The timezone selection in the Assets source application is available on Cloud and since eazyBI version 6.5.

Because each eazyBI account has one Time dimension, don't use other data sources with different Time dimension settings in the same account.


In Object Status [8], select which attributes should eazyBI import as default status attributes (see below the description of dimensions and measures based on the default status attributes). Attributes selected here won't be available for import again in the Object Type attribute options.

Select Object history [9] period to limit the historical data import. eazyBI will import Object history data if it is within the set period. If there is no limit set, then all history data is imported.

Finally, select Assets object type attributes [10] for import. Object key, name, and status attributes are imported by default. The other attributes are grouped by object types:

Depending on the attribute type, you can import them as dimensions, measures, and properties:

  • List-of-value type attributes (object references, users, user groups, projects, versions, select lists, additional statuses) can be imported as dimensions
  • Numeric and date fields can be imported as measures.
  • Any attribute can be imported as the Object dimension member property.

Dimensions and measures

The following standard dimensions and measures will be created after data are imported.

Dimensions

Object TypeAll object types with objects.

Object Status

Current status of objects. It is based on the first object attribute that has a Status type and has a name from the Status attributes import option.
The additional Category hierarchy groups statuses by their category.

Object

List of all individual objects, grouped by the Object Type hierarchy level. Use this dimension when creating detailed reports with individual objects and their properties.

There is an option to create custom hierarchies in the Object dimensions with the Add custom hierarchy option. It is possible to create a hierarchy based on Object attribute properties.

Object History TypeThe type of object history entries (Added Value, Changed Value, Deleted Value etc.).
Use to analyze Object history changes and Objects changed measures.
Object History ActorThe author (user or automated system) of object history entries.
Use to analyze Object history changes and Objects changed measures.
Object History AttributeThe attribute which was changed in object history entries.
Use to analyze Object history changes and Objects changed measures.
Object Transition StatusAll statuses that appear in the default status attribute changes (the same statuses as in Object Status dimension based on the Status attributes import option).
Use to analyze Transitions to status, Transitions from status, Hours in transition status measures.
Object TransitionAll individual status transitions with names in the format “From status => To status”.
Use to analyze Transitions to status, Transitions from status, Hours in transition status measures.

Jira Issue

Jira issues linked to objects via Assets custom fields. 
Use to analyze Issues created, Issues due, Issues resolved measures.

There is an option to create custom hierarchies in the Jira issue dimension with the add custom hierarchy option. It is possible to create a hierarchy based on Jira issue default properties (Issue type, Status, Priority) or properties imported with additional data import. 

TimeThe standard time dimension with a Year / Quarter / Month / Day hierarchy and a Year / Week / Day hierarchy.

In addition dimensions for selected object type attributes will be created.

Measures

Objects createdTotal number of created objects that match selected dimension members.
You can drill into the detailed list of object from this measure.

Object history changes

Count of object history entries that show the number of times the objects were changed. Can be filtered by Object History Type, Object History Actor, Object History Attribute and Time dimensions, as well as by any other dimensions (the other dimensions are based on the current attribute values of objects).
You can drill into the detailed object history entries from this measure.

Objects changed

Similar to the previous but shows the unique count of objects that have these history changes.
You can drill into the detailed list of object from this measure.

Transitions to statusHow many times during the selected Time dimension period the object status has been changed to the status that is selected in the Object Transition Status dimension (or only transitions that are selected in the Object Transition dimension).
Transitions from statusHow many times during the selected Time dimension period the object status has been changed from the status that is selected in the Object Transition Status dimension (or only transitions that are selected in the Object Transition dimension).
Objects in transition status

How many objects when in the selected status of the Transition Status dimension at the end of the selected Time dimension period.

Average hours in transition status
Average days in transition status

Average hours/days that issue stayed in the status that is selected in the Transition status dimension.

Transition to status first date
Transition to status last date
Transition from status first date
Transition from status last date
The date and time when the first/last transition to/from the corresponding Transition Status (or the selected Transition) was performed.
Hours in transition statusThe total number of hours that objects have stayed in the status selected in the Object Transition Status dimension. It is calculated when the object status is changed from this status to a different status (when the Transitions from status measure is recorded) and will be shown on the Time dimension on the date when the transition from this status happened.
Objects with transitions to status
Objects with transitions from status
Unique count of objects which had transitions during selected Time dimension period to (or from) the status that is selected in the Object Transition Status dimension (or only transitions that are selected in the Object Transition dimension).
Issues created
Issues resolved

How many issues are created/resolved for matching objects in the selected Time period.
You can drill into the detailed list of issues from this measure.

Measures return correct results only on Server/Data Center

Issues dueHow many issues are currently unresolved for matching objects.
You can drill into the detailed list of issues from this measure.

In addition, the following measures will be created for additional selected attributes that are imported as measures and properties:

Numeric Attribute sumIf Numeric Attribute is imported as a measure then this measure will show the total sum of numeric attribute values for matching objects.

Objects with Date Attribute

If Date Attribute is imported as a measure then this measure will show the count of objects that have this date attribute value in the selected Time dimension period.

Object AttributeIf Attribute is imported as property then this measure will show the value of the property for the corresponding object. Should be used with detailed Object dimension members.

Advanced settings for Assets obejct attributes

You can use the eazyBI advanced settings (available only to Jira system administrators, Jira trusted users and eazyBI admins) to modify Assets object attribute import options. eazyBI advanced settings are defined using the TOML format.

Advanced settings for attribute import in the Assets source application are available in Cloud and since eazyBI version 6.6.0.

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:

[source_application.insight.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 stringtextdecimaldatedatetime.

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:

[source_application.insight.customfield_89]
data_type = "integer"
measure = true

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

Assets custom fields in Jira source application

In addition to the Assets data import, eazyBI can import Assets custom fields from Jira issues in the eazyBI Jira source application.

Custom field selection

You can see and select the Assets custom fields in the Jira source application "Add-ons" tab [1]:


Import Assets custom field attributes for Jira issues

eazyBI supports Assets custom field attribute import as properties for Assets custom field dimensions. Please specify the attribute name and data type for any attribute you would like to import into the Jira issue cube in advanced settings for these custom fields:

[jira.customfield_NNNNN]
insight_object_attributes = [
  {name = "Attribute name 1", data_type = "string"},
  {name = "Attribute name 2", data_type = "date"},
  {name = "Attribute name 3", data_type = "boolean", true="Yes", false="No"}
]

Update the definition using Assets custom field ID instead of NNNNN, and attribute names case sensitive with their respective data types string, text, integer, decimal, date, datetime, boolean. Specify only attributes you will use for reports. You can add more attributes to the definition at any time if needed. Add the updated custom field definition to eazyBI advanced settings or ask Jira administrator or eazyBI admin to do this for you. eazyBI advanced settings are common for all accounts and only Jira administrators and eazyBI admins have access to the settings.

eazyBI will import all specified attributes for Assets custom fields imported as dimensions as properties in those dimensions. You can use those properties to add custom hierarchy in Assets custom field dimension. If you would like to add those properties to reports would like to define a new user-defined calculated measure for any imported Assets attribute property using this formula example:

[Assets custom field name].CurrentHierarchyMember.Get('Attribute name')

Please use your own Assets custom field name and attribute name (case sensitive). We suggest using autocomplete to fill in dimension and attribute names in the formula.