OLAP

[Beverly Darvill]

I have a pivot table that takes data from an OLAP cube - my problem is that
when a new project plan is added to the OLAP cube and I do a refresh on the
pivot table it includes the new plan - is there a way of stopping this and
only selecting the one field I have asked for. For example : I have selected
an entry from the drop down list of 518 and a new plan called ABC123 is added
to the cube when I do the refresh I only want 518 to be selected an no other
item.

Is there a way I can do this?

Thanks

 

[Pecoflyer]

I have a pivot table that takes data from an OLAP cube - my problem i
that
when a new project plan is added to the OLAP cube and I do a refresh o
the
pivot table it includes the new plan - is there a way of stopping thi
and
only selecting the one field I have asked for. For example : I hav
selected
an entry from the drop down list of 518 and a new plan called ABC123 i
added
to the cube when I do the refresh I only want 518 to be selected an n
other
item.

Is there a way I can do this?

Thanks

Didn't you already post this on Feb 12th in the Miscellaneou
questions

--
Pecoflye

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows fil
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faste