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

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])
)

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