cancel
Showing results for 
Search instead for 
Did you mean: 

Documentation for using Formulas in PaPM - overview of functions, operators, ...

joost_peeters2
Participant
0 Kudos

Hello,

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.

Many thanks,

Joost

Accepted Solutions (1)

Accepted Solutions (1)

emanuele_fumeo
Advisor
Advisor
0 Kudos

Hi Joost,

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.

Emanuele

joost_peeters2
Participant
0 Kudos

Thanks a lot Emanuele, that is indeed the information I was looking for.

Answers (0)