Prompt from 2 different levels

[MikeG]

Is it possible to create a prompt with selections from 2 different levels ie

Level numbers
1
2
3
4

Level characters

A
B
C
D

Value prompt has selection 1, 2 , C, D

[CognosPaul]

I'm a bit confused on what you need.

First, is this dimensional data? Are the levels coming from the same hierarchy? If so, try doing union([Level1],[Level2]) as the source of the prompt.

If that's not what you need, can you give a better example?

[MikeG]

Hi,

thanks for help, yes this is dimensional data and yes these levels are within the same hierarchy

I will try your suggestion

[MikeG]

Hi,

Bit stuck,  I create a data item as Union( Level A, Level B) but how do I get my prompt to use this as a source ?

thanks
Mike

[CognosPaul]

In the properties of the prompt you have the query and the use value. Simply set those.

Also, union will put one level directly below the other:
2010
2011
2010 Q1
2010 Q2
2010 Q3
2010 Q4
2011 Q1
2011 Q2
2011 Q3
2011 Q4

If you want the members to appear in their hierarchical order, you can do: descendants([Level 1],1, self beforewithmember)
2010
2010 Q1
2010 Q2
2010 Q3
2010 Q4
2011
2011 Q1
2011 Q2
2011 Q3
2011 Q4

[MikeG]

Hey it works,

Thanks CognosPaul