Getting data out of the cube

[BoggyBoy]

I have the following measure that I have added to my Project Server Cube
(Portfolio_analyzer_cube)

1*([Measures].[Work],[Time].currentmember,[Work Type Res_Resource].[All Work
Type Res_Resource],[Resource List].[Joe])

where

Work Type Res_Resource is a custom dimension that has 6 possible values
and
Resource List].[Joe]
is a resource

I get a value for this measure when the Work Type Res_Resource dimension is
"blank", but nothing when its anything else besides blank. I don't see what
that is the case.



Hope there are some out there familiar with getting data out of the project
server cubes!

 

[Ray McCoppin]

Have you tried using SQL Server Management Studio and browsing the data in
the cube?
The MDX query designer work pretty good as well.

Hope this helps.