Dynamic Filter in BPC Clear package

[former_member590808]

Hi,

We use the standard clear package to delete data before running Consolidation package in Consolidation environment. I wish to exclude 1 GL from getting its data deleted Z02060. When we execute a clear package with below selection it works properly.

For implementing the same, I am adding a dynamic filter 'ID<> Z02060' for ACCOUNTS dimension. It is giving a prompt more than 18014 members. and the package fails with no specific log details, just ACCOUNTS dimension selection.

My doubt is when we select <all> in ACCOUNTS dimension and dont add any filter there,still the package get processed. Why it is getting failed when am adding a filter and selection to it ?

Is there a workaround of how I can avoid deletion of a particular GL data when a CLEAR package is executed?

[former_member590808]

Hi,

I tried using a logic script. The process chain to be used is Default Formulas only, right ?Following is the logic script but none records are getting deleted.Attached is the log file. log.txt

*XDIM_MEMBERSET APL_TIME = %APL_TIME_SET%
*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%
*XDIM_MEMBERSET RPTCURRENCY = SGD,USD,INR


*WHEN APL_TIME
	*IS %APL_TIME_SET%
	*WHEN CATEGORY
		*IS %CATEGORY_SET%
		*WHEN APL_ACCOUNT
			*IS <> Z02060
			*REC(EXPRESSION = 0)
		*ENDWHEN
	*ENDWHEN
*ENDWHEN

[former_member186338]

Yes, default formulas chain can be used for running logic scripts. But any other script logic chain can be also used - no difference.

No records deleted? But I do not see any records to be deleted! No data screenshots...

Please read again and again: https://blogs.sap.com/2014/01/31/how-to-ask-questions-about-script-logic-issues/

P.S. The script itself is strange - a lot of useless lines:

*XDIM_MEMBERSET APL_TIME =%APL_TIME_SET% //useless! scoped automatically!
*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET% //useless! scoped automatically!
*XDIM_MEMBERSET RPTCURRENCY = SGD,USD,INR
*WHEN APL_TIME //useless! scoped automatically!
        *IS %APL_TIME_SET%  //useless! scoped automatically!
        *WHEN CATEGORY  //useless! scoped automatically!
		*IS %CATEGORY_SET%  //useless! scoped automatically!
                *WHEN APL_ACCOUNT
			*IS<> Z02060
			*REC(EXPRESSION =0)
                *ENDWHEN
	*ENDWHEN //useless
*ENDWHEN //useless

[former_member186338]

First option - save filter using "Manage Filter" button. Then in the advanced script use filter name to hardcode filter.

https://answers.sap.com/questions/679264/export-to-flat-file-package-select-members-issue.html

Second option - use script logic to clear *REC(EXPRESSION=0)