alexey-kar · January 23, 2018 18:14
diff --git a/olap b/olap
 SELECT * FROM OPENQUERY([SSAS_DashboardCRM_MCART],
 'SELECT
 NON EMPTY [Сотрудники].[Сотрудник].[Сотрудник] ON ROWS,
 {[Measures].[Оборот план], [Measures].[Оборот факт]} ON COLUMNS
 FROM [DashboardCRM]
 WHERE ([Даты].[ГМ].[Месяц].&[2017411], [UserLogin].[Parent Login].&[\\RUSKLIMAT\\varivoda_i])')
	SELECT * FROM OPENQUERY([SSAS_DashboardCRM_MCART],
	'SELECT
	NON EMPTY [Сотрудники].[Сотрудник].[Сотрудник] ON ROWS,
	{[Measures].[Оборот план], [Measures].[Оборот факт]} ON COLUMNS
	FROM [DashboardCRM]
	WHERE ([Даты].[ГМ].[Месяц].&[2017411], [UserLogin].[Parent Login].&[\\RUSKLIMAT\\varivoda_i])')