Enrich sprint with additional data via import

Questions & Answers
1

Hello all,
I’m trying to import additional data for sprints. This data is called capacity. So I defined an excel table with columns Key, Capacity.

In Key I put in the sprint id, in Capacity an integer value. The Capacity data I want to show in relation to the Sprint.

EazyBI_QA1

Table was imported into Issues cube, but I do not get a handle on how to map this imported data to jira data.

BR
Dirk

2

Could not add this to original post. Import def:

EazyBI_QA1b
EazyBI_QA1b1898×311 11.2 KB

3

Solved it by changing import file / definition

image
image1468×376 6.68 KB

4

now it appears as property for a sprint:

image
image928×400 11.9 KB

5

Hi dirk,
Welcome to the eazyBI community!

Your first way (first import screenshot) should work with the following edits:

  • When dimension is selected to be “Sprint”, the level also should be chosen from the drop-down and be “Sprint”.

  • In advanced options select “Key columns” and “Skip missing”, to skip the lines if file contains key, that is not in Issues cube.

2286×1540 280 KB

After the import, the measure and property should be visible in “Measures” (started typing “Cap” in search box to limit the list):

1460×526 31.3 KB

To access property in formulas, use:
[Sprint].CurrentHierarchyMember.get('Capacity')

Let me know if this worked for you.

Best,
Ilze

1 Like
6

Hi Ilze,

thx that works out.

BR
Dirk