2007: Data analyzer OLAP, no work displayed

[Mvisscher]

Hello,

I created a new Data Analyzer view in 2007, using the cube
MSP_Portfolio_Analyzer. The OLAP cubes have been built succesfully.

I create a view with row = "Resource list", column = "Work" and this is
showing correctly the "work" hours. When I add RBS in the filter of the
report, still all the work is displayed correctly. The top level of the RBS
shows -(Blank) and - BAN. When I select (Blank) as filter then no work hours
are displayed, when I select BAN also no work hours are displayed. This is
incorrect. Also when i select a department below BAN, no work is displayed.
This is also incorrect. No other filters are applied.

It seems that there is no link between the resource and the RBS. Has anyone
seen the seem behaviour?

 

[Mvisscher]

I found the solution.
In the Configuration of the cube the RBS_resources dimension was not listed
in the Assignment cube.
I added it and rebuild the cube. Now it is working fine