Skip to Content
-1

SAP HANA OData Service is only returning one row

Feb 13 at 04:34 PM

42

avatar image
Former Member

Hi,

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

https://myserverurl/project039/TestSales.xsodata/?metadata

<?xml version="1.0" encoding="utf-8" standalone="yes" ?>

http://www.w3.org/2005/Atom" xmlns:app=" http://www.w3.org/2007/app" xmlns=" http://www.w3.org/2007/app" xml:base="https://myserverurl/project039/TestSales.xsodata/">

<workspace>

<atom:title>Default</atom:title>

<collection href="OnHand">

<atom:title>OnHand</atom:title>

</collection>

</workspace>

</service>

https://myserverurl/project039/TestSales.xsodata/$metadata

- http://schemas.microsoft.com/ado/2007/06/edmx"> - http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" m:DataServiceVersion="2.0">

http://schemas.microsoft.com/ado/2007/08/dataservices" xmlns:m=" http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" xmlns=" http://schemas.microsoft.com/ado/2008/09/edm">

<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" />

</EntityType>

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

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

</Schema>

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

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

https://myserverurl/project039/TestSales.xsodata/OnHand

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

Regards,Sai

10 |10000 characters needed characters left characters exceeded
Former Member

Hi Any update from the experts on this.??

0
Former Member

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

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

0 Answers