I have an excel pivot that is linked to to an OLAP cube.
We are using both XP and Excel 2003, with AS 2K sp4.
(This problem was also occuring in sp3)
Say, I have 3 values in a olap dimension located on either the page or row axis today:
ABC Company
DEF Company
XYZ Company
I select only 2, ABC and DEF.
during the night the cube processes and add one company to
the dimension, 123 Company.
When I go back into excel the next morning there are 3
values selected in the dimension
ABC Company
DEF Company
and the new 123 Company!!
I logged the MDX that excel uses and it looks like it is
using some except function to exclude dimension members,
not include based off of what is selected.
It seems very ineffecient to do this especially since some
dimensions can conatain tens of thousands(if not more) values, and I'm only selecting 3.
I do not want new members of the dimension to be selected
every time one is added.
Does anyone have a workaround for this?
Thanks in advance.
We are using both XP and Excel 2003, with AS 2K sp4.
(This problem was also occuring in sp3)
Say, I have 3 values in a olap dimension located on either the page or row axis today:
ABC Company
DEF Company
XYZ Company
I select only 2, ABC and DEF.
during the night the cube processes and add one company to
the dimension, 123 Company.
When I go back into excel the next morning there are 3
values selected in the dimension
ABC Company
DEF Company
and the new 123 Company!!
I logged the MDX that excel uses and it looks like it is
using some except function to exclude dimension members,
not include based off of what is selected.
It seems very ineffecient to do this especially since some
dimensions can conatain tens of thousands(if not more) values, and I'm only selecting 3.
I do not want new members of the dimension to be selected
every time one is added.
Does anyone have a workaround for this?
Thanks in advance.