Generating an SAP Gateway Analytics Service Using MDX and Easy Query

Use

  1. Logon to the SAP NetWeaver 7.4 system or SAP backend system..

  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( Display - Change).

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

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

    Field

    Description

    Access Type

    From the dropdown list, choose:

    • Controller for MDX (SAP BW) for MDX
    • Controller for Easy Queries (SAP BW) for Easy Query
    • 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 (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.