2550462 - Webi: #ERROR shows for variables that point to a hierarchy level that is not returned in a refresh of a Webi document that is connected to a HANA view through a HANA direct OLAP connection.

• In BI4.2, a Webi report is connected directly to an OLAP HANA connection to a HANA view that has a hierarchy with levels.
• Variables are created that refer to the hierarchy levels.
• The report is refreshed so that data is retrieved that doesn't return data for all of the levels.
• The level objects that do not have data are not returned as available objects which results in the variables that point to those levels showing #ERROR in the report.

• SAP BusinessObjects Business Intelligence Platform BI4.2 (all support packs)
• Webi
• HANA

#ERROR, ERROR, Webi, Web Intelligence, WebIntelligence, Business Intelligence, BusinessIntelligence, formula, formulas, formulae, hierarchy, hierarchies, hierarchical, level, levels, prompt, ??, DP, HANA, member, members, available objects, BI, BI4.2, 4.2, BI42, 42 , KBA , BI-RA-WBI , Web Intelligence , Problem