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

• 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

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

1. Create a BEX query with a hierarchy in BW
2. Create a Crystal report against the query
3. Create a prompt for the hierarchy
4. Put a hierarchy node MDX statement into the prompt
5. Run the report and observe the error

• You've used wrong number of placeholder characters (spaces) in the MDX statement

• Using MDX syntax in prompt value is not recommended since it can cause other errors as well.
• If you still want to use it, the hierarchy name has to start precisely on the 31st position, like:
  
• You can copy and rewrite the below sample. (use "insert" in your keyboard to maintain correct positions)
  [Dim                           HierarchyName].[NodeName                        0HIER_NODE]

• MDX syntax and concepts

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

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