There are two filters added to the report filter, Date (8/31/2010) and Product (Product A), from a cube I have. Everything works just fine. Once the cube is refreshed each day to include the new data, for some reason, only the selection of Date,
8/31/2010, stays but the selection of Product changes to All Products. Both dimensions are fully processed but the surrogate keys for existing records do not change. I checked the MDX captured in Profiler and in the where clause, the date selection
is passed from the pivot table but the product selection is lost and all products is passed in. Any thoughts? TIA.
View Complete Post