how to Implement complicated logic in planning function?

[dongun_kang]

Hi experts,

We have been implementing complex business logics with calculation views over the past few months.

However, due to various reasons and changes in development direction, we have to re-implement the logics implemented as calculation view as planning function.

The problem is that complex logic, such as join clauses, partition by clauses, group by clauses and the free addition of new temporary-column, is very difficult to re-implement as planning function.

Also, frequent calls of function module cause low performance.

A better alternative would be to run calculation view on copy function.

But, BPC experts on our project say this is not a proper way with BPC perspective.

i want to ask your opinion on this situation.

thanks.

[gregor_dieckmann · Accepted solution]

Hi,

please check the list of 'How to Guides':

https://blogs.sap.com/2016/06/28/sap-how-to-guides-for-bpc-embedded-pakbw-ip-and-analysis-for-office...

Regards,

Gregor

[dongun_kang · Accepted solution]

Sorry, but most links are 'not found', especially "How to... Use SQLScript for Planning Functions in PAK"...