SAP Knowledge Base Article - Public

2689866 - Competitor Product Shows # or X When Displayed in Reporting

Symptom

The Competitor Product shows # or X when displayed in report or previewed in database.

Environment

SAP Cloud for Customer

Reproducing the Issue

  1. Go to the Business Analytics work center.
  2. Go to the Design Reports view.
  3. Run the report Opportunity Analysis.
  4. Go to the available fields.
  5. Add the Competitor Product field to the selection.
  6. Click Apply.
  7. You notice that the Competitor Product is returning a # value.

Cause

The reason you are seeing this is the field Product is of type indicator, meaning it is a YES/NO question.

YES = X, NO = #

However, this is not to be confused with the # symbol for other reports as this usually means there is no data, you need access or incorrect modelling of the data source / report.

Resolution

Make sure to have your Competitor Products listed under the Competitor Products work center, otherwise the result will always be #.

Keywords

Competitor Product, #, report, data source, PRODUCT, Product Master Data , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Problem

Product

SAP Cloud for Customer all versions