Skip to Content
1
Mar 26, 2020 at 09:56 AM

SAP CF HANA Calc View with Table Function - expose as ODATA service - Weird error

392 Views Last edit Mar 26, 2020 at 09:58 AM 2 rev

Hi All,

I am working with SAP WebIDE on the SAP CloudFoundry platform using a HANA service.

I have built a simple HANA Calculation view ( type SQL ACCESS only ) which basically uses a Table Function to generate table data. The CV has no input parameters.

The CV runs fine and generates the wanted data.

Now I want to expose this CV as an ODATA service entity so I added a new definition within my existing XSODATA service ( which contains already a number of entities based upon normal HANA Views ).

I looked around for older XSA blogs etc and concluded to use the following syntax:

"<xxx>::ProfileActivityPerMonthCumulative"
as "ProfileActivityPerMonthCumulative"
keys generate local "PeriodUniqueID"
aggregates always;

The XSO service ( part of an MTA project ) builds fine and I can generate the ODATA metadata service. The other enitites work normal and return data.

However when I try to access the CV entity I am getting the following error message:

{error: 
{code: "400",
message: 
{lang: "en-US",
value: "Navigation to calc view expected after an Input path segment",
},
}
}

I have tried several ways to call the url - with the most likely ( according to older blogs ) to be:

/ProfileActivityPerMonthCumulative/?$select=ActivityPeriod,CreationsCount

but tried many other things ...

Also changed the type of the CV to DIMENSION .. well basically tried a lot of different things but I am always getting the above error. Looked for this error message here on the dev network , within knowledge base, ...

Anyone having any clue what this error means ?

Thanks,

Steven