Skip to Content
0
Apr 28, 2014 at 10:41 AM

Restrict only 1st level node in hierarchy in bex to display ?

468 Views

We have the hierarchy structure as below.

N1

N2

N14

N15

N16

N3

N4

N17

N5

N6

N7

N8

N9

N10

N11

N12

N13

So basically I want to show only the N1 and N2 values in hierarchy. It should not show anything other than the 1st level node values. For example, we should see only N1, N2, N3,N4, N5, N6, N7,N8 and N11 and N12.

basically all the 1st level nodes in all parent node's. It should not show anyother node other than 1st level node in all the parent's. Can we do it ? We just have this MD and amount value in the query. Nothing else in the bex query. These values are existing in the infocube.

Thanks

DR