Hierarchies from BEx in Webi report

[Former Member]

Hello,

I'm using SAP BO 4.1 I SP5 and Business Explorer Query Designer 7.3 SP9 and I've created one query that has a hierarchy that I want to display also in a Webi report but for some reason I'm not able to display all the nodes or levels of the hierarchy.

The first level is fine, I get the + (plus sign) to show the next level but I have a row that says Not assigned values and I don't see the same sign to show the values of that level.

This is how I want to see the hierarchy and levels...

Plant
	100	A
	200	B
	300	C
Not assigned
	#	#
	999	999

Plant and Not Assigned are Level 1 and Level 2 are the 100/200...etc values.

For some reason I'm not able to see the values of the Not assigned just the ones below Plant.

I defined the number of levels to expand in the BEx query and also in BOBJ but still it doesn't work.

Any suggestions?!

Thanks in advance for all your help.

[former_member198519]

See if this helps you:

[Former Member]

Are you getting the hierarchy properly on the BW side when you run the same query?

Regards

Niraj

[Former Member]

Yes, in BW it works fine, the issue is just in BOBJ.

[amitrathi239]

are you able to see the not assigned as a level value in the webi query hierachy object?

[Former Member]

Hi Amit, yes, I'm able to see the level but not the # or 999 values.