May 16, 2016 at 04:44 PM

HANA XS xsodata unsupported parameter error

609 Views

Hi experts!

I have built a Calculation view having 2 Input Parameters of type NVARCHAR 50.

The calculation view works fine with the parameters and I get the expected results.

In my calculation view I have a FilterExpression based on my Input Parameters ("GroupCode"='$$IP_GroupCode$$'or "Country"='$$IP_Country$$')

SELECT TOP 1000

SUM("Balance") AS "Balance",

"CardCode",

"CardName",

"Country",

"GroupCode",

"GroupName"

FROM "_SYS_BIC"."tests.Trinidad.oDataParams.views/BPs_CA"

(placeholder."$$IP_GroupCode$$"=>'100',

placeholder."$$IP_Country$$"=>'US')

GROUP BY "CardCode", "CardName", "Country", "GroupCode", "GroupName";

I need to create an xsodata service based on my calculation view and I have added the following in my xsodata file:

service

{

"tests.Trinidad.oDataParams.views::BPs_CA" as "bps"

key generate local "ID"

parameters via entity "IN";

}

But when trying to activate the xsodata file I get the following errors for each one of the parameters of my calculation view:

Unsupported parameter "IP_GroupCode" in object "tests.Trinidad.oDataParams.views::BPs_CA".

Unsupported parameter "IP_Country" in object "tests.Trinidad.oDataParams.views::BPs_CA".

I have find out a similar post in this forum but without a solution. It says Text and Blob are not supported but what about NVARCHAR??? :

Do you know what can be the reason of this error message? Something wrong in my xsodata or calculation view definition?

Thanks,

Trinidad.