Frustration with the Cube

L

Laureen

Hello,

I am hoping someone can help as I have spent countless hours trying to
resolve an issue I am having with the cube.

I have set up a resource allocation cube- it works very nice. I have the
data grouped by RBS, then by Resource, then Project and then all hours
available and booked for each month. All groups are collapsed. When I click
on a resource to see which projects he/she is assigned too- it shows me all
projects for the entire RBS- not just the ones that the resources are
assigned to. Any thoughts?

Thanks!
 
L

Laureen

Ben,

Yes, zero hours worked. I cannot seem to filter out those projects that
only have work.
 
B

Ben Howard

Hi Laureen,
I think you'll have to work with the data in Excel and filter out the 0
hours. Worth posting to the Excel newsgroup for how to do this with a pivot
table.
 
M

Mike

Hi Laureen,
I think you'll have to work with the data in Excel and filter out the 0
hours. Worth posting to the Excel newsgroup for how to do this with a pivot
table.
--
Thanks, Ben.http://appleparkltd.spaces.live.com/







- Show quoted text -
Click to expand...

Laureen

You could create a calculated field to filter only tasks with work
(this is how PS2003 use to work). This example only displays
availability data if there is no work.

Availability = iif(IsEmpty(Sum([Time].[Year].members,[Measures].
[Work])), null, [Measures].[Temp Availability])

regards

Mike
 
Top