Skip to Content
0
Former Member
Jun 06, 2011 at 06:15 AM

BW Hierarchy behaviour for BO WebI reports

73 Views

All,

We do have 10 levels of Org Unit Hierarchy in BW, which has created objects in Universe from L00 to L09 and WebI reports are working fine.

All our WebI production reports run based on Key date selection. Couple of days back all 10the level data is removed and moved to other levels in the hierarchy and this is posted as of 01/01/2011. That means for 2011 there is no data for the 10th level in the hierarchy.

Many of out production web i reports use L09 objects in the reporting and this was throwing error in all the reports as below:

"A database error occured, The database error text is: The supplied XML is not valid. [0ORGUNIT ORGEH000].[LEVEL09]. (WIS 10901)

If Webi Report has key date selection on or before 12/31/2010, report works fine. Report fails for key date selection on or after 01/01/2011.

Do any one faced this issue?

We are in BO 3.2.

Thanks

Jai