Cognos Migration SAP BW on HANA

How to leverage a standardized SAP solution to harmonize processes across the enterprise and ensure comparability

Hey there:

Today we would like to share with you yet another successful project in our portfolio. For this project, we were tasked with migrating an existing Cognos reporting solution from SAP BW on HANA with SAP BusinessObjects as the frontend.

The customer that sought our support specializes in the manufacturing and distribution of electronic components. As part of an international group, it is one of several subsidiaries, all of which rely on different ERP and business intelligence solutions. Faced with the group’s continued growth and the ever-increasing complexity that goes along with it, the proprietary ERP solution was reaching its limits both in terms of functionality and reporting capabilities.

THE PROJECT

Working from a newly introduced and standardized SAP ERP solution with SAP BW, Inspiricon was able to replace the existing Cognos reporting solution.

There were a number of reasons that motivated this decision:

  • For one, it would have been too costly and time consuming to keep developing the reporting solutions that, for the most part, had been developed in house and customized to specific needs.
  • Also, maintenance and support had become almost unmanageable.
  • What’s more, the group was no longer able to maintain the consistency of KPI purpose and content across its different companies, resulting in the inability to compare their processes and results.
  • The sheer number of different interfaces with other systems drove costs and significantly increased the error rate. Reporting to the parent company, in particular, had become a tedious and time-consuming endeavor. Even more interfaces were needed to do so because reporting was tailored exclusively to customers based on a – custom – Cognos reporting solution that had been implemented on top of everything else.
  • Internal expertise regarding the existing solutions was limited to a small number of people inside the company. Loosing this technical knowledge due to employee turnover was an ever-present threat.

THE SOLUTION

Since another subsidiary was already using SAP products, the new ERP solution was already present on the system.

The project, however, was not just about bringing the ERP system up to speed, the group was also eager to take its BI system to the next level. And it wanted it to be a SAP solution, prompting the decision to replace the existing Cognos reporting solution with SAP Business Warehouse on HANA.

The project was launched with release SAP 7.4 on HANA. During the project, a migration to SAP 7.5 on HANA was carried out. In this case too, SAP BW was already being used by another subsidiary and was therefore readily available.

Products in the SAP BusinessObjects family were to be used for the frontend as well. These adjustments were intended to bring about following changes and benefits:

  • Standardized data models that can be leveraged by every company in the group, allowing its globally dispersed service centers to provide cost-optimized support.
  • Consistent KPIs that guarantee comparability.
  • A smooth transition for users of the Cognos solution by means of a like-to-like migration.
  • Elimination of unnecessary interfaces.
  • Improved and accelerated flow of information along the value chain.
  • Increased responsiveness for better corporate management, which also improves competitiveness.

Our solution consists of Web Intelligence reports based on SAP BW on HANA along with standardized data provisioning from the operational SAP ERP system. The following illustration outlines the project’s structure:

Illustration Project Structure

By replacing its existing ERP and BI systems, our customer was able to improve its business. Not only can users now access reports and data much faster, substantially reducing time to decision, but they can also, to a certain degree, customize their reports in the context of a self-service BI. Another big plus is a significantly improved security posture due to centrally managed access authorizations. Last but not least, we were able to reduce license costs and therefore improve cost-effectiveness for the customer.

The introduction and standardization of SAP ERP and BI solutions typically require significant investments. By having our employees from our nearshoring location in Cluj-Napoca in Romania contribute to the project, we were able to drastically cut these costs. At the peak of the project, up to 6 colleagues from Cluj-Napoca were involved in the project. We coordinated through daily briefings during which our team communicated remotely both through video and audio.

Author
Claudio Volk Member of the Management Board
Phone: +49 (0) 7031 714 660 0
Email: info@inspiricon.de
Big Data and Artificial Intelligence

Big data and artificial intelligence – a powerful duo that will shape our future

SAP makes artificial intelligence a reality

Using intelligent machines to analyze big data is no longer just wishful thinking. SAP has turned yesterday’s dreams into today’s reality. Based on SAP HANA, SAP has breathed life into multiple software components capable of thinking autonomously and analyzing vast amounts of data. As you are reading this, its software is recognizing faces and objects and carrying out large-scale analyses that would neither be possible nor conceivable if done manually.

With SAP, artificial intelligence (AI) has made the leap from vision to reality.

SAP Clea and SAP Leonardo: artificial intelligence is gaining momentum

SAP has added a new version to its HANA platform. Along with it, a number of AI and IoT (Internet of Things) services were introduced to the market.
SAP’s new SAP Clea software runs in the SAP cloud and is capable of autonomous learning without requiring any explicit programming. Its analytical intelligence is already being leveraged by companies like Munich Re and the European Space Agency. The insurance giant Munich Re is constantly calculating the risk associated with forest fires using data on vegetation lines. These calculations are supported by intelligent software and their capability for large-scale big data analytics.

SAP Leonardo is the name of SAP’s IoT solution portfolio. Just like its namesake Leonardo da Vinci, SAP Leonardo takes a broad and interdisciplinary approach – a fundamental requirement for the Internet of Things. Information from across the company is taken into consideration, paving the way for the development of novel solutions and business models.

SAP Leonardo is designed to assist potential customers in crafting an IoT strategy and in identifying the solutions that will best meet their specific needs.

Because one thing is for certain: There is no such thing as the one piece of software for IoT and AI. It usually takes a combination of multiple applications.

The digital core: The S/4HANA SAP Enterprise Suite

S/4HANA is already being leveraged by 4,000 companies in 25 countries. It forms the digital core for the transformation and can be used for IoT and AI/machine learning applications. SAP has introduced several additions in the cloud, such as Connected Logistics, Connected Vehicles, Connected Manufacturing, Connected Assets, Connected Retail, and Future Cities. These allow companies to, for example, manage their fleets, control quality levels, and calculate routes.

In the field of artificial intelligence and machine learning services, SAP offers a range of services on the SAP Cloud Platform:

  • Resume Matching to streamline recruiting
  • Cash Application to analyze payment behavior
  • Social Media Customer Service
  • Brand Intelligence
  • Fraud Detection for insurers and banks

SAP Fiori – the new SAP UI

SAP Fiori is an initiative that aims to enhance usability (for more information, please refer to our website and our blog). With Fiori 2.0, SAP wants to harmonize the user experience for all SAP applications and has included a number of improvements in its visual design and usability.

This is yet another area where AI is leveraged. The user is assisted by a co-pilot that anticipates user actions and prepares them accordingly. Its built-in voice control, for example, streamlines maintenance and warehouse workflows. Artificial intelligence is used to analyze suppliers and categorize them according to a predefined requirements profile.

Inspired: straightforward big data analytics

The combination of artificial intelligence and big data supported by SAP Fiori makes for more effective automation and analysis. The software tries to foresee what actions the user wants to take, enhancing effectiveness and boosting speed. SAP Fiori enables companies to conduct large-scale analyses of big data and to automatically monitor important business metrics. Anomalies, trends, and patterns are automatically communicated to the responsible staff in an interface that puts the user first. The available data is analyzed in a central user interface that allows for intuitive operation. There is no longer a need for complex modifications of input and output parameters.

Artificial intelligence ensures that the algorithms deliver meaningful results without requiring input from the business departments.

The main objective of machine learning is to identify data patterns and relationships and to apply them to new sets of data. The underlying algorithms are based on statistics, the calculation of probabilities, and algebra. With SAP Application Intelligence, data is the fuel that powers machine learning.

Deep learning: where machines outperform humans

One discipline of machine learning is known as deep learning: Here, neural networks are flooded with vast amounts of data. The intention is to enable the software to recognize faces, classify objects, and understand language. Capabilities that are constantly being refined and increasingly used in robotics applications.

This also opens up new medical applications:
Soon, the data of individual cancer patients will be compared to millions of medical records to enable the customization of healthcare through precision medicine. Artificial intelligence works for the broad mass and delivers very promising results. The software is increasingly becoming an all-rounder that can be leveraged across the board. SAP Application Intelligence is capable of unearthing relationships that would otherwise stay hidden from the human eye. Working under time constraints, human employees often overlook crucial data that then remains undiscovered in day-to-day business.

Conclusion

Artificial intelligence has already found its way into business intelligence solutions, where it is used to control data analytics, for example in order to detect anomalies or automatically structure and interpret data. On top of that, AI algorithms are also used to monitor data streams.

The intelligent and integrative interaction between new SAP components such as Clea, Leonardo, or Fiori on the basis of SAP HANA Cloud and on-premises solutions are continuously inspiring Inspiricon to search for innovative services for our customers.

You are curious to learn more and explore new potential business? Do not hesitate to contact us now!

Author
Claudio Volk Member of the Management Board
Phone: +49 (0) 7031 714 660 0
Email: info@inspiricon.de
Enhancements in ABAP

ABAP enhancements – this is what’s new in NetWeaver 7.40

Easier, more direct, more intuitive

Hello everybody:

Today, we are going to get very technical yet again by taking a closer look at what’s new in ABAP. It’s not just SAP’s applications and tools that are evolving. SAP has also never stopped working on its very own programming language.

Over the coming weeks and months, we will provide you with regular insights into the language, the new tools, testing capabilities, and most importantly the applications in the field of SAP BW and HANA.

Today, we will start with a number of enhancements that ABAP has seen over the past years. Because these changes depend on the system version you are working with, there is a chance that they may still be very new to some of you, while others have been familiar with them for years. And then there may be those of you who to whom they are not even available yet.

A look back at NetWeaver 7.40

The release of NetWeaver 7.40 brought with it some really interesting news and changes in ABAP that have real potential to impact a developer’s day-to-day work. SAP’s own Horst Keller has published an excellent article on this. You can find it here.

ABAP 7.40 has been around since 2013. Since then, we have seen a number of adjustments in the form of different support packages. And even though it’s already 2017, it’s still “news” for many of our customers or “only now” becoming available because the language is tied to the NetWeaver release they are working with.

By now, we’ve had the pleasure of working with this version and the one after that (ABAP 7.5 is also available) for some of our customers ourselves. Unsurprisingly, there may be developers that have to bring themselves to embracing these new topics because that is not what they are used to and they are sure that there is more than one road to Rome.

Two specific examples of what’s new in ABAP

But let’s dive deeper. Here are some examples of how working with ABAP has changed:

To me, one of the most convenient changes is the INLINE DECLARATION. As with a number of other languages, this type of syntax allows you to declare the required data elements directly in the command.

Here’s one example:

This is what this looked like before 7.4:

Data: WA type line_of_itab.

Loop at itab into wa.

Endloop.

 

With 7.4:

Loop at itab into DATA(WA).

endloop

This not only saves you one line of source code, best of all it also means that implicit typing is taking place. Incidentally, this type of declaration also works for field symbols and other objects.

The “value” operator is yet another example of a useful adjustment SAP has made:

Before 7.4:

DATA itab TYPE t_itab.

DATA wa LIKE LINE OF itab.

 

wa-col1 = 1.

wa-col2 = 2.

APPEND wa TO itab.

wa-col1 = 3.

wa-col2 = 4.

APPEND wa TO itab.

 

meth( itab ).

 

With 7.5:

DATA(itab) = VALUE t_itab(

( col1 = 1 col2 = 2 )

( col1 = 3 col2 = 4 ) ).

meth( VALUE t_itab(

( col1 = 1 col2 = 2 )

( col1 = 3 col2 = 4 ) ) ).

This is yet another change that helps eliminate unnecessary lines and commands and, in my opinion, makes the source code much easier on the eyes.

ABAP makes a lot of things easier

Another example of simplification is the implementation of LHS = RHS, which means that commands such as “Move A to B” are now obsolete. All you need to do now is state that B = A and you’re done. The main advantage of this is that you can also concatenate these assignments and use them in function calls or method calls.

Other changes are notable in that they make the code much easier to read:

result = class=>do_something(EXPORTING p1 = … p2 = … IMPORTING p3 = … p4 = … CHANGING p5 = … p6 = … ).

With this, it feels like ABAP is moving closer to JAVA and other languages that allow us to use more complex parameters when passing method calls in-line. With 7.4, this now also works for exporting parameters and changing parameters (this was previously only possible with importing parameters).

Three new commands for transformations

There are three new commands that I personally like to mainly use in transformations:

DATA(lin) = lines( itab).

DATA(idx) = line_index( itab[ … ] ).

IF line_exists( itab[ … ] ).

ENDIF.

These commands make checking tables a lot easier. They return the number of lines, the index of a condition, and the check results. You can then go on to directly use all of these values. Before 7.4, you had to start by executing READ commands to determine these checks and there was no way to concatenate these commands. This forced many developers to use auxiliary variables and other such concoctions which did little to make the code easier to read.

Are you interested in ABAP or looking for an expert in the field? I would love to hear you questions or comments.

Yours,

Jörg

Author
Jörg Waldenmayer Team Lead Technology
Phone: +49 (0) 7031 714 660 0
Email: info@inspiricon.de
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
SAP Fiori time tracker

Efficient time logging for your company with the Inspiricon Time Tracker

Author: Ana-Maria Pop, Teamlead Cross Technology

Today we will talk about our second application from the Inspiricon Toolbox, Time Tracker. This application helps to manage the employees’ working time within an organization.

Why did we choose to develop this application?

There are companies, especially the ones which work with SAP, that have solutions for time tracking based on excel. We saw that Microsoft Excel is considered by many to be the most commonly used BI tool in the world, but from our point of view it is not efficient enough. That is why we have found another way to access and analyse SAP BW data, through SAP Fiori and OData service.

The backing of the Inspiricon Time Tracker application is assured by a Planning Cube. Data transfer from the backend is made possible through an Input-Ready Query which is consumed as OData in the Fiori application.

How does the application work?

We will explain the workflow based on an example:

Let’s assume that you are an employee in X Company – a company which is using a SAP ERP and they will always need BI tools for visualization, reporting and so on. Every day you work on a project and on a specific task of this project, but you need to keep track of all this.

How do you do that?

With Time Tracker! A cross browser application which allows you to stock all this information. You can do it from anywhere and from any device: PC, laptop, tablet or smartphone. It is all real time, so if your manager needs your timesheet right now in this moment, he will just have to login to the application and it’s all there. Or if you have made a mistake in your logged work, it’s only a matter of seconds to change it.

Functionality, scope and workflow of Time Tracker

The functionality is quite simple and straight-forward. Usually in SAP Fiori applications, it is a best practice to split the functionality as much as you can. For example, in the timeline case, there will be at least three applications:

  1. one for login the work,
  2. one for planning
  3. and one for request approval.

Time Tracker is the one to login the work.

Basically, you have just one view with all functionalities (FIG.1):

FIG.1: View with all functionalities

FIG.1: View with all functionalities

  1. Filter by date: The data binding between Calendar Date Interval component and the OData received was a bit tricky (because of the ACALLDAY). But we don’t give up easily! We created the mock-up with this component and the result was a success. With this component, you are able to choose a specific date or an interval to visualize your work.
  2. Have an overview off all logs: this is table component with search and sort as additional functions (FIG.2).

    FIG.2: Overview off all logs

    FIG.2: Overview off all logs

  3. Log your work: you just have to click the Log Work button and a dialog with a submit form will open. Choose the project, the task, add a description of what you did, the number of hours, click Log and you are done (FIG.3 and FIG.4).
    FIG.3: FIG.2: Overview off all logs

    FIG.3: Log Work (Desktop)

    FIG.4: Log Work (mobile)

    FIG.4: Log Work (mobile)

  4. Update each logged work: is also a dialog which will open when clicking an entry from the table – here you can adjust the number of hours (FIG.5).

    FIG.5: Update logged work

    FIG.5: Update logged work

And this is the scope and the workflow of our second application. In the future we plan to implement the planning and the request approval applications as well.

All good things go by three

Next week we will present our third app to you– BEx Query Analyzer. Maybe a bit more technical application but also very very interesting! 🙂

You missed the article about our first application, Manage User? No worries, you can always read it on our blog.

Find more information about the Inspiricon Toolbox on our website and in our handout SAP BI meets SAP Fiori.

 

Author
Ana-Maria Pop Team Lead Cross Technology
Phone: +49 (0) 7031 714 660 0
Email: cluj@inspiricon.de
Inspiricon SAP HCP mobile services Fiori

SAP HCP Mobile Services for SAP Fiori – new ways for mobile use

SAP directs its product strategy towards the future and uses keywords like “Mobility first” and “Device independence“. With SAP HCP, mobile services for SAP Fiori, the technical basis for the development of applications has been extended immensely. And it was about time: in a lot of cases, potential of mobile applications is lying fallow – this relates in particular to cost reduction and efficiency.

SAP HCP and SAP Fiori

SAP HCP (HANA Cloud Platform) is an online-service that is offered within SAP’s platform services (please read our blog article on SAP HCP: http://en.inspiricon.de/sap-hcp/). It is one of the most favorite PaaS offers (Platform as a Service) which are currently on the market. The cloud computing platform is addressed to software developers and comprises different services such as SAP HANA databases, IoT services (Internet of Things) and integration services.

SAP Fiori stands for a number of applications for the SAP system in SAPUI5 or rather HTML5 (read our blog on SAP Fiori: http://en.inspiricon.de/category/technology/fiori/). SAP Fiori enables the mobile use of SAP transactions. Concerning User Experience and Usability, SAP was not the first name that came into mind in the past – but the IT made great progress especially in these areas.

SAP HCP is the central extension and development platform for applications in the cloud. It is a real all-rounder that will probably soon be used from each SAP application company. SAP Fiori for mobile users is optimized by means of SAP HCP. This offers completely new possibilities. The advantages and the simplicity of use convince in many ways.

What are the advantages of the new platform?

  1. SAP Fiori can be aimed to the use of mobile user by means of SAP HCP. Mobile users are able to open their internet browser via SAP Fiori applications – in doing so, a secure and seamless integration is granted. SAP HANA Cloud platform is an application service that enables an optimization of mobile activities.
  2. End-to-end solutions allow customization, protection and connection of Fiori Apps – as well as testing, distribution and surveillance of applications.
  3. SAP Fiori applications work on portable devices as veritable mobile applications. Users benefit from a high usability.
  4. Device functionalities like barcode scanner, authorization and data security can be implemented and designed in terms of usability – the same applies for branding.
  5. Users are able to profit from device functions quick and comprehensive. Receiving push notifications and accessing local data are smooth processes.
  6. Companies benefit from high usability and data security. Extensive authorization methods increase security and allow to allocate authorizations.

How to do it

The platform SAP HCP for SAP Fiori can be used quite easy. If you want to try it, you can create a free developer account. All you have to do is to register and apply for an account: that can be activated by an e-Mail link. The platform is designed in a clear way and you will be able to use it intuitively. On the left-hand side you will find the most important features such as the dashboard, HANA XS applications, database systems, HTML5 applications, services and authorizations. As soon as you click on one of the categories, the corresponding category will open on the right-hand side. E.g. Internet of Things, device management or Fiori Mobile. The following steps are self-explanatory and follow the principles of a modular design, based on intuitive handling.

SAP HCP for mobile services for SAP Fiori

Using SAP HCP is quite simple and you do not need special prior knowledge. Advantages for mobile services are huge. There are tangible improvements especially with regard to data and application security, usability and interlinking. By means of user-friendly innovations, fundamental possibilities have been created to improve usability and user experience as well as to design mobile applications in a forward-thinking and modern way.

Inspiricon Best Practice: How to develop a search for http-services with SAP Fiori und SAP HCP

We built a sector-independant and standardized solution for autosuggest with fuzzy matching. Read our Best Practice here: Inspiricon developed a search for http-services with SAP Fiori and SAP HCP (only available in German).

 

Author
Andrei Vlad CEO Inspiricon SRL
Phone: +49 (0) 7031 714 660 0
Email: cluj@inspiricon.de
Inspiricon SAP BW Upgrade 7.4

Being successful with Inspiricon Best Practices: Upgrade SAP BW 7.3 to 7.4 at a global pharma group

Today, we present you an upgrade project of Inspiricon. It was a SAP BW Upgrade from 7.3 to 7.4, realized in the years 2015 – 2016.

Our clients‘ requirements were the following:

  • Release change to SAP BW
  • Increase of system stability
  • Integration of HANA-optimized data models

Please find a summary of our approach here: http://inspiricon.de/wp-content/uploads/2017/02/Inspiricon_Upgrade-SAP-BW-7.4.pdf

Our initial position

Before the upgrade, our client had the release SAP BW 7.3 with different service packages. The upgrade to version 7.4 was necessary in order to

  • enhance system performance
  • develop mobile reportings and applications with Fiori
  • keep SAP systems up to date (bringing in the latest SAP information)

The challenge for Inspiricon

Due to the fact that our client is working globally, our project team was confronted with a heterogeneous IT landscape. The existing reporting is also used worldwide. As a consequence, the BI system creates the possibility to work with the data globally on group level in order to ensure a uniform reporting system.

The following challenges had to be solved from the Inspiricon team in this project:

  • Connected systems and related dependencies had to be taken into account
  • The existing landscape is very complex
  • Many projects were ongoing during the release change, all simultaneously on the system that was to upgrade. Organizationally spoken, information exchange between different projects had to be coordinated promptly in all time zones.
  • No interruption of ongoing operations (“silent upgrade”)
  • Test management: ongoing coverage of all existing system functionalities

The project team comprised up to 20 persons, of which two were Nearshoring resources (BI-IT). The Inspiricon Nearshoring-team contributed the onsite-team not only with its long-time experience and quality standards but also with a significant cost benefit. Read more on Nearshoring here.

 

Inspiricon Project Approach

Inspiricon Project Approach

 

Successful project closing

Go-Live was at the end of May 2016, followed by an intensive Hyper Care Phase for 3 weeks. During this time, our Inspiricon team supported the client until the system was running as performant and stable as it was required.

Due to the release change, our client is now able to use the latest HANA objects entirely and to benefit from their performance advantage. Customer requirements were fully met – subsequent projects are already assigned.

Inspiricon Best Practices

We can learn a lot from successful projects. That is why we developed best practices for future projects from this upgrade project. They include the following and can be transferred to other projects:

  1. Upgrade process (Approach, Upgrade Project Timeline)
  2. Upgrade of technical plan (Pre-upgrade, Upgrade and post-upgrade checklists)
  3. Resource Matrix (Project Organigram, Roles and Responsibilities, Communication Matrix)
  4. Challenges and recommendations

Additional to this blog post, we recommend you to read our Best Practice “Inspiricon Best Practices in use” (only available in German).

You are interested in SAP BW? Read more on http://en.inspiricon.de/sap-bw-bo/. You are also welcome to contact us directly – your contact person for SAP BW is Michael Schmer.

 

Author
Istvan Boda SAP BI Consultant
Phone: +49 (0) 7031 714 660 0
Email: cluj@inspiricon.de
Inspiricon SAP-HANA-2 cloud-in-memory

SAP HANA 2: the next generation of SAP HANA platform

SAP HANA 2 adds new features to the In-Memory Platform SAP HANA. SAP HANA is a platform designed to push forward the digital transformation. Via SAP YaaS (Hybris as a Service) SAP HANA 2 offers new microservices. These are based on the SAP HANA Cloud Platform (read our last blog article: http://en.inspiricon.de/sap-hcp/). Due to these microservices, developers are able to create new innovations and provide modern applications with extensive information.

SAP HANA was introduced in 2010 – with that SAP took a pioneering role in the area of In-Memory technology. SAP HANA offers innovations that are based on a stable master data platform. SAP HANA 2 adds to this pioneering role in order to shape the digital future successfully. SAP HANA 2 will be available for customers from 30 November 2016. Followed by the Express Edition: designed for companies to advance new development projects. There will be extensions each half year to support agile developments.

New functions and extensions

SAP HANA 2 will offer extensive enhancements. Concerning data bank management the focus will be on high availability, workload management as well as security. Supported by these, IT companies are able to guarantee uninterrupted operation.

The option Active or rather Active Read-Enabled offers the use of secondary systems which were only used for system replication until now. This option serves to cope with reading-intensive workloads – without creating a performance loss.

In the range of data management, customers can profit from extensions concerning data quality, data integration, business modelling as well as Tiered Storage (please read our blog article on HANA In-Memory: http://en.inspiricon.de/shrink-growing-hana-database/). Due to these extensions, companies are able to access all data – no matter where they are stored.

There will be a new version of the web application SAP Enterprise Architecture Designer. It is possible to manage complex information architectures. In addition to that, potential impacts of innovative technologies can be visualized before implementing them.

SAP HANA 2 can do even more

SAP HANA 2 also offers an improvement of the analytical intelligence. Innovative engines allow an analytical processing of geo data, text, streaming data and graphical data. Developers will be able to embed comprehensive information in modern applications.

Predictive Analysis Library in SAP HANA 2 comprises new algorithms for association, classification, regression and time series analysis. Using these analyses, data scientists are able to uncover patterns in their data and supplement own applications with machine learning.

In the range of application development, users can benefit from extended functions for application server, development tools as well as development languages. The principle „Bring your own Language“ is supported. Furthermore, additional runtime environments from third-party and build packs are available. They can be used in the model Extended Application Services. With the new interface File Processor API, developers can extract and analyze text and meta data.

New microservices in the cloud

The new microservices are cloud-based and facilitate an integration of analyses in applications. It can be done on each development or language platform via APIs. The cloud microservices include the following extensions:

  • Text Analysis Entity Extraction, Text Analysis Linguistic Analysis and Text Analysis Fact Extraction: with these functions, it is possible to process text data in the cloud whereby processing of natural languages is also feasible.
  • Earth Observation Analysis: this service was developed in collaboration with ESA. Basis for this service is the interface standard WCS of OGC. Earth Observation Analysis uses satellite data of ESA and processes geo data via SAP HANA Spatial, a data base application in the cloud. This service provides historical data in real-time – the calculation happens on the basis of spectral measuring data.

You want to learn more about SAP HANA 2? Contact us here. Also follow us on Facebook or LinkedIn, and we will keep you posted on new trends and topics.

 

Author
Steffen Böhm Member of the Management Board
Phone: +49 (0) 7031 714 660 0
Email: info@inspiricon.de
Inspiricon SAP-HANA cloud Platform

Do you already know the SAP HANA Cloud Platform?

Big Data with its progressive interlinking and real time processing is changing companies tremendously. Information-driven services and products allow completely new user experiences. SAP HANA as an In-Memory platform offers all infrastructure components to enable such technological design – no matter if in the cloud or on premise.

SAP HANA Cloud Platform introduces unforeseen possibilities

With SAP HANA Cloud Platform (SAP HCP), SAP opened the opportunity to implement cloud-based technologies. This PaaS (Platform as a Service) offer helps to develop innovative applications and then putting them into operation. It is linked to SAP HANA. Therefore, companies can use numberless data bases and application services in the cloud. For example the following:

  • integrational and security-related functionalities,
  • support of several development languages as well as HTML5-based interfaces that are intuitive to operate,
  • search functionalities,
  • processing options of geo-referenced information,
  • analysis tools,
  • offline functionalities.

Added value of SAP HCP for users

SAP HCP offers users a huge added value. Users are able to make application environments fit for future requests. The PaaS offer provides a powerful development platform and also functions as runtime environment for individual extensions of IT products. It is very easy to integrate existing and new solutions whether it is a SAP product or not. The SAP HANA Cloud Platform replaces the software life cycle of client-individual adjustments and standard applications. The switch to Business Suite SAP S/4HANA is facilitated in this way:

  • An advancement is not linked to the core application anymore.
  • Default settings that are present in corporate solutions are not affected.
  • This protects existing business processes and improves agility.
  • Consisting in-house developments can be outsourced to SAP HANA Cloud Plattform easily.

SAP HANA Cloud Platform: a huge improvement

SAP HANA Cloud Platform is operated and maintained in SAP data centers. Thus, as a customer you can concentrate yourself on your core competencies – SAP takes care of the rest.

It is possible to test SAP HCP at any time. When you are getting to know the offer, own applications can be realized. Corporations can fall back to customized service packages in different scales.

SAP HANA Cloud Platform sets a new course for businesses. The digital change contains sales, service, marketing, logistics and industry 4.0. In the future, billions of devices will be connected and will exchange data flows – buzzword Internet of Things (IoT).

SAP HCP also offers functionalities for managing devices. Furthermore, device-based messaging is possible. IoT application enablement with data modelling is also integrated. Machine data collection and application data can be received, processed and evaluated in real-time in the cloud. With additional services, sensor-based information can be analyzed and integrated in applications in real-time. Thus, new processes, services and business models are possible. SAP HCP is a signpost that can lead to business success in a digitalized economy.

You want to know more? Or are you looking for someone who supports you to introduce SAP HCP? Get in touch and we will discuss our next steps together.

 

Author
Jörg Waldenmayer Team Lead Technology
Phone: +49 (0) 7031 714 660 0
Email: info@inspiricon.de
Inspiricon HANA in-Memory Speicherplatzreduzierung

How to shrink your growing HANA Database: please meet Inspiricon HANA In-Memory Space Reduction

Businesses nowadays get tremendously bigger. Dealing with large amounts of data becomes a challenge for the Data Warehouse. According to Gartner’s survey regarding data center infrastructure trends and challenges, “Data growth is the largest data center hardware and infrastructure challenge for large enterprises”.

In order to face these challenges many organizations found their relief in in-memory data platforms such as SAP HANA with its hybrid structure for both processing transactional workloads and analytical workloads completely in-memory. With the new release of SAP HANA, SAP introduces a new concept of Multi-Temperature and Data Lifecycle Management storing data efficiently on different types of storage devices based on data temperature, as shown in figure 1. Taking this into consideration, data which is accessed frequently (hot data) is stored in-memory on HANA while warm data can be stored on Extended Storage Host (Dynamic Tiering). Cold data is moved on less expensive storage devices outside the HANA Database only for the read purpose, known as Near-Line Storage (NLS, read more here).

Figure 1. Multi-Temperature Data Classification

Multi-Temperature-Classification

Multi-Temperature-Classification

One of our customer’s project goals was to move some of less frequented data on disk that still could be accessed and don’t keep it in HANA in-memory. In search for a suitable solution for our customer, who was looking to optimize HANA memory consumption and with this reducing license costs as well as improving the system stability, we have analyzed and investigate a possible SAP solution:

  • Dynamic Tiering unfortunately doesn’t fit our customer scenario due to additional license costs as well as many features and functions which are underdeveloped yet and will only be available in future releases.

Our first research analysis was focused on developing the Inspiricon HANA In-Memory Space Reduction project where we have evaluated different approaches such as:

  • Migration of the existing data models to HANA optimized ones (LSA++).
  • Identifying and deleting outdated data/objects that are not required for reporting any more.
  • Defining with business and unloading historical data from HANA in-memory to HANA disk space.
  • HANA DB compression.

The above listed approaches exploit SAP HANA features, e.g. partitioning of AdvancedDSO. We have developed a methodology, based on Inspiricon best practices, which does not imply additional license costs and does not increase the TCO (Total Costs of Ownership).

As a result, we have introduced the Data Lifecycle Management (DLM), which covers defining data keeping needs through Business/IT and methods to apply for a certain data model depending on its complexity and Business/IT requirements.

Figure 2. Inspiricon Methodology for DLM

Inspiricon Methodology for DLM

Inspiricon Methodology for DLM

Our project was based on a detailed system analysis identifying the biggest data objects that would be possible candidates for minimizing HANA memory consumption.

Figure 3. DLM approaches to reduce memory consumption

DLM approaches to reduce memory consumption

DLM approach to reduce memory consumption

Remodeling

This solution helps to better organize the existing data model by either deleting data which is stored multiple times in different InfoProviders or eliminating BW objects in layers which become obsolete on HANA. As a consequence HANA in-memory is reduced.

Unload Application

This application was developed by Inspiricon in particular for this customer scenario. The main usage is focused on unloading certain objects’ tables from HANA in-memory to HANA disk space. Thus, HANA DB will automatically load them back to the memory, once data is accessed in any way.

Partitioning

This approach helps to decrease memory consumption by unloading just a number of predefined partitions excluding others, based typically on time characteristics like calendar year/ month or fiscal period. Partitioning is defined on BW and it is performed on the Database level and can be applied to the existing DSO (with restrictions) or to the AdvancedDSO depending on customer business requirements.

Summary

  • As a result, the Inspiricon HANA In-Memory Space Reduction Project saved 20% of our customer HANA memory consumption without additional license costs and resources.
  • The main deliverables were better loading performance and improvement of the system stability, smoother DW landscape – and with this decreasing considerably the annually SAP HANA memory licenses.
  • Our consultancy added value is to deliver the best solution that matches our customer needs, implying our know-how, effective consulting and partnership.

 

Author
Claudio Volk Member of the Management Board
Phone: +49 (0) 7031 714 660 0
Email: info@inspiricon.de