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
- Go to Business Analytics work center.
- Go to Design Reports view.
- Click on New -> Report.
- Insert the name and on Data Source insert Unassigned Expenses (Technical ID:ODTUNASSIGNEDEXPENSESU01).
- Click on Finish.
- Open your newly created report and click on Go.
You will notice that the report displays a sum of the Expenses Amount key figure.
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.
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.
KBA , SRD-CC , Cross Components , How To