All values in hierarchy

[Former Member]

my hierarchy is like this:

1. product1

1.1 state 1

1.2 state 2

1.n state n

2. product 2

2.1 state 1

2.2 state 2

2.n state n

But in my report i wanna display only some states...not all states, like:

1. Product 1

1.1 State 5

2. Product 2

2.1 State 2

2.2 State 8

how to do this manipulation in BEx?

[Former Member]

Hello,

Create hierarchy variable and restrict the needed nodes in the query variable screen.

Let me know if you have any queries.

Thanks

Viswa

[Former Member]

The only way to do this is to manual restrict them..

create a new selection...and under that create a selection with header state 5 and restrict this selection to that particular state manually....

assign points if it helps