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

Tree prompt to feed different queries

Started by smtest, 07 Feb 2008 09:01:11 AM

Previous topic - Next topic

smtest

hi,
I have a tree prompt(?TREE?) that is based on date column X. But i want to filter three other queries that are based on date column Y, Z, M through this date column X. Somehow it is not filtering the data correctly.
I am using this filter
[Heirachy].[Date].[Y]=?TREE? in one query
[Heirachy].[Date].[Z]=?TREE? in second query
[Heirachy].[Date].[M]=?TREE? in third query

i am also using:
[Heirachy].[Date].[Y]->?TREE?
[Heirachy].[Date].[Z]->?TREE?
[Heirachy].[Date].[M]->?TREE?

as column definitions
pls advice