Dimension Component as filter


I use the following script to create a dimension “Component”:

Customer as poperty and dimension

name = “Component”
data_type =“string”
dimension = true
multiple_values = true
split_by = “,”
var components=issue.fields.components;
var result=[];
if (components) {
for (var i=0;i<components.length;i++) {

Then, I create a new calculated member in “Component” dimension for just one specific project with:

([Project].CurrentHierarchyMember.Parent.Name = ‘PROJECT’)

But when, i click on a selected component, i got this error:

" Failed to parse query, try to make query simpler.
Or maybe saved report uses deleted calculated member.
Error message:
Hierarchy ‘[Project]’ appears in more than one independent axis. "

Can someone help me?

You are addressing Project dimension in the calculated member in the Component dimension. eazyBI should give you a warning that addressing another dimension is not supported. Please remove this calculated member. It does not work anyway.

If you would like to filter data by projects, please add project dimension to the report on Pages and select the needed project there.

Or you can use the Project dimension with the option to select one project and expand it to components.

Daina / support@eazybi.com

Thanks @daina.tupule

Since eayBI version 6.6 and on Cloud, there is an option to create calculated fields in the account import options (without disturbing Jira system administrator or eazyBI admin).

Now you can create a Component dimension in import options → tab Custom fields.

For more details and the example please see the documentation here: New calculated fields

Zane /support@eazyBI.com