Some time ago we run into following problem. When we browsed Accounts Receivable Cube for Total Sales dimension we could see data only till 2008 year, the data for years: 2009, 2010 and 2011 where just simple not displayed.
The first idea was to try solution from following post: http://blogs.msdn.com/b/emeadaxsupport/archive/2011/01/07/olap-time-dimension-does-not-contain-dates-for-year-2011.aspx but it did not help. Then we double check that in OLTP database we for sure have needed data from i.e. 2010 year
The query which is run to compute Total Sales is based on named query CustTransTotalSales. The measure Total Sales has relation with Time dimension using DUEDATE field. So to double check that query returns data for year 2010 we tried to run following query:
Query returned values so we needed to look further what is wrong
With help of Analysis Services EE we saw that [Measures].[Total Sales] is changed/altered by a Scope with following expression:
The [Measures].[Master end of day rate] is used internally by above expression is null for the 2010 year and will cause that all other measure will be null for 2010. Measure is based on following named query:
If you check following query:
You will see that the last value is for year 2008
So to fix the problem we needed:
1. Go to Administration > Setup > Business analysis > OLAP > BI generation options (if you get error please look into post: http://blogs.msdn.com/b/emeadaxsupport/archive/2011/02/07/error-when-accessing-form-bi-generation-options.aspx)
2. Go to Time dimension tab Make sure that Ending time is set up till the end of this year or further and click OK
3. Go to Administration > Setup > Business analysis > OLAP > Setup Exchange Rates and run the process
After this when you run Select
You should get the ending date from 3rd step Process cubes
Now you can process cubes and data for remaining years will appear in cube.