BPC NW 10.0 Script Logic - appending the records

[Former Member]

Hi Gurus,

i am trying to copy the data from DEV to ACT, below is the logic

*WHEN ORG
*IS IN001
*WHEN DEV
*IS DEV_PA
*WHEN FUNC_PL
*IS IS25
*REC(FACTOR = 1, DEV = "DEV_TA",INPUT_TYPE = "BI_LOAD",VERSION_PL = "ACT")
*ELSE
*REC(FACTOR = 1, DEV = "DEV_CA",INPUT_TYPE = "BI_LOAD",VERSION_PL = "ACT")
*ENDWHEN
*ENDWHEN
*ENDWHEN

*WHEN ORG
*IS IN001
*WHEN DEV
*IS DEV_TA
*WHEN FUNC_PL
*IS IS26
*REC(FACTOR = 1, DEV = "DEV_TA",INPUT_TYPE = "BI_LOAD",VERSION_PL = "ACT")
*IS IS27
*REC(FACTOR = 1, DEV = "DEV_TA",INPUT_TYPE = "BI_LOAD",VERSION_PL = "ACT")
*ELSE
*REC(FACTOR = 1, DEV = "DEV_CA",INPUT_TYPE = "BI_LOAD",VERSION_PL = "ACT")
*ENDWHEN
*ENDWHEN
*ENDWHEN

what is expected is in the else condition, it should write both the else records should add in DEV_CA (80+40)instead records are overwritten(only 80 in J20).

is there a *append statement that we can use in script logic?

Thanks in advance

BK

[former_member186338 · Accepted solution]

First: B K is not allowed due to forum rules

Use your real name instead! Moderator will be alerted!

Second:

Aggregation happens in a single WHEN/ENDWHEN loop!

[Former Member]

Hi Vadim,

thanks for your quick reply. it worked with single block.

Balakrishna

[former_member186338]

After finishing each WHEN/ENDWHEN block BPC will automatically commit all created records into the cube. That's how it works!