SELECT
cast(cast("[Дата].[Дата].[Дата].[Key]" as char(8)) as date) as check_date,
cast("[ККМ-ТТ].[ТТ].[ТТ].[Key]" as char(20)) as tt_code,
cast("[Товары].[КодТовара].[КодТовара].[Key]" as char(20)) as tov_sup_code,
cast(cast("[Measures].[Кол-во]" as char(20)) as integer) as count_tov
FROM OpenRowset(
'MSOLAP',
'DATASOURCE=cube; Initial Catalog="Чеки77_2013";user=CD\DBAdmin;password=123Qwerty!',
'
-- MDX start here
SELECT
       NON EMPTY {
       {[Measures].[Кол-во]}
       } DIMENSION PROPERTIES PARENT_UNIQUE_NAME, CHILDREN_CARDINALITY ON COLUMNS,
       NON EMPTY {
       {[Дата].[Дата].[All].&[20160801]:[Дата].[Дата].[All].&[20160801]} *
       {[ККМ-ТТ].[ТТ].[ТТ].&[517]} *
       {[Товары].[КодТовара].[КодТовара]}
       } DIMENSION PROPERTIES [Дата].[Дата].[Key0], [ККМ-ТТ].[ТТ].[Key0],[Товары].[КодТовара].[КодТовара].[Key0] ON ROWS
FROM [Checks]
WHERE
(
       [Товары].[Группа].[Пиво],
       [Товары].[ТипТовара].[Алкоголь]
)
--MDX end here
       '
)