on 07-01-2015 11:38 AM
Hello,
As i was using Design studio 1.4 and recently upgraded to 1.5.
we are using HANA as backend and for one calculation view, input parameter(i.e IV_FILTERSTRING) is accepting some filter value from front end .
so we were passing value from design studio as
APPLICATION.setVariableValueExt("IV_FILTERSTRING","COMPANY IN (''ABC'')");
The same code is fetching values in DS 1.4 but in DS 1.5 am not getting any data from backend.
Note : i am passing the value ABC between two-two single quotes instead of between double quotes
Any help....?
Hello All,
Did any one checked by selecting only one value i.e selecting only one value from the dimension filter and passing to back end HANA system. I am facing same bug if am passing one value and if am selecting multiple value from dimension filter it is working fine.Find the attached screen shot for reference and kindly help..
Regards,
Arjun N
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi All,
Any update on Design Studio 1.5 service pack 2 release information..?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Arjun,
any news about this issue?
We have the same problem and maybe you've found a workaround in this period.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Arjun,
thank you for the update.
We found this discussion http://scn.sap.com/thread/3759697 that report the same issue and refer to a fix that will be released on week42 with DS 1.5 SP2.
Thanks
Salvatore
Hi Arjun,
Try passing the input parameter value via assigning a global parameter and pass a valid input parameter value as default to it.
Check if this thing work and do let me know.
Thanks,
Arpit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Arjun,
In DS1.5 there is a new property in the application - "Merge Prompts" which is set to "true" by default. You need to set it to "false".
This condition unmerges all the variables associated with the queries used in the application.
If you want to set a value to the variable you need to access that variable via the particular DataSource (in your scenario it would be the HANA view). Probably this might be the reason for the APPLICATION.setVariableValueExt("IV_FILTERSTRING","COMPANY IN (''ABC'')"); is not working.
Now the Code goes like this:
Datasource.setVariableValueExt(<variable>.<value>)
Just give a try & let me know..
Thanks
Kavya
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Kavya,
Thank you for the reply
But in our case if we are sending blank space to our calculation view input parameter(i.e APPLICATION.setVariableValueExt("IV_FILTERSTRING"," ") ; ) will give us the desired result.
But the problem is when we send some value with quotes(Because HANA accept input parameter as CITY IN (''ABC'') where CITY is a column in a table) .
And both Datasource.setVariableValueExt and APPLICATION.SetVariableValueExt is not working if we are sending in quotes.
Note:In our case HANA view will return all data if are sending blank space else filtered data.
Thanks
Arjun N
ok, now I see. the display in forum is not correct.
you use 2 x ' sign, not ".
what you can try is - open a prompt dialog, select the variable via dialog and call the method
getVariableValueExt("IV_FILTERSTRING") passing it into text. This is the content you need to use.
If this will not work, then customer incident is only way to figure out.
Karol
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.