Skip to Content

SAP HANA OData Service is only returning one row

Feb 13 at 04:34 PM


avatar image


I have a calculation view and i am trying to expose this as an OData service.

so i created this testSales.xsodata file , only exposing some columns from the cal view.

service namespace "project039" { "project039/CV_TEST.calculationview" as "OnHand" with ("Master_UPC","Master_UPC_Desc","OnHandQtyFri","OnHandQtyMon","OnHandQtySat","OnHandQtySun","OnHandQtyThu","OnHandQtyTue","OnHandQtyWed")

keys generate local "ID"; }

Below is the Metadata i am getting


<?xml version="1.0" encoding="utf-8" standalone="yes" ?>" xmlns:app="" xmlns="" xml:base="https://myserverurl/project039/TestSales.xsodata/">



<collection href="OnHand">






-"> -" m:DataServiceVersion="2.0">" xmlns:m="" xmlns="">

<EntityType Name="OnHandType">

<Key> <PropertyRef Name="ID" /> </Key>

<Property Name="ID" Type="Edm.String" Nullable="false" MaxLength="2147483647" /> <Property Name="Master_UPC" Type="Edm.Int32" />

<Property Name="Master_UPC_Desc" Type="Edm.String" MaxLength="40" />

<Property Name="OnHandQtyFri" Type="Edm.Int32" />

<Property Name="OnHandQtyMon" Type="Edm.Int32" />

<Property Name="OnHandQtySat" Type="Edm.Int32" />

<Property Name="OnHandQtySun" Type="Edm.Int32" />

<Property Name="OnHandQtyThu" Type="Edm.Int32" />

<Property Name="OnHandQtyTue" Type="Edm.Int32" />

<Property Name="OnHandQtyWed" Type="Edm.Int32" />


<EntityContainer Name="TestSales" m:IsDefaultEntityContainer="true">

<EntitySet Name="OnHand" EntityType="project039.OnHandType" /> </EntityContainer>


</edmx:DataServices> </edmx:Edmx>

Here is how i am accessing from a reporting service using this URL


when i tried to call the service it is only showing one row. how do i get all the rows.?


10 |10000 characters needed characters left characters exceeded

Hi Any update from the experts on this.??


please ignore this , it is an issue in calc view.

* Please Login or Register to Answer, Follow or Comment.

0 Answers