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
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?
Hi,
thanks for help, yes this is dimensional data and yes these levels are within the same hierarchy
I will try your suggestion
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
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
Hey it works,
Thanks CognosPaul