Get a set of members between given Start and End members on the same leve

[Andrei I]

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.

[Andrei I]

intersect(
  lastPeriods(-99999, [Start Member]),
  lastPeriods( 99999, [End Member])
)