7 Replies Latest reply: Mar 6, 2012 6:49 PM by Brian Keenan RSS

New to Hierarchy use in Bex

S Kaur
Currently Being Moderated

Hi,

I am new to using hierarchy in BEX query.

I have built a hierarchy in BW7.0 where under the First Node, we have 3 nodes and then each of these 3 nodes, we have 4 nodes under like shown below;

 

Node1---

   -


Node11

                      |----


Node111

                      |----


Node112     

                      |----


Node113

                      |----


Node114

            

    -


Node12

                      |----


Node121

                      |----


Node122

                      |----


Node123

                      |----


Node124

   

     -


Node13

                      |----


Node131

                      |----


Node132

                      |----


Node133

                      |----


Node134

 

My Client is intested to see KFs only for selected nodes which are Node1, Node11, Node114, Node13, Node133.

He is not interested in data of other nodes.  Is this possible to present the data in Bex query for Selected Nodes?

 

Also will this data for selected nodes be presented in hierarchical way?

 

thanks,

Su

 

Edited by: SuKaur on Feb 29, 2012 7:27 AM

 

Edited by: SuKaur on Feb 29, 2012 7:29 AM

Actions