Building Queries on OData Web Services

Objectives
After completing this lesson, you will be able to:

After completing this lesson, you will be able to:

  • Use OData web services as a data source

Use OData web services as a data source

To replace the previous Document as a Web Service and Query as a Web Service, Web Intelligence exposes an OData Web Service.

With OData Web Services, you retrieve data from existing visualization that you can reuse in other documents. To benefit from OData Web Services, you first need to create OData data providers from existing visualizations and generate a unique URL. That URL allows the application to retrieve data from a given visualization and reuse it.

Restrictions

In the SAP BI 4.3, only OData Web Services exposed by Web Intelligence are supported.

The following capabilities are not yet supported for the OData data sources:

  • Combined queries.
  • Sub-queries and list of values of objects when defining a filter. Only constants and prompts are supported.
  • Query stripping.

Watch this video to learn how to build queries on OData Web Services:

Log in to track your progress & complete quizzes