Skip to Content
0

HANA views I/P parameter consumption in sap design studio . not at all working

Feb 05, 2017 at 05:06 PM

227

avatar image

Hi experts,

We have a view in which we created an input parameter(multiple values allowed) and applied with match and in function.

(in ("KOSTL",$IP_cost_centre$)) or (match("KOSTL",$IP_cost_centre$))

when we run the view in HANA studio with below input values * and 12100 , 17222, we get correct result without any error.

When we consume the same view in Design studio 1.5 , and pass the values through prompt screen, the output in initial view does not appear and shows error in sql script

  • SQL Error: SAP DBTech JDBC: [2048]: column store error: search table error: [6968] Evaluator: syntax error in expression string;expected TK_ID,parsing "(\"GJAHR\" ='2016') and (in (\"KOSTL\",[here]*))"

BUT BUT when we assign this data source to chart the correct data appears.

Again when I try to select the the data selection for the chart again I see the same SQL script error.

BUT BUT the data is still visible in chart.

WHY WHY WHY it behave like this...it is a bug or am I missing something?

SECOND THING

I have another data query(FILTER_DIMENSIONS), source or provider(what ever you call) in the same DS application.

SO I use this query with filter line and on selection of values , I call a code to apply the values in first query input paramters.Code is written in data source event "On Result Set Changed" .

var filter_costcentre = FILTER_DIMENSIONS.getFilterExt("Cost_Centre");APPLICATION.setVariableValueExt("IP_cost_centre", "''" + Convert.replaceAll(FILTER_DIMENSIONS.getFilterExt("Cost_Centre"), "; ", "'',''") + "''");


** value generated by code is ''11100'',''11700''

BUT BUT BUT the application throws error for above code

  • Second attempt to execute event handler "On Result Set Changed" for data source FILTER_DIMENSIONS was rejected, because it can cause an execution cycle.

SO the query does not update the chart result. :(

Now it is only happening with match and in function of HANA.

Please help in this. if cannot please forward it to who can.

Regards

Rajender

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Tammy Powlas
Feb 05, 2017 at 09:37 PM
0

It looks like you are using the JDBC connection

Please see this note https://launchpad.support.sap.com/#/notes/2421490/E which says JDBC connection has been deprecated - and you should be using the http connection

Show 3 Share
10 |10000 characters needed characters left characters exceeded

Hi Tammy,

Thank you for reply.

I tried to follow one post to configure the HTTP connection, but as per post I dont see the button to add connection in Design studio preferences->backend connection.

Design Studio 1.5 : Connect to SAP HANA via HTTP

We have delivery unit

HCO_INA_SERVICE

but we don't have delivery unit SAPU5_1.tgz. Is it problem?

Will the HTTP connectio will solve my problem

0

Hi Rajender,

Are your running the minimum required HANA level of SP9 as per the referenced blog?

0

This is covered in this note (http connection) https://launchpad.support.sap.com/#/notes/2193057/E

0
Mustafa Bensan Feb 06, 2017 at 12:05 AM
0

In addition to Tammy's suggestion, I would strongly recommend that you upgrade to Design Studio 1.6.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Mustafa,

Thank you for reply.

We have HANA sp9 rev-97 and BOBJ 4.1 Support Pack 6.

Can we go for design studio 1.6? because I heard some of the feature does not work in 1.6

Regards

Rajender Singh

0
Mustafa Bensan Feb 06, 2017 at 04:23 AM
0

Hi Rajender,

Which specific features are you concerned about not working in Design Studio 1.6?

Regards,

Mustafa.

Share
10 |10000 characters needed characters left characters exceeded
Rajender Singh Mar 02, 2017 at 07:07 PM
0

Hi,

I have used the alternative way to fulfill my requirement.

Thanks for help.

Regards

Rajender

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Rajender,

So that others can benefit too, can you share the alternative approach you implemented to fulfil your requirement?

Thanks,

Mustafa.

0
Former Member

Rajender,

Could you please share details of the alternative approach which you have done. Thanks.

0