Mapping Query Data

The EDM schema used by the OData service maps the following EDM elements:

  • The EntityContainer contains EntitySets.
  • EntitySets are mapped to query flows. An EntitySet is defined by an EntityType.
  • An EntityType consists of a series of Properties. A Property is mapped to a result object defined in the Query Specification and used in a query flow.

The following table describes the attributes defined for a Property. Attributes prefixed with "sap" are specific to SAP BusinessObjects universes.

Table 1: List of Attributes
Attribute Description

Name

Name used by the OData service to identify the object.

Type

Result type.

sap:label

Original name of the object in the universe.

sap:objectKey

Object ID in the universe.

sap:qualification

Object type. Possible values are Dimension, Measure, and Attribute.

sap:projectionFunction

Aggregation function applied to an object of type Measure. Possible values are: Average, Count, First, Last, Max, Min, Sum, Delegated, and None.

Example

The following <Property> element defines an object used in the query:

<Property Name="Year" Type="Edm.String" Nullable="true" Unicode="true" sap:objectKey="OBJ_49" sap:qualification="Dimension"
    sap:label="Year"/>
Incomplete Result Set

The <Schema> XML element has a sap:isPartial attribute that indicates whether the result set of the query is complete.

sap:isPartial is set to false if the result set to return is greater than the value of the "Max rows retrieved" option or if the the execution query time takes more time than the maximum timeout defined in the "Max retrieval time" option. It is set to true otherwise.