HANA OData service issue

[former_member213759]

Hi Experts,

I have created an xsodata file to expose my HANA analytical views to my UI5 application.

The xsodata has nested views making use of navigation to expose data of two views based on a common key MATNR.

However, when i run the xsodata url in my browser for one of the analytical views, I get the following error

"<message xml:lang="en-US">Service exception: [2048] column store error</message>"

Also, could you please suggest how can I pass input parameters to this xsodata url so that i can fetch material header and related plant information based on the input search string.

The url is :

<server>/ABC/services/product_details.xsodata

I would like to pass MATNR and PRODH in my input parameters.

<service xmlns:atom="http://www.w3.org/2005/Atom" xmlns:app="http://www.w3.org/2007/app" xmlns="http://www.w3.org/2007/app" xml:base="<server>/ABC/services/product_details.xsodata/">

<workspace>

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

<collection href="ProdHdr">

<atom:title>ProdHdr</atom:title>

</collection>

<collection href="Plant">

<atom:title>Plant</atom:title>

</collection>

</workspace>

</service>

Any help will be appreciated.

Thanks,

Sakshi

[jeff_collier]

I received that error message when I was not properly identifying the calc view in my .xsodata file. I had this:

"_SYS_BIC"."collierosity.model/ACCOUNT2_CALC" as "Account2Calc" keys generate local "ID" parameters via entity "AccountInputParams" results property "Results";

I resolved the error by changing to this:

"collierosity.model::ACCOUNT2_CALC" as "Account2Calc" keys generate local "ID" parameters via entity "AccountInputParams" results property "Results";

My working URL is this:

http://[hostname]/[path]/collierosity.xsodata/AccountInputParams(searchText='Energy')/Results?$forma...

[former_member38967]

check whether there are some data in 'sap.hba.ecc/Date'
view and 'M_TIME_DIMENSION' table by running following two queries?
SELECT count(*) FROM "_SYS_BI"."M_TIME_DIMENSION";
SELECT count(*) FROM "_SYS_BIC"."sap.hba.ecc/Date";

regards
Sushi