Creating Analytical Reports on Guided Sourcing Projects

1. Project Date Fields:
   1. The project Start Date field for in reports is always the date at which the project was created. This date will never change after the project has been created.
   2. The project Due Date field in reports only shows data when the project has at least one milestone task, which includes due dates and committed due dates. This date will always be the latest due date of all of the tasks in the project. If a user adds a new task with a later due date in the source project, reports will then show the later due date.
   3. The project End Date field in reports only shows data when the project has been marked completed, and then defaults to the date at which the last task in the project was marked completed. The date will not change when new tasks are added to the project; however, if a user edits the End Date field in a project, reports will then show the edited end date.
2. Event State and Status:

   State is a sub-category of Status, and when event data is pulled into reports, the Status field in the report displays data that appears in the State field of the event itself. Therefore, a search for events by Status might show different results than a report that is filtered on Status. For example, Event A can have a State of Paused and a Status of Open. If you search for events with a Status of Open, you will see Event A in the search results. However, you will not see Event A in a report that is filtered on Status of Open; you will see it in a report that is filtered on Status of Paused.

3. The Event Awarded Amount measure in sourcing event reports is only populated if either the event is a total cost auction or it has an Extended Price term. For events that don’t meet either of these conditions, Awarded Amount is always 0 in reports.
4. Commodities in Event Participation Reports: Event counts in event participation reports are based on counts for participation for each commodity category. Therefore, the number displayed in the Event Count field might not match the number of total events listed in the detail view of the report. It will match the total event commodity categories.

1. Document: The Document fact contains data from documents in SAP Ariba strategic sourcing solutions documents such as savings forms, contract documents, events, and surveys. The data is at the header level and includes name, created date, status, and type. It can help monitor project activity and can be combined with various project data, such as Project Task, to help track pending or overdue approvals and other tasks by department, supplier, user, commodity, region, or other criteria.
2. Event Item Summary: The Event Item Summary fact contains data from individual event lots. It can report on many data fields related to line item and lot attributes and activities. Various spends, quantities, savings, counts, months, percentages, bid details, and spend information can be captured.
3. Event Level Summary: The Event Level Summary fact contains header-level data from events.
4. Event Participation: The Event Participation fact contains participation data from individual events.
5. Project: The Project fact contains data on all of the available project types in your solution.
6. Sourcing Project: The Sourcing Project fact contains data from individual sourcing projects.
7. Sourcing Request: The Sourcing Request fact contains data from individual sourcing requests created in your site or in integrated third-party ERP systems.
8. Supplier/Customer: The Supplier/Customer fact contains data for all supplier and customer organizations in your site.
9. Supplier Participation: The Supplier Participation fact contains supplier data from individual lots in sourcing events.
10. User Ability: The User Ability (Project Creation) fact contains data about which users in your site can create different types of SAP Ariba Spend Management projects. User counts can be measured on the report that captures project creation abilities and other hierarchies.

Event Item Summary, Event Level Summary, Event Participation, Project, Sourcing Project, Sourcing Request, and Supplier Participation data are subject to reporting data access control. If your organization uses reporting data access control, Full Reporting Access Authorized group members can see all task approval data regardless of project team membership. Users who are not in the Full Reporting Access Authorized group can only see task approval data in reports related to the projects to which they have access based on project team membership.

If your organization does not use reporting data access control, all users can see all project data regardless of project membership.