Logic script to copy only non null records

[former_member590808]

Hello

We have 2 categories Revision 1 and Revision 2 . User requirement is if data is present in Revision 2 then copy/write data from Revision 2 to Final_Plan category and if Revision 2 is blank then copy/write data from Revision 1 to Final_Plan category. Is there a way we can implement this via BPC logic script because end users don't want to execute Copy package every time. Do we have keywords like Null or blank here in MDX scripts to implement this in BPC?

[former_member186338 · Accepted solution]

First copy everything from Revision1 using script logic WHEN/ENDWHEN

Second - copy from Revision2 using script logic WHEN/ENDWHEN

In the second step - missing records will not overwrite Revision1

P.S. But records with 0 will overwrite!

[former_member590808 · Accepted solution]

Can we copy comments as well from logic script ?

[former_member186338 · Accepted solution]

nehayadav0911

"Can we copy comments as well from logic script ?"

There is no support to copy comments in the script, only chain to run as DM package.

But you can write a CUSTOM logic badi to copy comments and execute it in script logic