MDX Expression help

[David Blair]

Hello,
I am trying to create an MDX Expression that shows Capacity only for
Contractor Resources. I have created a Resource Field using a Table that has
a list of Values, one of which is Contractor. I have applied these values to
the resources. So, I just want to new Total in the Cube that gives me
Capacity for only those resources that have the value 'contractor' for that
field. I know I can use the field in the filter section of the Data Analysis
view, but I eventually want to show a graph line of Total Capacity (for
selected resources) AND a line of just 'Contractor' Capacity in the same
view. I would appreciate any thoughts.
Thanks,
David

 

[Gary L. Chefetz]

David:

Project Server already calculates capacity, so all you have to do is use the
new custom field to filter the results in an analysis view. Is there some
reason why this approach doesn't work for you?

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com

 

[David Blair]

Hi Gary and thanks - Yes, the problem is that I need to show BOTH the Total
Capacity of selected resources (which is the built in Capacity total) AND the
Capacity of the those that are contractors. I can get the info in the Pivot
Table with the capacity for contractors and it shows the Grand Total, but
the Pivot Chart can't show the Grand Total. So, I can't seem to get that
'Grand Total Capacity' line and another line for just contractors. I have
been trying the stacked bar graph that at least will top out at the total,
but can't get the numbers on it. Also, trying some series grouping, but
(without being even a novice at MDX expressions) there seems to be an answer
in there somewhere that just lets me create a new Total field that is the
"Capacity of the resources that are contractors".
David

 

[Gary L. Chefetz]

David:

Have you tried brining the pivot table into Excel? If you want to build a
new total using MDX, your best reference is MSDN:
http://msdn.microsoft.com/en-us/library/ms145506.aspx although I still think
you can get what you want without coding using your new custom resource
field as a dimension. If you do opt to build a new MDX total, you should ask
your follow-up questions in the developer newsgroup.

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com