You have defined your own report on the CRMSLOIB data source to show all Sales Orders. But the report does not show all Sales Orders.
Reproducing the Issue
- Go to the Business Analytics work center.
- Select the Design Reports view.
- Select the New->Report button.
- Use the report wizard to define your own report on the data source CRMSLOIB.
- Execute the report to view all Sales Orders.
You are not able to see all Sales orders which are visible in the Sales Orders view of Sales Orders work center.
Data Source CRMSLOIB includes only Released and Consistent Sales Orders. Implies data source does not includes document which has status Not Released. The reason is as follows:
The documents in status Not Released have the semantical meaning of draft or preliminary versions. Therefore, these are not intended to appear in the report which show aggregated information on Sales Orders. The same applies for documents in status "inconsistent". Since these could contain misleading or even wrong data. In order to avoid these effects, a central filter was implemented which only passes Released and Consistent documents. This central filter applies for the entire data source Sales Order Items (CRMSLOIB). Therefore, all reports which are built on the data source CRMSLOIB show only Released and Consistent Sales Orders.
KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To