Hey team,
I am attempting to develop a number of reports that breakdown activities on a range of our products.
Our structure in the Roadmap looks like this:
Phase = Capability in Acquisition
Sub Project = Capability
Initiative = Product
Epic = Major deliverable
Task = Work being done.
In Measures I have created a series of Calculated Members which pull out the product, i.e.
Aggregate(
[Advanced Roadmaps Initiative].[abc-123],
[Measures].[Open Issues]
)
However this precludes me from getting a proper range of reports like I would get if I selected Project as a page or Row.
What can I do to have each of these Products (Initiatives) be available as either a Row or Page so that I can then select the range of measures to report against them, such as Open Issues, Created Issues, Risks etc?
Hope I’ve asked this clearly enough and thanks in advance for any advice you can provide.
Cheers
Dave
