BEx / WEBI hierarchy node variable

We have created WEBI reports on a BOBJ Universe built on a BW BEx query.

Our reporting requirement requires us to refer to two different hierarchy nodes.

To start with we created ONE BEx hierarchy node variable. However they do not translate well into WEBI.

When we run the report with hierarchy node variable we get an error / when we refresh the Variable screen for Hierarchy node variables we get the below error:

u201CA database error occurred: The database error text is: The supplied XML is not valid. [D8QQL668NXAWBXU79BQWOCJD6]. (WIS 10901)u201D

Can anyone tell us a workaround / Solution ?....<<text removed>>

We have tried:

1) include hierarchy node info-object in Free characteristics of BEx query...still same error

2) make hierarchy node variable point to an actual hierarchy variable instead of an hierarchy...still same error

Current BOBJ environment :

Development Envt :BO XI 3.1 SP2 fixpack 6 (ERROR generated)

Production : BO XI 3.1 SP2 fixpack 4

Edited by: Matt on Sep 20, 2011 1:15 PM