A relative date filter set to return the last three weeks actually returns 5 or 6 days less than expected when using a Microsoft Analysis Services connection.
- When a relative data filter is set to return 3 weeks, the correct dates are returned in the filter but only 2 weeks are showed in the view.
- Thehe view returns 5 or 6 days less than expected at the beginning of the period depending on the starting day of the week. When the week starts on Sunday, 6 days are missing. When the week starts on Monday, 5 days are missing.
- The expected result is computed correctly in the filter. The data returned by the query is incomplete.