We are on BI 7.0 Ehp1 and BOBJ ENTERPRISE XI 3.1.
We have a Bex query with Hierarchy and Hierarchy node variable.
In the Webi Query LOV only the Hierachies show up but not the values for nodes.
Since these are not mandatory vairables the WeBI query runs fine and fetches the required data.
The variables are in the Filter section of the Bex query and the refrence characteristic on which the hierarchy variable is based is NOT in the free characteristic and the rows.
There are 5 hierachies in BI with about 5300 nodes.
Any help or leads will be highly appreciated!
Edited by: Satyen Popat on Feb 5, 2010 12:30 AM