cancel
Showing results for 
Search instead for 
Did you mean: 

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

param0308
Participant
0 Kudos

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

Accepted Solutions (0)

Answers (4)

Answers (4)

param0308
Participant
0 Kudos

Hi,

I have used the alternative way to fulfill my requirement.

Thanks for help.

Regards

Rajender

MustafaBensan
Active Contributor
0 Kudos

Rajender,

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

Thanks,

Mustafa.

Former Member
0 Kudos

Rajender,

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

MustafaBensan
Active Contributor
0 Kudos

Hi Rajender,

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

Regards,

Mustafa.

MustafaBensan
Active Contributor
0 Kudos

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

param0308
Participant
0 Kudos

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

TammyPowlas
Active Contributor
0 Kudos

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

param0308
Participant
0 Kudos

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

MustafaBensan
Active Contributor
0 Kudos

Hi Rajender,

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

TammyPowlas
Active Contributor
0 Kudos

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