Miscellaneous Analysis Services Topics - SQL Server Analysis Services 2012 Cube Development - page 419

AS [dbo_DimTimeMonthNumberOfYear0_1],
[dbo_DimTime].[dbo_DimTimeMonthName0_2] AS
[dbo_DimTimeMonthName0_2],
[dbo_DimTime].[dbo_DimTimeMonthNameValue0_3] AS
[dbo_DimTimeMonthNameValue0_3],
[dbo_DimTime].[dbo_DimTimeCalendarQuarter0_4]
AS [dbo_DimTimeCalendarQuarter0_4]
FROM
(
SELECT [CalendarYear] AS
[dbo_DimTimeCalendarYear0_0],
[MonthNumberOfYear] AS
[dbo_DimTimeMonthNumberOfYear0_1],
EnglishMonthName+' '+ CONVERT(CHAR (4),
CalendarYear) AS [dbo_DimTimeMonthName0_2],
CAST(CONVERT( CHAR(2),
MonthNumberOfYear) + '/ ' + '1/
'+CONVERT(CHAR(4), CalendarYear)
AS DATE ) AS
[dbo_DimTimeMonthNameValue0_3],
[CalendarQuarter] AS
[dbo_DimTimeCalendarQuarter0_4]
FROM [dbo].[DimDate]
)
AS [dbo_DimTime]
Analysis Services retrieves calendar quarter and calendar year, along with month
number and month name columns. While calendar year and month number are the
key columns for the month name attribute, Analysis Services retrieves the calendar
quarter column because the month name attribute is directly related to the calen-
dar quarter attribute (you can confirm that through the attribute relationships' tab in
SSDT). If, due to data consistency issues, the query retrieving calendar quarter at-
tribute members get a key not retrieved by the month name attribute's processing
query, the dimension processing job will fail and report the missing attribute key er-
ror. The best way to troubleshoot such errors is to grab the SELECT statements ex-
ecuted by Analysis Services and execute them against your relational data source.