If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Filter Data Shown in Tree Prompt

Started by JulioSarmiento, 01 Jan 2008 10:16:58 AM

Previous topic - Next topic

JulioSarmiento

How do i filter the data that is shown in a Tree Prompt?

For example, lets say that the Time Dimension is from 1990 through 2007.  I want the Tree Prompt to only display the years from 2002 through 2007.  How can this be done?

Thank you in advance and hope you all have a wonderful New Year.

Julio

JulioSarmiento

Wow... This was simple.  Solution was to get the query that the Tree Prompt creates and:

[Time].[TimeH].[Year].[YearId] between '2002' and Year(getDate())