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