SAL Fiori query runner

How to generate reports at the touch of a button with the BW Query Runner

Author: Andrei Ghiura, SAP Consultant, Cross Technology Team

In this blog post, we will talk about the third and at the moment, the final SAP Fiori application in our Inspiricon Toolbox: the BW Query Runner. It is an application that allows the user to run a certain list of queries defined in BEx Query Designer. It mimics the functionality of the standard analyser add-in from Microsoft Excel but with a mobile approach.

You can read more about our other two apps – Manage Users and Time Tracker – in our blog.

The motivation

First of all, we have encountered an issue with viewing BI data on the go. This does not apply to big sets of data, reporting or any other comprehensive BI processes. The BW Query Runner is designed to suit user who need access to data in an intuitive format, in a mobile environment and with minimum effort.

The target

With this Fiori app we hope to mainly touch the group of people that want to have access to business data for their company while having the freedom they need in order to operate.

The solution

Our Inspiricon Toolbox component, the BW Query Runner, is a solution we have come up with as a kind of “Swiss army knife” for our target users. Instead of designing an application for each of their needs, we wanted to offer them a taste of what this new technology can do – so we have created this new Fiori application. After a couple of custom tailored apps for certain needs that were described in this blog beforehand, we settled on an application that was able to substitute, in part, all of them.

The technical side

First of all, we made use of the SAP Gateway component in order to transform the BI queries into consumable OData services that were going to be used in the BW Query Runner. This allowed us to create a seamless experience for any technical support that wanted to maintain our toolbox. Adding a new query to the list available in the application can be done in a few clicks (see FIG.1).

FIG.1: Adding a new query

FIG.1: Adding a new query

The functional side

Our application has a suite of functions that are readily available to the end user to demonstrate the capabilities of the new technology as well as the Inspiricon experience in BI. Among these, we can recall as major ones:

  • Easy access to a list of predefined queries tailored to each user’s preferences and needs (FIG.2 AND FIG.3).
    FIG.2: Predefined queries

    FIG.2: Predefined queries

    FIG.3: Predefined queries

    FIG.3: Predefined queries

  • Custom selections in each query for always having the optimal experience for the best performance (FIG.4 and FIG.5).
    FIG.4: Custom selections

    FIG.4: Custom selections

    FIG.5: Custom selections

    FIG.5: Custom selections

  • Custom filters for fast viewing of the data you require (FIG.6).

    FIG.6: Custom filters

    FIG.6: Custom filters

This was a short introduction to our third addition in the Inspiricon Toolbox, the BW Query Runner.

You want to find out more? Please contact us directly or go to our website: http://en.inspiricon.de/sap-fiori/. You can also find a lot of information in our flyer on the Toolbox. We hope that you enjoyed it and will come back to find out more about our next application :)!

 

Author
Andrei Ghiura SAP Consultant, Cross Technology Team
Phone: +49 (0) 7031 714 660 0
Email: cluj@inspiricon.de