Data Analysis Report: Admin vs Project Time

[Coenraad Swanepoel]

Hi

We are looking at creating a Data Analysis Report to show the total hours
worked per resource, split into Project and Non-Project (Admin) time. At
this stage we can create a view which displays all the hours for Project and
Non-Projhect (Admin) time, but the Admin Time is still split into the
various admin categories/types.

I am not sure whether there is any other way of creating this view other
than adding a new 'field' using MDX expressions. If there is any other
solution, please advise, or if you are able to assist with creating a
suitable MDX expression for this, please send this through as well.

Thank You
Regards
Coenraad Swanepoel

 

[Caroline]

Hi

We are looking at creating a Data Analysis Report to show the total hours
worked per resource, split into Project and Non-Project (Admin) time. At
this stage we can create a view which displays all the hours for Project and
Non-Projhect (Admin) time, but the Admin Time is still split into the
various admin categories/types.

I am not sure whether there is any other way of creating this view other
than adding a new 'field' using MDX expressions. If there is any other
solution, please advise, or if you are able to assist with creating a
suitable MDX expression for this, please send this through as well.

Thank You
Regards
Coenraad Swanepoel

I've been trying to do this exact same thing and not sucessful so far,
looking forward to the answer!

Caroline

 

[Mike Mahoney]

I've been trying to do this exact same thing and not sucessful so far,
looking forward to the answer!

Caroline- Hide quoted text -

- Show quoted text -

See this blog:
http://sleekstone.spaces.live.com/blog/cns!ED36ABFDCD099E3B!149.entry

The only way to get such an analysis is with custom cube or SRS
report.

regards

Mike