02-05-2017 5:06 PM - edited 01-21-2024 10:06 PM
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
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
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
Hi,
I have used the alternative way to fulfill my requirement.
Thanks for help.
Regards
Rajender
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rajender,
Which specific features are you concerned about not working in Design Studio 1.6?
Regards,
Mustafa.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
In addition to Tammy's suggestion, I would strongly recommend that you upgrade to Design Studio 1.6.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
This is covered in this note (http connection) https://launchpad.support.sap.com/#/notes/2193057/E
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.