New to Hierarchy use in Bex

[Former Member]

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

[brian_keenan · Accepted solution]

You can alsojust create a new hierarchy that has the node that you need

[former_member202684]

You can restrict nodes in the filters tab. And select only the ones you require.

[Former Member]

Hi,

If you restrict with node 11 , Node 1 will not appear only the data from leaves or nodes under node 11 will appear.

Regards,

Amit

[Former Member]

Thanks Amit,

Please share anyone else if there is any possibility to hide nodes underneath.

Also if there is any possibility to have selective nodes only...

[Former Member]

Hi,

You can use authorization variable to hide the unwanted nodes.

Regards,

Durgesh.

[Former Member]

Hi,

You can use variables for your scenario which you can create in Query Designer.

But if you select ROOT node then all the data from other nodes will also be available.

Regards,

Amit

[Former Member]

Thanks Amit. Does That mean if I filter Just NODE-11, then all the nodes under this will also be displayed?

Also If I restrict on Node-11, will node-1 also appear?

Thanks,

-Su