problem accessing Pivot table Excel 2007
 

Hi,
I got a problem accessing a cube with dynamic security implemented. Once I
access the cube using pivot table, it displays the correct security but after
a while it goes blank and when I move the secured dimension into another
place,like in the filter area of the pivot, the excel displays "excel cannot
complete this task with available resources. choose less data or close other
applications." but when I revisit the role (which implements the security on
a particular dimension in the cube) and click 'ok' then refresh the pivot,
the values then again appeared but disppearas in a short while (usually after
a minute). This happens in our production server ( 8 gig mem/32 bit ) but
this doesn't happen on our development server ( 2 gig/32 bit ). I was
wondering what could be the problem. Any comments and help will be greatly
appreciated. Thanks in advance.