Accress to project name in eazyBI

Onur Cevik

Hey,

Could someone tell me how to get the project name? I have a calculated member and try to get the project name. The dimension Issue and Measures existing

Oskars Laganovskis

Hi @Onur Cevik ,

There are multiple options for using Issues and Project dimensions, and they might impact the result.

The user might select nothing, a project, or component and all issues, a specific issue, or a project from the Issue dimension.

You might try the following expression covering the majority of use cases.

 

CASE 
--when no project selected on page filter
WHEN
[Project].CurrentMember.Level.Name = "(All)"
THEN
CASE
WHEN
--specific project displayed in issue dimension
[Issue].CurrentHierarchyMember.Level.Name = "Project"
THEN
[Issue].CurrentHierarchyMember.Name
WHEN
--when "All issues" member displayed - take the Project dimension selection
[Issue].CurrentHierarchyMember.Level.Name = "(All)"
THEN
[Project].CurrentHierarchyMember.Name
ELSE
--when specific issue or epic displayed - find its project
Ancestor(
[Issue].CurrentHierarchyMember,
[Issue].CurrentHierarchy.Levels("Project")).Name
END
--when specific project or component selected - take its project name
--unless specific project applies from Issue dimension
ELSE
CASE
WHEN
--specific project displayed in issue dimension
[Issue].CurrentHierarchyMember.Level.Name = "Project"
THEN
[Issue].CurrentHierarchyMember.Name
WHEN
--when "All issues" member displayed - take the Project dimension selection
[Issue].CurrentHierarchyMember.Level.Name = "(All)"
THEN
Ancestor(
[Project].CurrentHierarchyMember,
[Project].CurrentHierarchy.Levels("Project")).Name
ELSE
--when specific issue or epic displayed - find its project
Ancestor(
[Issue].CurrentHierarchyMember,
[Issue].CurrentHierarchy.Levels("Project")).Name
END 
END 

 

Regards,

Oskars / eazyBI support