J
Jesper Bødtkjer
Hi,
In the Portfolio Analyser, I am trying to display distribution (count) of
projects per projectphase (defined as Enterprise Outline Code) or
distribution (count) of projects per Project Manager (also defined as
Enterprise Outline Code).
I can easily display measures like sum of Baseline Cost or Work as these are
already defined as measures in the CUBE, but simply counting the number of
projects that fall into certain categories (values of the Outline Code)
seems to be a problem. There seems not to be any functionality like for
Pivot Tables in Excel where you can easily change Field Setting from "Sum"
to "Count". I am wondering if you need to create a new measure on Analysis
Services and exactly how to do that.
Hope someone has a solution.
Regards,
Jesper
In the Portfolio Analyser, I am trying to display distribution (count) of
projects per projectphase (defined as Enterprise Outline Code) or
distribution (count) of projects per Project Manager (also defined as
Enterprise Outline Code).
I can easily display measures like sum of Baseline Cost or Work as these are
already defined as measures in the CUBE, but simply counting the number of
projects that fall into certain categories (values of the Outline Code)
seems to be a problem. There seems not to be any functionality like for
Pivot Tables in Excel where you can easily change Field Setting from "Sum"
to "Count". I am wondering if you need to create a new measure on Analysis
Services and exactly how to do that.
Hope someone has a solution.
Regards,
Jesper