BPC transaction data load - Zero records

[Former Member]

Hi Experts,

I have successfully loaded master data + Hierarchy to the system. When I try to load the transaction data from the source system, i get the below log.

	Validate has successfully completed
	ValidateRecords = YES
	No records are returned from 0FIGL_C10
	Reject count: 0
	Record count: 0
	Skip count: 0
	Accept count: 0

Below is my mapping,

*MAPPING

P_ACCOUNT=0CHRT_ACCTS+0GL_ACCOUNT

P_RPTCUR=*NEWCOL(LKR)

P_ENTITY=0COMP_CODE

P_CATEGORY=*IF(0VTYPE(1:3) = *STR(010) THEN *NEWCOL(Actual); ID(1:3) = *STR(020) THEN *NEWCOL(Budget01))

P_TIME=0FISCPER

SIGNEDDATA=0DEB_CRE_LC

I tried to map P_CATEGORY as P_CATEGORY=*NEWCOL(Actual) but gives the same log.

Thank you

[former_member186338]

"No records are returned from 0FIGL_C10" - do you have records here ?

What is the selection?

....

[Former Member]

Hi Vadmin,

yes there plenty of records in 0FIGL_C10. When validating the file, the selection fields i have given are,

Company code

Currency type

Fiscal year

Thank you

[former_member186338]

Selection screenshots, please!

[Former Member]

[former_member186338]

Still check data in RSA1 for this selection...

Please show the dimension list of the target BPC model

[Former Member]

Hi Vadmin,

Thank you for your inputs. My issue was resolved. I checked the selection again and gave value type as a dimension.

BR

Pubudini