Skip to Content

This blog is part of blog series: What’s New with SAP BusinessObjects Lumira 2.0

Business users of SAP Lumira 2.0 can connect to various types of data sources via offline and online fashion to perform self service data discovery. SAP HANA being an important data source, Lumira 2.0 supports HANA connectivity in LIVE way along with other options such as Import and Free Hand SQL using JDBC.

This Blog is intended to provide an overview of the HANA live connectivity with Lumira Discovery 2.0 client:

Pre-requisites:

  • Make sure your XS Engine URL is up and running for                                                             http(s)://<HANA_SYSTEM>:<WEB_DISPATCH_PORT>                                                    E.g.: http(s)://HANA_SERVER_NAME:8003.
  • You need to have the SAP HANA Info Access Service (InA) with delivery unit HCO_INA_SERVICE deployed on the HANA platform.                                                        Refer: https://archive.sap.com/documents/docs/DOC-64277

Highlights

  • ŸLive mode uses HTTP/HTTPS based INA connectivity
  • ŸConnect directly or leverage a BI platform managed HANA OLAP connection (only HTTP/HTTPS, no JDBC)
  • ŸYou can leverage SAML based single sign on to SAP HANA from Discovery
  • ŸLive connections based document are by nature always saved without data.
  • HANA live documents can also be created in BI Launchpad.

 

Workflows

1. Connecting to SAP HANA from Discovery.

Click on the Live option next to HANA data source in the home page. You can connect either via Direct or Managed connections in BI platform.

Connecting Via Direct / Local connection:

You need to provide the connection to HANA online as:                                                                    http(s)://<HANA_SYSTEM>:<WEB_DISPATCH_PORT> where HANA_SYSTEM is the name of the HANA Server and WEB_DISPATCH_PORT is the XS Web dispatch port.

E.g: http://myhanaserver.sap.corp:8011

NOTE:

  • Make sure you have your xs port up and running by first manually entering the URL on browser.
  • You need to have the SAP HANA Info Access Service (InA) with delivery unit HCO_INA_SERVICE deployed on the HANA platform.                                                        Refer: https://archive.sap.com/documents/docs/DOC-64277

 

 

Connecting Via managed / OLAP connection:

A managed connection for HANA system can be created in the BI platform for http(s) access. This connection can be used in Discovery client to connect to HANA source.

To create a managed connection, logon to Central Management console of BI Platform and select OLAP connections option, create a new connection, test and use the same in Discovery:

NOTE: You need to create HTTP(S) based managed connection for HANA online access and JDBC based managed connection for HANA offline access.

Advantages of using managed connections:

  • Data is always secure and managed by BI Platform administrators.
  • IT can control the BI users to access the managed connections.
  • Achieving Single Sing on becomes easy.

For all the above reasons using managed connections is always advantageous over local / Direct connections.

NOTE:

  1. documents consuming BW Live connections using direct / local connections can not be published/saved to BI Platform.
  2. Managed connections of type Prompt are not supported for BW Live analysis.

 

2. Listing of HANA views

Once connection is successful, you can either search or browse for the views in the HANA system:

select the view and click OK.

 

3. HANA Variables:

HANA modelling objects such as input parameters, Prompts are supported.

NOTE: You can add another data after creating your BW online based document. in this case if the same variables are used in the query being added, Prompts will be merged.

 

 

4. Data View:

Once the prompts are answered, Discovery connects to the HANA source and data can be viewed by dragging and dropping the measures and dimensions to visualizations in the canvas area.

select a Chart from the Chart Picker:

 

Select Crosstab from above and Drag-drop the measures / Dimensions:

 

5. Hierarchy Support.

Parent-child and Level based Hierarchies in HANA are supported in Discovery.

Hierarchies are displayed in the Object picker and user can select and drill based on these hierarchies.

Drill operations:

6. Other analytical operations:

Discovery supports all other analytical features on the HANA live data as well, ensuring the complete self service capabilities. Some of the commonly used analytical operations such as filters, ranking, reference line, sort, custom calculation, dynamic calculation etc..

A sample story board:

 

7. Creating a HANA online document in BI Platform:

With appropriate authorizations on Lumira application, OLAP connections and other necessary rights, Discovery HANA Live documents can also be created in BI Launchpad.

This needs OLAP connection is created in BI platform.

All analytical operations supported on desktop are also supported on BI platform.

Advantages of HANA Live

  • Calculations are delegated to HANA server.
  • Data is always secured.
  • Enhanced support for HANA Variables/Prompt support.
  • Can be extended as a profession dashboard via Designer (seamless integration).

 

 

 

Register for the Lumira Newsletter: http://info.sapdigital.com/LUM-NSLTR-REG.html

What’s New with SAP BusinessObjects Lumira 2.0 Launch blog series: https://blogs.sap.com/2017/04/18/whats-new-with-sap-businessobjects-lumira-2.0-launch-blog-series/

To report this post you need to login first.

14 Comments

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

    1. Srivathsa Gunda Dixit Post author

      you have 2 types of olap connections for HANA in BI platform.

      one is http(s) based and other is JDBC based.

      For Live connectivity Lumira 2.0 uses http(s) based connectivity only.

      For import or offline scenarios Lumira supports JDBC based connections.

      (0) 
      1. Aldo Ruiz Wong

        Hello

         

        Have you tried this with SAP Hana Express 2.0 ( Version: 2.00.020.00.1500920972 ) ?

        I cant connect using http(s) based, when i try to deploy the HCO_INA_SERVICE i get this message when i check the status with this link  ( http://hxehost:8090/sap/bc/ina/service/v2/GetServerInfo ) : {“Messages”:[{“Number”:42001,”Type”:2,”Text”:”InformationAccess Service GetServerInfo is not available. Install the SAP HANA EPM-MDS plugin.”}]}

         

        Regards

        (0) 
  1. Sebastian Ospina

    Hello,

    I made a story in Lumira Discovery with Sql database and mistakenly called a query additionally and I can not delete it. I need to delete it because at the moment of login, it asks me to log in twice.

     

    Thanks you.

     

    (0) 
  2. Rodrigo Silveira

    Nice post !


    Could you help me in something: My landscape is: BO4.2/Lumira Server 2.0 + HANA Real Time from ECC.


    I have a sales dashboard, but how can I refresh data automatically?

     

    Regards,

    Rodrigo.

    (0) 
    1. Srivathsa Gunda Dixit Post author

      Hi Rodrigo,

      Thank you! when ever you open the document, it always gets refreshed. or when you change the prompt values with edit prompts option, the document gets refreshed.

      Regards,

      Srivathsa Dixit

      (0) 
  3. Robert Bienert

    Hi,

    the description and links for further reading helped me a lot to enable the INA service. But I guess I have a missing link, because when I connect to my HANA with Discovery as described above the list of views is empty. Requesting the URL path /sap/bc/ina/service/v2/GetResponse?Request={“Metadata”:{“Expand”:[“Cubes”]}} gets a JSON object named Cubes which contains a list of 110 views and database tables.

    Best regards
    Robert

    (0) 
    1. Robert Bienert

      OK, after having some talk with colleagues I have the solution for the problem:

      1. The user accessing the HANA database needs appropriate roles and rights, that are:
        • The roles
          • CONTENT_ADMIN
          • MODELING
          • PUBLIC
          • sap.bc.ina.service.v2.userRole::INA_USER
          • sap.hana.xs.admin.roles::RuntimeConfAdministrator
          • sap.hana.xs.ide.roles::Developer
          • sap.hana.xs.ide.roles::Administrator
        • The object privileges:
          • _SYS_BI
          • _SYS_BIC
          • _SYS_RT
          • <your username>
          • <your schemas>
        • The analytic privilege _SYS_BI_CP_ALL
        • The package privilege for the root package
        • The application privilege sap.bc.ina.service.v2::Execute
        • and the necessary rights as GRANT SELECT ON SCHEMA <your schema> TO _SYS_REPO WITH GRANT OPTION;
      2. Calculation Views based on your database objects (views or tables, can be defined graphically or in SQLscript).
      3. An OLAP connection created in the Central Management Console of your BI platform.
      (0) 
      1. Aldo Ruiz Wong

        Hello

         

        I created an user “LUMIRA” with all these roles and rights but i cannot connect with lumira 2.0 discovery (Import option). I’m getting this message: “Unable to connect to hxehost” meanwhile when i use the user system i can log in but i cant see any view.

        Is there a missing right to log in like the system user?

        Thanks

         

        Regards

        (0) 
  4. Klaus Zeuch

    Hi,

    where did you find the information that Lumira 2 discovery supports Hana parent-child hierarchies? Tested with a view  in Hana Live mode, hierarchy is not discovered (Analysis for Office identified the parent/child hierarchy).

    When looking at https://help.sap.com/viewer/67a08e99ebed427daefb66e497b0f83c/2.0.2.0/en-US/e8845ebb5bd44ee0a25b0c500d477ba1.html (no change compared to Lumira 1.31.x) I don’t see that discovery would support parent/child hierarchies

     

    (0) 

Leave a Reply