Hi Hrvoje,

I created a named set called [Day] with the script {existing [Fiscal Period].[Fiscal Period Hierarchy].[Day]}

Then, I created a calculated measure [LY Quantity] as Aggregate

(generate(

existing [Day],

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

)

, [Measures].[Quantity]

)

The SQL 2005 Cube processes okay but brings value error in the browser. When I hover over, I am getting 'Aggregate functions cannot be used on calculated members in the Measures dimensions'

Regards,

Uma