Explore and Export Data

With the Explore and Export Datafeature, you can quickly focus on the most relevant data across learners, activities, or certificates, by configuring views and filters, and efficiently export exactly what you need for your records or analysis.
At the top left of the interface, use the dropdown list to choose the data view relevant to your needs.

Available views include:

• Learners:
  a detailed list of learners with a SAP Learning Hub license and administrative users that hold “License Manager” or “Learning Analyst” role. Find out more in the dedicated sections How to find the list of learners with an SAP Learning Hub license? and  How to identify users who have “License Manager” and/or “Learning Analyst” roles assigned?
• Learning Journeys:
  a list of learners with learning journey activities per date.
• Courses:
  a list of learners with course activities per date.
• Practice Systems:
  a list of learners who used practice systems per date.
• Live Sessions:
  a list of learners who attended live sessions per date.
• Certifications:
  a detailed list of learners with SAP certificates and exam/Stay Certified assessment results.
• Records of Achievement:
  a detailed list of learners who achieved a knowledge badge per date.
• All Learning Activities:
  a list of learners with any learning activity per date.

Each view brings up a dedicated data table, presenting information tailored to the selected aspect.

After selecting a view, you can further refine the displayed information. Default filters (such as Activity Date Range, Certification Exam Result, Certification Status, and more) let you focus on specific data. To add more filters or adjust existing ones, use the Filter line on the top.

You can tailor the data table to display exactly the information you need by using the Configure Table panel. Click the Configure Table button in the top right corner of the interface to open the configuration panel.

With the Configure Table panel you can:

1. Add or remove columns:
   • Add Dimensions:
     Check the boxes next to the data fields (dimensions) you wish to display in your table, such as Country / Region, Edition Start Date, Learner Email, etc.
   • Add Measures:
     Under the Add Measures section, select relevant measures, such as Learners
2. Control Selection:
   • Use Select All, Clear All or Reset at the top for quick selection management.

   • When you select a dimension or measure, it is added to the table in the order you check them. The sequence of your selections determines the order of columns in your resulting table. To change the column order, simply uncheck and reselect fields in your preferred order.

3. Apply Your Choices:
   Press the Apply button to update the table view, reflecting your dimensions and measures selection.

When you are ready to extract your data:

• Click the Export Current View button at the upper right. This will download all rows and columns that match your filter selection, not just what is visible on your screen.
• The export provides the dataset with the visible selection for dimensions and measures in a csv file format.

For quick access to commonly needed datasets, predefined exports are available in the Certifications view. These use preset filters and column structure, regardless of the filters you have applied on the table:

• Learners without UID Export:
  Displays learners with a Certification Exam Result of “Passed” and Compliant UID= “No”. Use this to identify individuals who still need to complete UID registration.
• Valid Certificates Export:
  Shows only active certificates, filtered by Certification Exam Result= “Passed”, Certificate Status= “Active”, and excludes “Deleted” S-user accounts. Use this export to top-line valid certification records.

You can save personalized views in the Explore and Export Data section, making it easy to quickly return to pre-filtered or customized states without having to re-apply all the settings. This streamlines the reporting process and improves efficiency.

What is saved:

• Filter states:
  All applied filter values.
• Table structure:
  The current drill-down levels in tables, along with any sorting, ranking, and visibility settings for columns and rows.

How to use bookmarks:

• To create: Navigate to Tools > Bookmarks > Bookmark Current State
• To open: Navigate to Tools > Bookmarks > Open Saved Bookmarks and select your saved view.
• Set as default: Set one of your private bookmarks to open automatically each time you open the Explore and Export Data section, giving you immediate access to your most-used view.

For detailed information on standard SAP Analytics Cloud bookmarks feature, please refer to the official SAP Analytics Cloud documentation on creating and using bookmarks.

For step-by-step tutorials on specific reporting tasks, visit the Understanding learning activities and certifications data articles.