SAP HR - Human Resources Qlik Sense Starter Template

    QlikView had a suite of templates designed to help an organisation with SAP get a quick view of their data in Qlik. These templates were starters to get a feel for how a solution would work in Qlik and offer some ideas for how the front end of the application could look and be used.

     

    This Human Resources template takes the data in a full load through a QVD process application [SAP HR QVD Generator] (attached). This has been split from the front end application as it is best practice to do so as you move into full production applications that will require incremental loading of large fact tables. Please note, this example is not incrementally loading as the test instance of SAP I have access to does not allow me to really test this functionality but it would be straightforward to implement based on Posting Date.

     

    Main measures:

    • Active Employee Count
    • Hired
    • Terminated
    • Avg Salary/pay
    • Absence Days


    Main Dimensions:

    • Employee Age and Groupings
    • Employee Length of Service
    • Organisational Hierarchy
    • Job Descriptions
    • Gender
    • Nationality
    • Absence Reasons


    Example GIF screenshots of dashboard provided for information, you'll note the instance I have access to has very limited and old data.


    SAP HR 800px.gif




    Instructions to implement:

    • You will need Qlik Sense and the Qlik SAP Connector installed
    • You will require an extension to be installed for this application
    • Import the two applications attached
    • Open and edit the [SAP HR QVD Generator] application:
      • Edit the data connections in the [SAP HR QVD Generator] application
        • Edit the 'SAP SQL Connector' connection to point to your SAP database instance with your credentials.
        • Edit the 'SAP Data' connection to point to the folder in which you will store the QVD (staging data files) files.
      • Reload the [SAP HR QVD Generator] application which will generate QVD files in the [SAP Data] connection folder.
    • Open and edit the [SAP HR Dashboard] application
      • Edit the 'SAP Data' connection to point to the folder in which you will store the QVD (staging data files) files as per the [SAP HR QVD Generator] application.
      • Reload the [SAP HR Dashboard] application.

     

     

    Disclaimer:

    Please note this application is provided as an example and as a support tool for you to implement an application quickly against a SAP instance. Each implementation of SAP, and each SI who implements it, has it's or their own customizations which are difficult to address in a common template. This application uses core SAP tables so should be very close to ready when loaded with your data but you may find that certain fields are not used and some changes are required to see the application as you would wish. As such this application is provided without warranty.