Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 
Former Member

     I guess until now you might have used SAP NetWeaver Gateway for building people centric applications by unlocking your transactional data stored in SAP  backends. But, do you wanted to unlock the analytic content in SAP BW system and build people centric user interfaces for analytics? If yes, then this post will give you a quick overview. In this post I will show how to transform a SAP BW Cube of type Query which can be accessed using MDX into an OData Analytic service.

I have splitted the topic into 3 parts.

  1. Transform SAP BW Queries into OData Service: Part 1 - Generation and Activation
  2. Transform SAP BW Queries into OData Service: Part 2 - Analyze OData Analytics Service
  3. Transform SAP BW Queries into OData Service: Part 3 - Execute OData Analytics Service


Pre-requisites


     SAP NetWeaver Gateway 2.0 SP05 - I would recommend using SAP NetWeaver Gateway 2.0 SP05. Nevertheless most of the features are supported      from SP04. The examples that shall be shown in this series are from SP05.

    

     SAP BW 7.00 - Well you could use SAP BW release 7.0 onwards for exposing Cubes of type query that can be accessed via MDX. The examples that shall be shown in this series are from SAP BW 7.30.

Recommended Deployment

Ok lets start with the first step ...

Generation

OData analytics service can be generated using SAP NetWeaver Gateway Service Builder (Transaction - SEGW). The below image summarizes the steps.

-- Click on the Image --

Generation Steps

  1. Run transaction SEGW
  2. Create a New Project in Service Builder
  3. Right click on Data Model and select from the context menu "Redefine->BW Service"
  4. A three step wizard pops up

First Step

     In this step you

  1. Choose the Access Type as "Controller for MDX (SAP BW)"
  2. Provide the RFC destination pointing to SAP BW system. If you have deployed IW_BEP in SAP BW system keep the RFC destination as "NONE"
  3. Press F4 on field Catalog to select the BW catalog that has the cube of type query that could be accessed using MDX
  4. Press F4 on field Cube to select the Cube of type query that you wish to convert to an OData Service.

Second Step

     You could choose to leave the screen with default values. Just fill in a meaningful description for the OData Model and OData service.

In this step you normally specify the OData Model Provider and Data Provider class names and OData Model and OData Service names.

Final Step

     Select all Entity Types proposed by the system and press Finish.

The service should be successfully generated.

Activation    

     The next step is to activate the generated OData Analytic Service. Logon to SAP NetWeaver Gateway Hub and execute the transaction /IWFND/MAINT_SERVICE to activate the service. I assume you are familiar with the transaction /IWFND/MAINT_SERVICE. If not please visit http://help.sap.com/nwgateway -> SAP NetWeaver Gateway Developer Guide -> OData Channel -> Basic Features -> Service-Life Cycle -> Activate and Maintain Services.

Next - Transform SAP BW Queries into OData Service: Part 2 - Analyze OData Analytics Service.

14 Comments