Functions like Case, If, All, AllPrevious Over etc. all work in Spotfire for in-database connection to SAP HANA. But they are not shown in the list of functions available.
Our users need an easy to use interface without getting into details of what is available in Spotfire or SAP HANA. If Spotfire lists down all the functions and instructions in its drop down menu interface, it is easy for them to choose and use that feature just as it displays them for In-Memory/On demand data tables.
Sorry, my previous comment was ment to be for https://spotfireideas.tibco.com/ideas/TS-I-5563
Most important for us are