BI Knowledgebase

Custom Search Control
<< First  < Prev   1   2   3   4   5   ...   Next >  Last >> 
  • 27 Apr 2017 2:22 PM | Sergei Peleshuk (Administrator)
    Sergei Peleshuk will be speaking at HANA 2017, 14-16 June in Amsterdam! Be sure to join him there for the following sessions:
    • Agile modelling in SAP BW on SAP HANA as a preparation step for migrating to SAP BW/4HANA 
    • Practical steps for building an SAP BW/4HANA proof of concept 

    Our close collaboration with SAPinsider this year has made it possible to extend a special discount to our valued clients and colleagues who have not yet registered. Click here to register:


    This is an annual BI Conference organized by SAPinsider.

    Below are the highlights from Sergei's sessions:

  • 19 Apr 2017 4:16 PM | Sergei Peleshuk (Administrator)

    Learn about SAP BW/4HANA and considerations to evaluate when making the decision to migrate. Understand how the effort of implementing SAP HANA-based enterprise data warehousing empowers companies, leads to greater returns, and reduces total cost of ownership.

    Learning Objectives Reading this article, you will learn about:
    • How to use SAP BW/4HANA and how it is different from traditional SAP BW
    • The features and capabilities of SAP BW/4HANA
    • Migration considerations and evaluating what impact the migration has on the total cost of ownership

  • 19 Dec 2016 12:30 PM | Sergei Peleshuk (Administrator)

    Historically Business Analytics technologies and traditional datawarehousing implementations were associated with long projects, enormous workloads, high costs and doubtful returns. This has changed with the introduction of modern cloud-based in-memory solutions and EDW platforms such as SAP BW/4HANA. In the post below I will go through a few points that are vital for efficient EDW solutions delivery. Specifically, I focus on Cloud infrastructure, Agile architecture and Self-Service front-end capabilities, and explain why they are crucial for success.

    Read Full Article

    Related Topics:

  • 01 Oct 2016 9:00 PM | Sergei Peleshuk (Administrator)

    Just a few years ago SAP has introduced a new Business Analytics presentation layer tool that has immediately caught attention and became a leader in the industry. Today SAP Lumira 1.31 has a lot of visual capabilities that help analyze data from many different sources including SAP HANA, SAP BW, MS Excel, Universes, SQL Server, Hadoop, etc.

    SAP Lumira is a self-service tool used directly by LOB (Line of Business). Technical job is to prepare a robust data model and have it exposed to a Presentation Layer tool via performing queries or views. The rest is the job of business users: powerful visualizations with numbers and charts, filtering and ranking, hierarchies, exceptions, geographical functionality (map visualizations), storyboards, etc., all is available at the fingertips of users in the latest version of SAP Lumira.


    Related Topics:

  • 10 Sep 2016 10:58 AM | Sergei Peleshuk (Administrator)

    BPC Classic (Standard) 10.1 on Netweaver platform uses objects in SAP BW, however in many cases the level of integration with BW requires custom development. In the post below I will review steps needed for a BPC dimension hierarchy to be updated automatically from infoobject attributes in SAP BW.

    Example 2 - ABAP code samples for the scenario where we generate BPC Account attributes, text and hierarchy based on GL Account hierarchies.


    Related Topics:

  • 20 Jun 2016 8:02 PM | Sergei Peleshuk (Administrator)

    SAP has succeeded in moving towards a modern coherent planning suite with the release of SAP BPC 10.1, version for SAP NetWeaver. The new product combines the advantages of BW Integrated Planning, SAP HANA and SAP BPC.

    SAP BPC 10.1 NetWeaver version offers a Standard as well as a new Embedded model. While the Standard Model does not differ much from the BPC 10.0 for NetWeaver, the Embedded model provides a planning suite that is based technologically on SAP BW 7.4/7.5 on HANA and combines the planning components of SAP BW Integrated Planning and SAP BPC.

    In this insight, you will find a high level technical overview of SAP BPC and its basic architecture components. The focus is on BPC Embedded, its advantages, weaknesses and differences with the BPC Standard.

    At the same time, we address a number of typical questions people ask about SAP BPC nowadays: 

    • What are the different versions of SAP BPC available? 
    • What is new in BPC embedded on HANA? 
    • What is the difference between BPC and BW IP? 
    • What is IBP (Integrated Business Planning) and its role? 
    • What are the pros and cons for different SAP Business Planning and Consolidation tools in relation to the latest releases of SAP HANA, Netweaver, S/4HANA and BPC?

    Available BPC Versions 

    Today there are about 5 different versions of SAP BPC available from SAP depending on how you count: 

    • SAP BPC 10.1 Microsoft, 
    • SAP BPC 10.1 NetWeaver Standard on a traditional database (e.g. Oracle, db2), 
    • SAP BPC 10.1 NetWeaver Standard on HANA, 
    • SAP BPC 10.1 Embedded on HANA, and 
    • SAP BPC Optimized for S/4 HANA.

    This may sound confusing and overwhelming. We will focus below on the SAP BPC Embedded version and go through its specific features, advantages and weaknesses.

    What is New in BPC Embedded vs. Standard?

    BPC Embedded (or in other words BPC Unified [old term]) is one single platform for Planning, Consolidation and Reporting leveraging the power of SAP HANA on large datasets together with the flexibility and appeal of SAP BPC front-end modelling capabilities to business users (LOB). On the other hand SAP BPC Embedded leverages the powerful BW on HANA data warehousing capabilities and modern Business Objects tools for reporting, dashboards and apps.

    Read full article

    Related Topics:

  • 24 Mar 2016 5:36 PM | Sergei Peleshuk (Administrator)

    Discover the steps required for developers to design a data model in SAP BW on SAP HANA and SAP BW Integrated Planning, to deliver a web application that addresses a particular business logic, together with a set of visualizations.

    Learning Objectives

    By reading this article you will:

    • Learn the basic steps a developer has to take to build a data warehousing model for a particular business application
    • Understand the basics of  SAP BW Integrated Planning (IP) and how it can be used together with BusinessObjects Design Studio for data entry, budgeting, and planning
    • Understand the data modeling basics in SAP BW and IP

    Key Concept

    Value disaggregation (also called top-down distribution) helps you to manually enter data within manual planning using input-ready queries, and distribute the data to a lower level according to certain business rules. For example, you may want to maintain a budget by site and let the system automatically distribute values down to cost centers belonging to each site.

    Modern SAP BI tools provide a range of capabilities for complex business scenarios involving reporting, dashboard design, and predictive analytics, together with data-entry and business-planning capabilities. I provide a detailed overview of these competencies using an example of a business application and related data modeling where transactional numbers from SAP ERP have to be combined in a dashboard with a set of key figures maintained by users via a web portal page.

    In terms of tools, I am limiting the scope of this article to SAP Business Warehouse (BW) Integrated Planning (IP) on the back end, and BusinessObjects Design Studio on the front end. Obviously, SAP Business Planning and Consolidation (BPC) and other planning tools can be used in case of complex planning scenarios. However, in this article I show how SAP BW IP itself, together with BusinessObjects, meets the needs of this particular business requirement.

    In the case of a highly decentralized retail organization with multiple entities maintaining their transactional data in various ERP systems and Microsoft Excel spreadsheets, a common data entry approach is needed to deliver a range of benchmark key performance indicators (KPIs). Here, I am talking about thousands of sites. To set up data consolidation from such a variety of different (in nature) data sources may take years, whereas a portal entry page for major KPIs may require only few months’ work.

    Read full article here

    Related Topics:

  • 28 Oct 2015 2:52 PM | Sergei Peleshuk (Administrator)
    Discover more about the options and advantages of various presentation tools in the BusinessObjects portfolio. Learn tips and ideas for how to select an appropriate tool for your needs.

    Read full article here

    Related Topics:

  • 04 Aug 2015 2:42 PM | Sergei Peleshuk (Administrator)
    Discover options for implementing the SAP BI powered by SAP HANA platform in the cloud. Learn tips and ideas for efficient ways of setting up a cloud infrastructure for SAP BW on HANA, SAP BusinessObjects, and BusinessObjects Data Services (BODS).

    Please read full article on

    Related Topics:

  • 17 Mar 2015 10:44 AM | Sergei Peleshuk (Administrator)
    Discover how to choose the right data-warehousing platform for corporate reporting and planning. This comparison of the capabilities of SAP BW, SAP HANA, and SAP BW on HANA helps elucidate the best use and benefits of each platform.

    Please read full article on

    Please find a Russian translation of the article for

    Related Topics:

<< First  < Prev   1   2   3   4   5   ...   Next >  Last >> 
Powered by Wild Apricot Membership Software