Query Manager Analytics Connector for Power BI (QM 209)
Level: Intermediate | Course duration: 1h
With Query Manager’s powerful reporting capabilities, it is easy to report SAP HCM, Payroll and SuccessFactors data. The Query Manager Analytics Connector allows you to enable these Query results for reporting in third-party applications such as Power BI. This is done using a Fiori application and an Open Data Protocol (OData) service.
Become empowered and add value
Course objectives:
Enable your Query results as an additional data source to be used in Power BI or other third-party visualisation software.
You’ll learn how to enable the OData API service in your Queries, as well as how to create the OData API field mappings.
Also, discover how to integrate the generated OData interface link in Power BI for optimal reporting. Lastly, learn how to incorporate any field changes made to an OData-enabled Query, to prevent inconsistent reporting of missing data.
Introduction
Module 1
Enabling the OData API to access the Query run results
Module 2
Consuming and publishing the SAP Query results in Power Bi
Course assessment
Module 4
Refreshing Analytics Connector Metadata
Module 3
Accommodating modifications to OData-Enabled Queries
At a glance
Prerequisites: Query Manager 4: Fundamentals and basic Query design for Build 498+ (QM 101_498+)
Cost: Free of charge to EPI-USE Labs clients with an active product-associated license.
Audience:
Customers
Partners
New employees/onboarding
About the certificate
Get to know the Query Manager Analytics Connector, and earn an official certificate of completion from EPI-USE Labs.
Stand out from the crowd in skill and competence with a certificate of completion from this training course.

Recommended courses
If you are interested in the Query Manager 4: Payroll-specific reporting for Build 498+ (QM202_498+) course, you may also be interested in the following:
Recent client FAQs
Can anyone do the course?
Yes, if your company has purchased the related EPI-USE Labs product. Our courses are aimed at increasing your understanding of the product and enabling you to use it more efficiently. So you need access to the product for the course to be useful to you.
Where do I find out more about a specific course?
Select the 'View course' button to view the detailed information about the course duration, prerequisites and course outcomes.
How do I get access to a course?
When you select the 'Enroll now' option for a course you will be prompted to sign into Client Central. Enter your login details if you are an existing user, or register as a new user. Once you have access to Client Central, you can self-enroll in the course.
Do I need any specific software?
No, all you need is an internet connection and a browser. We recommend using Chrome for the best experience.
Which browser should I use for these online courses?
Although the courses should work on most browsers, we recommend using Chrome.
On which devices can I view these courses?
You can view your courses on any laptop, PC, tablet or mobile device.
How long will I have access to the courses?
The course will be available for a default duration of 1 year, but an extension can be arranged with an EPI-USE Labs representative.
What if I'm interested, but have more questions?
Contact us on the form below.
Get in touch
Need more information? Click here and fill out the form: