Firstly I would like to announce myself as a total beginner in MDX. I am trying to filter the issues by a component and exclude out all the subtasks.
May I know how can I achieve that?
Firstly I would like to announce myself as a total beginner in MDX. I am trying to filter the issues by a component and exclude out all the subtasks.
May I know how can I achieve that?
Hello Jeff,
Start with using what is already available before jumping into custom calculations or customizations. It works faster and it is easier to debug.
Here’s a (very) simple report that will hopefully solve your problem. I see there’s a “Component” dimension in your eazyBI account (there is also an “Issue component” in “Measures” that can be used).
{
"cube_name": "Issues",
"cube_reports": [ {
"name": "tasks by component",
"folder_name": "VasileS.playground",
"result_view": "table",
"definition": {"columns":{"dimensions":[{"name":"Measures","selected_set":["[Measures].[Issues created]"],"members":[]}]},"rows":{"dimensions":[{"name":"Component","selected_set":["[Component].[Component].Members"],"members":[],"bookmarked_members":[]}]},"pages":{"dimensions":[{"name":"Issue Type","selected_set":["[Issue Type].[All Issue Types]"],"members":[{"depth":1,"name":"Task","full_name":"[Issue Type].[Task]"}],"bookmarked_members":[],"current_page_members":["[Issue Type].[Task]"]}]},"options":{},"view":{"current":"table","maximized":false,"table":{"row_dimension_headers":{"Component":true}}},"calculated_members":[]}
} ],
"calculated_members": []
}
Kind regards,
Vasile S.