SAP Knowledge Base Article - Public

1969893 - Data Source Unassigned Expenses shows the sum of Expense Amounts

Symptom

When you create a report on top of this Data Source, you realize that the report is displaying the sum of Expenses Amount key figure.

Reproducing the Issue

  1. Go to Business Analytics work center.
  2. Go to Design Reports view.
  3. Click on New -> Report.
  4. Insert the name and on Data Source insert Unassigned Expenses (Technical ID:ODTUNASSIGNEDEXPENSESU01).
  5. Click on Finish.
  6. Open your newly created report and click on Go.

You will notice that the report displays a sum of the Expenses Amount key figure.

Cause

The reason for such behavior is due to the fact that the Data Source has been created on a Supplier level, which means that if you do not use Supplier characteristic at either Rows or Columns, then the report will display the sum of Key Figure Expense Amount.

Resolution

To resolve this case, you need to drag characteristic Supplier from Not Currently Shown into either Rows or Columns.

This will then make the report run on its basic level and return the correct amount of Expense Amounts.

Keywords

KBA , SRD-CC , Cross Components , How To

Product

SAP Cloud for Travel and Expense 1308 ; SAP Cloud for Travel and Expense 1311