Query Manager Analytics Connector for Power BI (QM 209)

Level: Intermediate | Course duration: 1h

Labs_Coloured_blocks

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

Play video

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.

Portrait Certificate_Query Manager_2021

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:

{{item.title}}

Query Manager 4: Payroll-specific reporting for Build 498+ (QM202_498+)

Taking your Payroll reporting knowledge and skills to the next level.

View course

Labs_Coloured_blocks

Recent client FAQs

1. Choosing a course

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.

2. Accessing a course

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.

3. General

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: