B
Bryon Scruggs
I have 10 different pivot table reports tied into an OLAP
data source. In either the page or row fields I have a
category called "product" which filters out specific
results.
My problem: In the future additional "product" values
will be added to the OLAP cube. These will automatically
be included in each pivot table forcing me to manually
remove them whenever I update the tables.
Example: I deal with products A, B, and C. Pivot table 1
only shows products A and B, pivot table 2 shows product
C. Next month we add product D which is automatically
added to both pivot tables whether I need it or not.
Is there any way to shut off this function so that my
current pivot tables are not automatically updated with
new product information?
thanks,
Bryon Scruggs
data source. In either the page or row fields I have a
category called "product" which filters out specific
results.
My problem: In the future additional "product" values
will be added to the OLAP cube. These will automatically
be included in each pivot table forcing me to manually
remove them whenever I update the tables.
Example: I deal with products A, B, and C. Pivot table 1
only shows products A and B, pivot table 2 shows product
C. Next month we add product D which is automatically
added to both pivot tables whether I need it or not.
Is there any way to shut off this function so that my
current pivot tables are not automatically updated with
new product information?
thanks,
Bryon Scruggs