How to address rows in eazyBI

[Onur Cevik]

Hey,

I would like to display values in the row of a project but I don't know how to address the project row. I use Project as pages but I assume it is still a dimension? Thanks in advance.

[elita_kalane]

Hi @Onur Cevik 

Thank you for following up with us! 

Could you please export and share the definition for your eazyBI report?
https://docs.eazybi.com/eazybi/analyze-and-visualize/create-reports/export-and-import-report-definitions
Please send it to support@eazybi.com, and we will continue helping you with your use case through our support email.

It will be easier to help you once I see the report definition. 

Best wishes,

Elita from support@eazybi.com

[Onur Cevik]

Hey @elita_kalane ,

I have sent you the definition. Thanks for helping further.

[elita_kalane]

Hi @Onur Cevik ,

I am Elita from eazyBI support team. 

Thanks for sharing your use case!
I recommend removing the Issue dimension from Rows and dragging the Project dimension to your Rows. Once you have added Project dimension to your Rows, enable the "Pages" button to also add Project dimension to Pages (to allow report filtering by Projects). 

You might find the documentation here https://docs.eazybi.com/eazybi/analyze-and-visualize/create-reports#Createreports-Pagedimensions useful to learn about Page dimensions.


Best wishes,
Elita from support@eazybi.com

[Onur Cevik]

@elita_kalane,

Thanks a lot Elita. Another question. How to get the issues of each project as dropdown? Marked in the picture below

[Onur Cevik]

Extend dimension by their hierarchy level members. Extend dimension project by dimension issues as their hierarchy level members.

[Onur Cevik]

@elita_kalane
Im close to my desired state as you can see in the picture below. But I don´t know how to remove the 1) column which belongs to dimension project on the left. Otherwise the 1) column is necessary as dimension for my calculated members. 

[elita_kalane]

Hi @Onur Cevik 
​Thank you for following up and for sending the screenshots!
​In that case, I suggest moving Issues back to Rows and selecting Project level (that will allow you to expand to the issue level as well). 
​Since you have some project-related formulas in your report, you could get the required details with the following calculated measure (the example below is for returning the Projektstatus. Similarly, you could get other properties of the project by changing the last part in the formula and replacing "Projektstatus" with necessary project properties.  

​[Project].[Project].GetMemberByKey
([Issue].CurrentHierarchyMember.Get('Project key'))
.Get('Projektstatus')

​​Best wishes,
​
​Elita from support@eazybi.com

[elita_kalane]

Hi @Onur Cevik 
​Thank you for following up and for sending the screenshots!
​In that case, I suggest moving Issues back to Rows and selecting Project level (that will allow you to expand to the issue level as well). 
​Since you have some project-related formulas in your report, you could get the required details with the following calculated measure (the example below is for returning the Projektstatus. Similarly, you could get other properties of the project by changing the last part in the formula and replacing "Projektstatus" with necessary project properties. 

​[Project].[Project].GetMemberByKey
([Issue].CurrentHierarchyMember.Get('Project key'))
.Get('Projektstatus')
​

​Best wishes,
​
​Elita from support@eazybi.com

[Onur Cevik]

Hey @elita_kalane ,

Thanks for helping. I have tried it but it doens´t work. The column Projektstatus depends to the column Ampeldarstellung Zeit. Another calculated measures counts every green, orange and red cells in the column Ampeldarstellung Zeit and Projektstatus displays 'Project off track' if amount red status divided by amount issues created if bigger than 0.1 else Project on track. When dimension Project disappears the status in row of project name disappears as well. I hope you can follow me. Pictures attached.

[Onur Cevik]

Hey @elita_kalane 

Otherwise it could work if I change the code. In the post above you can see in line three, that the issue name has to match with the project name. If I replace the code after the equal sign with the name of the project my disered configuration works. How to code after the equal sign to get automatically the project name? In the picture below you can see if I write the name of the project the issue above works.