with  set [AAA_PARTNERS] as '{[Партнер].Children}' set [AAA_PRODUCTS] as '{[Товар].Children}'  
Set [AAA_VENDORS] as '{[Вендоры].&[4004678]}'  member [Вендоры].[BBB_VENDORS] as 'Aggregate({[AAA_VENDORS]})', SOLVE_ORDER= 1 
Set [AAA_TIMES] as '{[Время].[2005].[Квартал 4].[Декабрь].[52].[19]:[Время].[2006].[Квартал 1].[Январь].[3].[15]}' 
member [Время].[BBB_TIMES] as 'Aggregate({[AAA_TIMES]})', SOLVE_ORDER= 2 
member [Measures].[Партнёр-Название] as '[Партнер].CurrentMember.Properties("Партнёр-Название")', SOLVE_ORDER= 3    
set [AAA_MEASURES] as '{[Measures].[Партнёр-Название],[Measures].[Количество]}' 
Select  [AAA_MEASURES] on AXIS( 0 ),  
non empty filter(NonEmptyCrossJoin([AAA_PARTNERS],[AAA_PRODUCTS]), 
Len([Measures].[Партнёр-Название])> 0  and  [Measures].[Количество]> 0 ) on AXIS( 1 ) from "SALES" where ([Вендоры].[BBB_VENDORS],[Время].[BBB_TIMES])

Select  [AAA_MEASURES] on AXIS( 0 ), non empty Filter(NonEmptyCrossJoin([AAA_PARTNERS],[AAA_PRODUCTS],[Measures].[Количество]> 0 ),Len([Measures].[Партнёр-Название])> 0  and  [Measures].[Количество]> 0 ) on AXIS( 1 ) from "SALES" where ([Вендоры].[BBB_VENDORS],[Время].[BBB_TIMES])

---------------------------
MDX Sample Application
---------------------------
Unable to open cellset

Formula error - unknown error


---------------------------
ОК   
---------------------------