E
erdal akbulut
Hi,
I have a strange problem.
MS Excel 2003 pivot table linked to SSAS 2005 Cube. One of the dimensions
let's say Customer is filtered on the pivot table. 5 from total of 100
Customers are selected in filter. Next day assume 2 new customers added to
customer dimension and when the pivot refreshed those 2 new customers are
automaticly added to filter and the result is 7 customers selected out of
102 total.
Do you know any ways to prevent this and keeping the only original filter
without adding new records?
Thanks in advance
erdal
I have a strange problem.
MS Excel 2003 pivot table linked to SSAS 2005 Cube. One of the dimensions
let's say Customer is filtered on the pivot table. 5 from total of 100
Customers are selected in filter. Next day assume 2 new customers added to
customer dimension and when the pivot refreshed those 2 new customers are
automaticly added to filter and the result is 7 customers selected out of
102 total.
Do you know any ways to prevent this and keeping the only original filter
without adding new records?
Thanks in advance
erdal