You have percentile function in HANA.PERCENTILE_DISC and PERCENTILE_CONT.Check the follow link for more detailshttps://help.sap.com/viewer/7c78579ce9b14a669c1f3295b0d8ca16/Cloud/en-US/d8394326f65e4fd9aa5a9750755b4665.html
Ok.So basically you have to create a derivate table where you will use the prompt variable from Universe and the select which I mentionedExample:Let's suppose you created a prompt for Currency into your Universe then Derivate table must be:SELECT *FR...
It is not very clear:DECISION_UPDATE is a table or a store procedure?If it is a store procedure did you activate this store procedure after you created?Did you provide access to _SYS_REPO user to schema with tables used into store procedure?grant sel...