Insight Asset Management
On Jira Server and Data Center Insight Asset Management data can be imported into eazyBI in two ways, either Insight data structure as a separate data source or Insight custom fields as part of the Jira data source. The data import is supported for Insight Asset Management version 4.x and later.
On this page:
Overview
You can use eazyBI to analyze Insight objects by selected object attributes.
If Insight Asset Management is installed then you can see Insight available when adding a new source application import in the Source Data tab:
It is recommended to create a separate eazyBI account for Insight data import to avoid conflicts with other dimension names in other data cubes. Only one Insight schema objects can be imported in one eazyBI account. Please create separate eazyBI accounts for each Insight schema from which you would like to import data.
Insight import options
After selecting the Insight data source and specifying the cube name (you can leave the default Insight cube name) you will see the import options page:
Select the Insight schema from which you would like to import all objects. As mentioned above, create separate eazyBI accounts if you would like to import data from several insight schemas.
Select regular import frequency and specify how frequently automatic data import should be performed. Initial data import will perform a full import of all schema objects. The next imports (if import options are not changed) will be incremental imports and will process only created and updated objects.
Select which attributes should be used as default Object Status attributes (see below the description of dimensions and measures that are based on the default status attributes).
Then click Show available custom fields to see all object type attributes that are available for import:
Object key, name, and status attributes are imported by default. The other attributes are available for selection here and are grouped by object types:
- 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 Object dimension member properties.
Dimensions and measures
The following standard dimensions and measures will be created after data are imported.
Dimensions
| Object Type | All object types that have 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. |
Object UPDATE | 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. Custom hierarchies in Insight data sources are available starting from the eazyBI version 6.2. |
| Object History Type | The type of object history entries (Added Value, Changed Value, Deleted Value etc.). Use to analyze Object history changes and Objects changed measures. |
| Object History Actor | The author (user or automated system) of object history entries. Use to analyze Object history changes and Objects changed measures. |
| Object History Attribute | The attribute which was changed in object history entries. Use to analyze Object history changes and Objects changed measures. |
| Object Transition Status | All 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 Transition | All 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 UPDATE | Jira issues linked to objects via Insight custom fields. 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. Custom hierarchies in Insight data sources are available starting from the eazyBI version 6.2.2 |
| Time | The 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 created | Total 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). |
| Objects changed | Similar to the previous but shows unique count of objects that have these history changes. |
| Transitions to status | How 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 status | How 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). |
| Hours in transition status | The 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. |
| Issues due | How 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:
| Numeric Attribute sum | If 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 count of objects that have this date attribute value in the selected Time dimension period. |
Calculated measures
| 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 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. |
In addition the following calculated measures will be created for additional selected attributes that are imported as properties:
| Object Attribute | If 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. |
|---|
Import Insight custom fields for Jira issues
In addition to the described Insight data import, it is also possible to import Insight custom fields in eazyBI Jira issues import.
Custom field selection
When selecting available JIRA custom fields you can see and select defined Insight custom fields:
Import Insight custom field attributes for Jira issues
eazyBI supports Insight custom field attribute import as properties for Insight custom field dimensions. Please specify attribute name and data type for any attribute you would like to import into 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 Insight 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 Insight custom fields imported as dimensions as properties in those dimensions. You can use those properties to add custom hierarchy in Insight 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 Insight attribute property using this formula example:
[Insight custom field name].CurrentHierarchyMember.Get('Attribute name')
Please use your own Insight custom field name and attribute name (case sensitive). We suggest using autocomplete to fill in dimension and attribute names in the formula.