I need to reproduce the behaviour of the averageofchildren function with the exception that the function should always build the average of all members (even when the value of a member equals null). As you know average of children function always build the
average at the lowest level of the time dimension.
My date dimension looks like the following:
[Date].[Fiscal] user defined hierarchy:
if context of [Date].[Fiscal].CurrentMember corresponds to a Week, I can retrieve all weeks before the current week using
In Period: MTD([Date].[Fiscal].CurrentMember) -- PeriodsToDate also works fine
In Year: YTD([Date].[Fiscal].CurrentMember)
if context of [Date].[Fiscal].CurrentMember corresponds to a Period
How can I get all weeks (NOT Periods!) contained in all Periods before and within current period since start of year?
What would be a generic expression that retrieves all weeks before and in independently of level of selected Date dimension member
View Complete Post