on 04-16-2014 8:34 AM
Hi,
I have the following hierarchy
Level | InfoObject | Key/Text |
---|---|---|
1 | 0HIER_NODE | All Products |
2 | 0HIER_NODE | Group A |
3 | 0MATERIAL | Group A-Product 1 |
2 | 0HIER_NODE | Group B |
3 | 0MATERIAL | Group B-Product 1 |
So now in Bex, I get:
All Products
|-> Group A
| |-> Group A-Product 1
|-> Group B
|-> Group B-Product 1
Then,
Level | InfoObject | Key/Text |
---|---|---|
1 | 0HIER_NODE | All Products |
2 | 0HIER_NODE | Group A |
3 | 0MATERIAL | Group A-Product 1 |
2 | 0HIER_NODE | Group B |
Over time, Group B-Product 1 was removed from Hierarchy.
I would like Bex to display Group B although Group B-Product 1 was already removed, like this:
All Products
|-> Group A
| |-> Group A-Product 1
|-> Group B
But instead, I'm getting this since there is nothing under Group B:
All Products
|-> Group A
| |-> Group A-Product 1
Appreciate any inputs at all.
Thanks.
Couldn't find a way for it to work in BEx.
But in Business Objects via BICS, member selector allows filtering out leaf nodes while still displaying its parent node.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
It's been a while, but I don't seem to be able to edit orignal post anymore.
Additional information:
BEx query is built on top of master bearing InfoObject, not transactional infoprovider like Infocube.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello TJ,
The behavior of the hierarchy which you have mentioned is correct.
It happens because there is no transaction data for the second group B. And the system is just not able to display the node text itself.
However what you can do is look at the following option in BEx . With this option it will display the complete hierarchy if even the underlying info provider does not have a transaction data .
I am not sure if this is the complete solution but atleast it brings the rest of the nodes of the hierarchy .
Check the below screenshot and the highlighted portion :
Regards,
Ashutosh Singh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Node without child nodes/leaves is as good as nothing. That's why report is ignoring that empty node.
You can try to select through Ctrl while restricting your Hierarchy in Single values in Filter.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi TJ,
How about create a historical hierarchy with the layout that you need and make a variable for selection and let the user to select whenever he needs?
I hope it helps!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.