How to use GetEfficientPeriodsToDateSet
-
Saturday, January 26, 2013 1:39 AM
I am new to MDX wanted to know how to give the start time to this stored proc in my mdx, it looks like all it takes is a level in Hiararchy. I dont want to aggregate everything but only start aggregating from a certain time period. This example is good, but its summing up everything from the beginning of the time till the end of the time period sepecified. I want to be able to specify the beginning time too. How can I do that.
Thanks much
with member [y] as CSTR([D Date].[YEAR].CurrentMember.Name) member [m] as CSTR([D Date].[month no].CurrentMember.Name) member [d] as CSTR([D Date].[day].CurrentMember.Name) select {[Measures].[Normal],[y],[m],[d]} on 0, ASSP.GetEfficientPeriodsToDateSet("(All)",[D Date].[Hierarchy].[YEAR].[2012].[5].[8]) on 1 from [TC Cube]
.png)
