Skip to Content

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Feb 05, 2017 at 09:37 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 06, 2017 at 12:05 AM

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

    Add comment
    10|10000 characters needed 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

  • Feb 06, 2017 at 04:23 AM

    Hi Rajender,

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

    Regards,

    Mustafa.

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 02, 2017 at 07:07 PM

    Hi,

    I have used the alternative way to fulfill my requirement.

    Thanks for help.

    Regards

    Rajender

    Add comment
    10|10000 characters needed characters exceeded