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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.