MDX

 WITH

MEMBER [Measures].[PERIODIC] AS 'IIF([/CPMB/BYD2ZDH                 PARENTH1].[2/CPMB/ACCTYPE]="INC",
-[Measures].[/CPMB/SDATA],
IIF([/CPMB/BYD2ZDH                 PARENTH1].[2/CPMB/ACCTYPE]="EXP",
[Measures].[/CPMB/SDATA],
IIF([/CPMB/BYD2ZDH                 PARENTH1].[2/CPMB/ACCTYPE]="AST",
([Measures].[/CPMB/SDATA],
 CLOSINGPERIOD([/CPMB/BYDEZ94                 PARENTH1].[LEVEL02])),
IIF([/CPMB/BYD2ZDH                 PARENTH1].[2/CPMB/ACCTYPE]="LEQ",
-([Measures].[/CPMB/SDATA],
 CLOSINGPERIOD([/CPMB/BYDEZ94                 PARENTH1].[LEVEL02])),
-[Measures].[/CPMB/SDATA]))))' SOLVE_ORDER=3
MEMBER [/CPMB/BYD2ZDH                 PARENTH1].[OPENING_ASSETS] AS '([/CPMB/BYD2ZDH                 PARENTH1].[ENDING_ASSETS                   /CPMB/BYD2ZDH],
[/CPMB/BYDEZ94                 PARENTH1].PREVMEMBER)'   SOLVE_ORDER=5
SELECT
 NON EMPTY  {[/CPMB/BYDEZ94                 PARENTH1].[2015.01] ,
[/CPMB/BYDEZ94                 PARENTH1].[2015.02] ,
[/CPMB/BYDEZ94                 PARENTH1].[2015.03] ,
[/CPMB/BYDEZ94                 PARENTH1].[2015.04] ,
[/CPMB/BYDEZ94                 PARENTH1].[2015.05] ,
[/CPMB/BYDEZ94                 PARENTH1].[2015.06] ,
[/CPMB/BYDEZ94                 PARENTH1].[2015.07] ,
[/CPMB/BYDEZ94                 PARENTH1].[2015.08] ,
[/CPMB/BYDEZ94                 PARENTH1].[2015.09] ,
[/CPMB/BYDEZ94                 PARENTH1].[2015.10] ,
[/CPMB/BYDEZ94                 PARENTH1].[2015.11] ,
[/CPMB/BYDEZ94                 PARENTH1].[2015.12] } * {[/CPMB/BYD2ZDH                 PARENTH1].[ENDING_ASSETS                   /CPMB/BYD2ZDH] ,
[/CPMB/BYD2ZDH                 PARENTH1].[EXCHANGES                       /CPMB/BYD2ZDH] ,
[/CPMB/BYD2ZDH                 PARENTH1].[MARKET_AND_INCOME               /CPMB/BYD2ZDH] ,
[/CPMB/BYD2ZDH                 PARENTH1].[NETINC_AND_OTHER                /CPMB/BYD2ZDH] ,
[/CPMB/BYD2ZDH                 PARENTH1].[NET_SALES                       /CPMB/BYD2ZDH] ,
[/CPMB/BYD2ZDH                 PARENTH1].[OPENING_ASSETS] ,
[/CPMB/BYD2ZDH                 PARENTH1].[OPENING_ASSETS_TOT              /CPMB/BYD2ZDH] ,
[/CPMB/BYD2ZDH                 PARENTH1].[TOTAL_MARKET                    /CPMB/BYD2ZDH] ,
[/CPMB/BYD2ZDH                 PARENTH1].[ACQUIRED_ASSETS] ,
[/CPMB/BYD2ZDH                 PARENTH1].[ENDING_ASSETS_INP] ,
[/CPMB/BYD2ZDH                 PARENTH1].[EXCHANGES_IN] ,
[/CPMB/BYD2ZDH                 PARENTH1].[EXCHANGES_OUT] ,
[/CPMB/BYD2ZDH                 PARENTH1].[INCOME_DIST] ,
[/CPMB/BYD2ZDH                 PARENTH1].[MARKET] ,
[/CPMB/BYD2ZDH                 PARENTH1].[MARKET_CALC] ,
[/CPMB/BYD2ZDH                 PARENTH1].[NET_INCOME] ,
[/CPMB/BYD2ZDH                 PARENTH1].[OPENING_ASSETS_INP] ,
[/CPMB/BYD2ZDH                 PARENTH1].[OTHER_INCOME] ,
[/CPMB/BYD2ZDH                 PARENTH1].[PROFIT_LOSS] ,
[/CPMB/BYD2ZDH                 PARENTH1].[REDEMPTIONS] ,
[/CPMB/BYD2ZDH                 PARENTH1].[SALES] } ON 0
from
  [/CPMB/BYMZBSV/!!O/CPMB/BYMZBSV]
WHERE
 ( [Measures].[PERIODIC] ,
[/CPMB/BYDVNY1                 PARENTH1].[CHUCK_TESTING2] ,
[/CPMB/BYDKNZU].[CAD] ,
[/CPMB/BYDSW0Y                 PARENTH1].[INP_ALLOC] ,
[/CPMB/BYDZ9TU                 PARENTH1].[INPUT_DLR_TOTAL] ,
[/CPMB/BYDRHQ7                 PARENTH1].[INPUT_TOTAL_CHANNEL] ,
[/CPMB/BYDVMX9                 PARENTH1].[INPUT_PRODUCT_TOTAL] ,
[/CPMB/BYDRQ4Q                 PARENTH1].[INPUT_TOTAL_LOAD] ,
[/CPMB/BYDR516                 PARENTH1].[NO_SERIES] )