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
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
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
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
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...
Hi,
You can use authorization variable to hide the unwanted nodes.
Regards,
Durgesh.
You can restrict nodes in the filters tab. And select only the ones you require.
You can alsojust create a new hierarchy that has the node that you need