COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Andrei I on 09 Aug 2007 08:38:01 AM

Title: Get a set of members between given Start and End members on the same leve
Post by: Andrei I on 09 Aug 2007 08:38:01 AM
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.
Title: As recommended by Cognos support: use intersect and lastPeriods
Post by: Andrei I on 10 Aug 2007 08:41:47 AM

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