analysis service tutorial

Описание: VISUAL STUDIO 2015: (ye wala: Visual Studio Community 2015 with Update 3)
https://my.visualstudio.com/Downloads...

MICROSOFT SQL SERVER:
https://download.microsoft.com/downlo...

MICROSOFT SQL SERVER MANAGER:
https://download.microsoft.com/downlo...

SQL Server Data Tools (SSDT) for Visual Studio:
https://download.microsoft.com/downlo...

database link:
https://github.com/Microsoft/sql-serv...

SERVER INSTALLATION:
   • Microsoft SQL Server 2017 Installation - S...  

text for this tut

NT Service\MSSQLServerOLAPService


CASE
WHEN MiddleName IS NULL THEN
FirstName + ' ' + LastName
ELSE
FirstName + ' ' + MiddleName + ' ' + LastName
END


CASE ProductLine
WHEN 'M' THEN 'Mountain'
WHEN 'R' THEN 'Road'
WHEN 'S' THEN 'Accessory'
WHEN 'T' THEN 'Touring'
ELSE 'Components'
END


DATENAME(mm, FullDateAlternateKey) + ' ' +
DATENAME(dd, FullDateAlternateKey) + ', ' +
DATENAME(yy, FullDateAlternateKey)


EnglishMonthName+' '+ CONVERT(CHAR (4), CalendarYear)


'Q' + CONVERT(CHAR (1), CalendarQuarter) +' '+ 'CY ' +
CONVERT(CHAR (4), CalendarYear)


CASE
WHEN CalendarSemester = 1 THEN 'H1' + ' ' + 'CY' + ' '
CONVERT(CHAR(4), CalendarYear)
ELSE
'H2' + ' ' + 'CY' + ' ' + CONVERT(CHAR(4), CalendarYear)
END