I am currently working with a client that has several OLAP cubes that contain date sets. When some users are accessing the cubes and pulling in the sets the numbers are not correct. So for example a user is pulling in 13 wk set and sales calculation the numbers are not correct. When they change to 26 week set the numbers are correct. I have tried to recreate the issue and cannot reproduce it in Excel, on the server. I have run profiler to examine the MDX and the queries are identical between mine and the user. The permissions are the same we both have full access to the data. Different users have issues with different sets. One user is 8 wk and 13 wk and another user is 52 wk and current year. The set are all created identically with the exception of the number of weeks.
Also if the same user pulls in an additional dimension such as sku the row level data when selected will total to the correct number but the subtotal line or grand total line is still not correct.
Does anyone have any idea what could be causing this odd and random behavior?