Show TOC

Generating an SAP Gateway Analytics Service Using MDX and Easy QueryLocate this document in the navigation structure

  1. Logon to the SAP Gateway Hub system or SAP backend system where IW_BEP 200 SP04 is installed.

  2. Go to transaction SEGW.

  3. You can either create a new project or open an existing project.

  4. If you are editing an existing project, click Display - Change.

  5. Expand the project and in the context menu of Data Model, choose Start of the navigation path Redefine Next navigation step BW Query Service End of the navigation path.

  6. In the Wizard Step 1 of 3: Redefine Service screen, enter the following:



    Access Type

    From the dropdown list, choose one of the following:

    • Controller for Easy Queries (SAP BW) for Easy Query

    • Controller for MDX (SAP BW) for MDX

    • Controller for MDX (SAP BW) 2.0 - to retrieve the properties defined in the query designer for a query.

    RFC Destination

    Press F4 and choose the RFC destination of the SAP BW system.

    Catalog Name

    For MDX — enter a catalog name.

    For Easy Query — this field is optional.

    Query Name

    Choose a query name from the F4 help available.

  7. Click Next.

  8. In the Wizard Step 2 of 3: Redefine Service screen, enter descriptions for model name and service name.

  9. Click Next.

  10. In the Wizard Step 3 of 3: Redefine Service screen, choose the OData artifacts which should be a part of the service you are generating and click Finish.

  11. Click Generate Runtime Objects.

  12. In the Model and Service Definition dialog box, you can either:

    • change the Technical Service Name to create a new service and, click Continue.

    • select the check box Overwrite Extended Service to overwrite the existing service and, click Continue.

  13. Enter the package details and click Save.

Once the service is generated, you need to register and activate the service. See, Service Maintenance for more information.