A row or column of “Not Valid” data in a view means that a time level in the view does not apply to some of the measure items in the view. Such measure items have their data assigned to the “Not Valid” member so you can still see their data in the view.
The view in the prior example has levels from Year Days on rows. The levels are applicable to the Daily Sales measure item in the view. There is Daily Sales data for years 2012 through 2014. The Year Days levels are not valid for the other three measure items of Actual Sales, Budget, and Forecast. Data for those three measure items gets assigned to the “Not Valid” member for Year Days. The “Not Valid” member also will show up in related filtering windows for Year Days such as in the Select Members window.
Consider choosing a time dimension that is applicable to all measure items in the view. In the following example, using Year Months instead of Year Days eliminates the “Not Valid” row. Year Months is valid for all four measure items. Here is the updated view after changing the time dimension.
