Hi Everyone!
I am building a Report Studio report using Power Cube.
I could not figure out how to get a set of the months between the given [Start Month] and [End Month] members using the dimensional functions.
Can you please show how to do it with the sample Great Outdoors Company cube?
Ideally I would like to know in general how to get a set of members between given Start and End members on the same level.
intersect(
lastPeriods(-99999, [Start Member]),
lastPeriods( 99999, [End Member])
)