SAP Knowledge Base Article - Preview

2262775 - Crystal Reports database error when hierarchy node is set as prompt value

Symptom

  • Hierarchy node is added manually as prompt value like: [Dimension             HierarchyName].[NodeName           0HIER_NODE]
  • Report shows "Failed to retrieve data from the database." or "BAPI Error #:0 0HIER_NODE is not a valid characteristic for InfoProvider <InfoProviderName>" error when refreshed.
  • With another node the report might work properly


Read more...

Environment

  • SAP Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016

Keywords

mdx, prompt, hierarchy, node, value, dimension, length, position, CR, sap, BW, menu, integration, kit , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

About this page

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

Search for additional results

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