Member: Revenue Recognition Amount Previous FY
CREATE MEMBER CURRENTCUBE.[MEASURES].[Revenue Recognition Amount Previous FY]
AS NULL,
FORMAT_STRING = "Currency",
NON_EMPTY_BEHAVIOR = {[MEASURES].[Revenue Recognition Amount]},
VISIBLE = 1 , DISPLAY_FOLDER = 'Previous Fiscal Year' , ASSOCIATED_MEASURE_GROUP = 'Revenue Recognition';
(
[Date].[Fiscal Year].[Fiscal Year].MEMBERS(1) : NULL
,[Date].[Fiscal Date].MEMBERS
,[MEASURES].[Revenue Recognition Amount Previous FY]
) =
(
ParallelPeriod
(
[Date].[Fiscal Date].[Fiscal Year]
,1
,[Date].[Fiscal Date].CurrentMember
)
,[MEASURES].[Revenue Recognition Amount]
);