BPC 10 NW Deletion of Records

[vinoo_gan]

Hi All

I’m unable to use default clear package as we have thousands of records the package fails, I would like to build a script logic which does this work. Records below are sample, I don’t want the UNWBS records NOT to BE DELETED, I’m struggling to find a NOT condition within the WHEN, below program delete all records

PLAN_INPUT  621  PLAN  WBS1 CC1 9000

PLAN_INPUT  621  PLAN  UNWBS CC1 900

XDIM_MEMBERSET CATEGORY = PLAN

XDIM_MEMBERSET AUDITID =PLAN_INPUT

*SELECT(%WBS_A%, "ID", "WBS", "[PRIORITY] = '1','2','E'")

*XDIM_MEMBERSET WBS=%WBS_A%

*WHEN PT_ACCOUNT

*IS *

*REC(FACTOR=0)

*ENDWHEN

please advise

Thanks

Gan

[Mark_P_Burke · Accepted solution]

If UNWBS is in the WBS dimension (?) and since you are including all PT_Account's in your WHEN clause, you could switch your WHEN clause to scan through records based on WBS dimension

WHEN WBS

*IS "UNWBS"

*REC(FACTOR=1) or comment this line out by leaving it blank or with comment // do nothing

*ELSE

*REC(FACTOR=0)

*ENDWHEN

this should zero out all records except WBS=UNWBS

[Shrikant_Jadhav]

Hi Vinoo,

Try this -

XDIM_MEMBERSET CATEGORY = PLAN

XDIM_MEMBERSET AUDITID =PLAN_INPUT

*SELECT(%WBS_A%, "ID", "WBS", "[PRIORITY] = '1','2','E'" AND [ID]<> UNWBS )

*XDIM_MEMBERSET WBS=%WBS_A%

*WHEN PT_ACCOUNT

*IS *

*REC(FACTOR=0)

*ENDWHEN

Shrikant

[Mark_P_Burke]

This question is in EPM forum...the best location for this long-term is here in the BPC NW forum

http://scn.sap.com/community/epm/planning-and-consolidation-for-netweaver