posted 8/8/2011 by timmurphy - Views: [1231]
It is possible that your cube might seem to behave properly until you add a date filter while browsing in Excel. If so you need to check the ValueColumn property for the Key attribute for your date dimension. It is found at the bottom of the properties window for the Dimension Attribute.
The Value column is what will be used to evaluate expressions like filter in the underlying MDX behind Excel. Click on the Ellipsis button and select the appropriate value.
In this case the value should be “Bound” to the Date Column in the Date table.