I am making changes to an existing PaPM development, but am struggling to debug my code, or to even know which functions and operators are available.
For instance, I am making use of the PARTITION BY keyword in one of my formulas, but I am only aware of this keyword because this was used in another function. I cannot find any documentation in the tool or online explaining what are the different possibilities.
Am I missing something? Should I be looking in the HANA documentation for this kind of function?
Can anyone tell me where I can find documentation for the use of function/operators/keywords inside PaPM functions? It also doesn't appear in the SAP training course PAPM10 as far as I know.
SAP PaPM leverages SAP HANA platform to perform calculations, and therefore functions are translated into SQL statements to be executed. Formulas that you are using to configure your calculations are made of the keywords available in the SQL dialect of the HANA platform.
For example, you could use this help.sap.com page as reference: https://help.sap.com/docs/SAP_HANA_PLATFORM/4fe29514fd584807ac9f2a04f6754767/20a61f29751910149f99f03...
Please refer to the page related to the specific HANA version that you are using.
Hope it helps.