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.

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.