Skip to Content

With SAP HANA live views SAP seems to be taking a big leap into flexible reporting. HANA Live views provide a flexible and great way to run reporting directly out of HANA.  HANA studio offers great features and flexibility to create table joins, transformations/conversions and projections etc. to slice and dice the data within HANA studio.

SAP seems to be setting up a trend where reporting is going to get really agile and essentially there is no need to write ABAP code or transfer data to BW to draw reporting out of SAP. There are host of tools like BO, FIORI, LUMIRA, SBEE available to run the reporting directly out of HANA Views. I am going to talk little bit about SBEE.

SBEE (SAP Smart Business Executive Edition) is a dash boarding tool to run the reporting. SBEE is simple, intuitive tool which can be configured by end user/functional consultant. There is no need for developer to write any code. Primary purpose of SBEE is dashboard reporting for top leaders of organization/various groups. Dashboards like top 5 revenue generating products, top 5 customers, top 5 vendors etc.

SBEE can directly connect to HANA live views and automatically identifies key figures (values), parameters and dimensions (attributes). Dashboards can be configured fairly easily and quickly. Below is the configuration steps to create a SBEE dashboard.

Pic1 SBEE Flow.png

SBEE Configuration Flow


Data Sources: Here source of data is configured. It can be a SAP HANA View or manual KPI entry. Once you select SAP HANA View key figures, dimensions and parameters are automatically selected.

Pic 2 SCN Data Sources.png

Data Source Configuration


Appropriate HANA live view has to be made available. Host of views are delivered out of the box. Hana studio offers tools to set-up new views as well. One examples is shown below.

Pic 3 Hana Editor.png

HANA Live View Editor

Semantics: Here the dashboard semantics are defined i.e. type of component/report like comparison, table, value etc. Dimensions and key figures are selected and look and feel of the dimensions and key figures is also configured here. This is the step which would consume most of the time.

Pic 4 Sementics Editor.png

Semantics Editor

Stories: Components created above are organized under stories. Different components can be added under one story and more than levels can be created like a drill down report.

Pic 5 Stories Editor 1.png

Stories Editor

Pic 6 Stories Editor 2.png

Stories Editor

Dashboard: Stories are then assigned to dashboard. Configuration is similar to stories configuration where more than one levels can be configured to arrange the dashboard chronologically.

Pic 7 Dashborad Editor.png

Dashboard Editor

Pic 8 Dashboard Editor.png

Dashboard Editor

Few Examples of how the dashboard looks like are:

Pic 9 Dashborad.png

Pic 10 Dashborad.png

SBEE is little in-flexible in manner that not much slicing and dicing can be done on data. But, SBEE is meant for dash boarding not for detailed reporting. One thing also to be kept in mind is that in order for the dashboard to have desired output the HANA Live view data has be organized in required manner i.e. data to be displayed should be available in various dimensions and key figures according to the requirement.

For more details you can refer to official SAP content which is very easy to follow.

To report this post you need to login first.

11 Comments

You must be Logged on to comment or reply to a post.

          1. Christoforos Verras

            Hi again,

            your article is about:

            – SAP Smart Business Enterprise Edition, while I am talking about

            – SAP Smart Business Executive Edition

            That’s my point.

            I read some time ago, that SAP Smart Business Executive Edition will not be supported anymore, that’s why I ask you.

            If you are writing a blog about it, and it’s the same product then maybe it will not be “shutdown”.

            Best,

            .CV

            (0) 
            1. Ty Miller

              I’m not familiar with SAP Smart Business Enterprise Edition. SAP Smart Business Executive Edition is indeed being phased out and replaced with SAP BusinessObjects Cloud upon which the SAP Digital Boardroom runs.

              (0) 
  1. Sun Tae Kim

    Hi.

    Can I use a ‘Assigned User’  in the Dashboard configuration menu?

    Asuming that this a dashboard screen role. isn’t it? but I can not hanle this.

    All Dashboards are displayed  when I access our system using a assigned consumer user.

    Thanks in advance.

    BR

    ST

    (0) 
  2. Ty Miller

    There has never been a Smart Business Enterprise Edition. And Smart Business executive edition (SBee) is now in Restricted Shipment mode meaning that you can’t purchase it unless you already have and want more licenses. SBee will not be developed further, and is now in Mainstream Maintenance until its end of life on September 30, 2017. The SAP Note for this is here. The replacement for SBee is SAP Digital Boardroom which is built on top of SAP BusinessObjects Cloud.

    (0) 

Leave a Reply