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. | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

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.

Symptom

  • 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.

Read more...

Environment

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

Product

SAP BusinessObjects Business Intelligence platform 4.2

Keywords

#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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.