 |
| ||||||||
- How do I create an Analytical report?
- How do I run an Analytical report?
To run a report:
- Log in to the Ariba application and click on Create > Analytical Report
- Complete all required fields in the Source Data, Pivot Layout and Refined Data
- Additional information on required fields listed below
- After designing and refining, click Run Report. The report displays in the User Interface (UI)
Source Data page field details:
• Title – Include the title for the report.
• Description – Add a description about the report.
• Reporting Currency – By default, the currency set on the user profile (User Preferences), though the user can select other currencies based on necessity.
• Main Fact – Select the fact on which to run the report, for example, Sourcing Project, Contract Workspace, Requisition, Purchase Order, etc.
• Second and Third Fact – Used for Multi-Fact Reporting.
• Should add a measure field under Data Field section to continue.
Pivot Layout page field details:
- Available Hierarchies – Lists the hierarchies available for the fact on the report. Click Available Hierarchies to see the option Available Fields.
- Available Fields – Lists all the fields that are available for the selected fact.
- Page Field – Used as a filter in the Refine data page to refine the report based on some selection criteria.
- Row Field – Appears in a row down the left of the report table.
- Column Fields – Becomes the column heading of the report.
- Detail Fields – Displays the details (value) of the field, displays as row and column in the Detail View by default.
- Show Detail fields in Report – Check the fields to appear in the report.
- Row and Column fields are not mandatory. Keeping Row or Column fields makes the report more flexible.
- Each fact has a default set of detail fields.
Refine Data page field details:
- Relative date range – Select the time period. Specify the months, quarters or years.
- Fixed date range – Using calendar can select the specific from and to dates.
- Show Report Query – Displays the query which is being run the pull the report which is nothing but a SQL query.
- Run Report – Clicking on that option the report will be generated and displayed on the screen.
- Customize this Form – Used to add the Detail Fields as Page field. Clicking on this link, you will be taken to the below page:
- Click Show option for any field and click Done to see that field see Project Name as Page Field where we can filter the report value before running.
- Click the drop-down > Select Others where to see all of the options/values available for that field in reporting.
- Using a page field we can easily confirm whether the record is pulled into reporting or not.
- Search for the value that you would like to see and select the Include option to include that in the report.
Report Details:
- Detail view – By default, the report has Detail view, but the user can switch to Aggregate view by clicking the Detail view/Aggregate view option.
- Edit – Edit the report and modify it.
- Save – Save the report in Personal Workspace or Public Folders.
- Export – Export the report into Microsoft® Excel.
- Actions – Can configure the export in the other Excel® templates and comma-separated value (CSV) format.
Report Tabs:
• Pivot Table – Shows the results of the report in the UI with the data. The user can filter the results by clicking the field name and using the Select Others option if needed.
• Chart – Displays the results of the report in the form of charts (Bar, Pie, Line, Column, Area or Radar etc.).
• Dashboard – Pivot table in the form of compact table, that the user can add to their dashboard.
For further information how to create and run reports, see Creating Analytical Reports. You can find the list of all available reporting fact tables in SAP Ariba Reporting Fact Reference documentation and Multi-Fact Reference documentation. Also, you can find the list of fields available for reporting in the SAP Ariba Reporting Field Dictionary documentation
Nevertheless, if you need support to create the reports based on your business needs, please contact our Best Practice Center team that creates reports for customers upon request since this is out of Analysis Support Team scope. If your company is interested, please contact your Customer Success Partner (CSP) to get them created for you.
If you do not know who your CSP is, please reach out to the Digital Engagement team in your region for assistance:
- SAP Digital Engagement North America Team - digital.engage.na@sap.com
- SAP Digital Engagement Europe, Middle East, and Africa Team - digital.engage.emea@sap.com
- SAP Digital Engagement Asia Pacific and Japan Team - digital.engage.apj@sap.com
- SAP Digital Engagement Middle and Eastern Europe Team - digital.engage.mee@sap.com
- SAP Digital Engagement Latin America Team - digital.engage.lac@sap.com
Catalog Management > Analysis Reporting for Catalogs
Catalog Management > Content Management System > CMS Reporting
Invoicing > Analysis Reporting for Invoicing
On-Premise > On-Premise - Ariba Analysis
Purchasing > Contract Compliance > Analysis Reporting for Contract Compliance
Purchasing > Purchase Orders > Analysis Reporting for Purchase Orders
Purchasing > Receiving > Analysis Reporting for Receiving
Purchasing > Requisitioning > Analysis Reporting for Requisitions
Purchasing > Services Procurement > Analysis Reporting for Services Procurement
SAP Ariba Analysis Reporting
Strategic Contracts > Analysis Reporting for Strategic Contracts
Strategic Sourcing > Analysis Reporting for Strategic Sourcing
Supplier Information & Performance Management > Analysis Reporting for SIPM
Supplier Lifecycle & Performance > Analysis Reporting for SLPM
Supplier Lifecycle & Performance > Supplier Management Reports
Supplier Risk > Analysis Reporting for Supplier Risk