Skip to Content
0
Aug 21, 2020 at 04:58 PM

How are members, in SAP BPC, accepted in a script?

57 Views

Hello,

This is more of a generic question that I am posting here with relation to an issue that I recently faced.

When we load data from BW to BPC, through the 'Load Transaction data from BW Infoprovider Delta', I understand that the data is being populated into BPC. If in the list of records that is being populated, if there are a few records that have characteristics/members that don't exist in BPC, what would be the ideal working of the DMP. Would it error out?

Because, the error I get when running the package is 'Error in default logic' and it shows the missing member in the messages.

In the above case, I have the following in the script -

*XDIM_MEMBERSET DIMENSION= %DIMENSION_SET% - What does this do?

What if there was no script written for this load? Then, how would the load work? Will the load still fail because of the missing member in SAP BPC?

How would I override this? Instead to run the default logic (Include script - below) only for the valid members of the dimension in SAP BPC ?

Please find the include program as below -

*SELECT(%ADTS_TO_FILTER_ACT%,[ID],AUDIT_FINANCIAL,FA_DERIVATION_ACTUAL = 'Y')
*SELECT(%ADTS_TO_FILTER_NON_ACT%,[ID],AUDIT_FINANCIAL,FA_DERIVATION = 'Y')


*FOR %CATEG% = %CATEGORY_SET%	
// 	*XDIM_MEMBERSET PROFITCENTER = %PROFITCENTER_SET%
	*XDIM_MEMBERSET CATEGORY = %CATEG%
	*XDIM_MEMBERSET AUDIT_FINANCIAL = %ADTS_TO_FILTER_ACT%,%ADTS_TO_FILTER_NON_ACT%
	*XDIM_MEMBERSET FUNCTIONALAREA = BAS(FUNCTIONALAREA)
	*START_BADI SUBSTITUTE_FUNCTIONALAREA
		CATEGORY = %CATEG%
		QUERY = ON
		WRITE = ON
		SKIP_FCST_ACTUAL_PERS = Y
		SKIP_BLINE_ACTUAL_PERS = Y
	*END_BADI
*NEXT

Thank you.


Regards,

Leonel S Mario