Hi,

The example was written to be used in an mdx query.

Here is the definition for the cube mdx script:

CREATE DYNAMIC SET CurrentCube.[Days] as

{existing [Fiscal Period].[Fiscal Period Hierarchy].[Day]};

CREATE MEMBER CURRENTCUBE.[MEASURES].[LY QUANTITY] AS

Aggregate

(

Generate

(

existing [Days],

{parallelperiod([Fiscal Period].[Fiscal Period Hierarchy].[Year],1,[Fiscal Period].[Fiscal Period Hierarchy].currentmember)}

)

, [Measures].[Quantity]

),

FORMAT_STRING = "#,#",

VISIBLE = 1 ;

Regards