1927171 - Web Intelligence document containing nested variables do not open in BI 4.0 SP05 and above

• When a specific webi report is opened with saved data the Webi Processing Server will process the report at full CPU indefinitely. This will occur beginning in BI 4.0 SP05 and is irreproducible up to SP08. Prior to 4.0 SP05 i.e. (SP04 Patch 16) it will open in just a few seconds with data.

• The report does have filter variables which include merged dimensions. This seems to be at the root of the issue. If the variables are not used the report will open.

•   =If(Length(UserResponse("store_id"))>0;If(Not(Pos(UserResponse("store_id");";") = 0);Substr(UserResponse("store_id");1;Pos(UserResponse("store_id");";")-1);UserResponse("store_id")))

• Filter1: =If(ToNumber([store01])=[Query 1].[Store ID];1;0)

• SAP BusinessObjects Business Intelligence platform 4.0

webi, variable, nested, 4.0,sp6, open WebIntelligence Web Intelligence 100% full all CPU timeout ADAPT01711687 ADAPT1711687 ADAPT 01711687 1711687 5000529735 Log Errors:

• **ERROR:C3_xmlParserBase:line 2, column 0 : Unexpected element ATTRIBUTE [kc3xmlParserBase.cpp;172]
• **ERROR:C3_CDBCL_XMLTOOLS:[Error] Parse ctStreamIn : BOException caught : Generic application exception [kc3xmlTools.cpp;231]
• C3_PROPERTIES:ReadPropertiesClass: 0
  Error=[Error] Parse ctStreamIn : BOException caught : Generic application exception