Skip to Content
0

BPC Transaction data load

Oct 21, 2016 at 04:54 AM

159

avatar image

Hii,

I am trying to load transaction data from BW info provider. Job is successfully completed and data is uploaded to BPC system.

this is the field mapping for the conversion file,

ACCOUNT=0CHRT_ACCTS+*STR(_)+0CLIENT+*STR(_)+ZGL_ACCNT(5:10) AUDIT_TRAIL=*NEWCOL(INPUT_ADJ) CURRENCY=*NEWCOL(LC) ENTITY=*STR(C1_)+0COMP_CODE

FLOW=*IF(0BAL_FLAG=*STR(X) THEN *STR(F99); *STR(F10))

but after checking the balance i have found that figures were also updated in Flow F15

Can anyone tell , why the system is updating the same figure both in F99 and in F15

According the the transformation file if the Gl account is a balance sheet account , the balance should updated in F99 only.

Regards

Shihab

zipps.png (8.0 kB)
10 |10000 characters needed characters left characters exceeded

Hi Shihab

use the primary tags going forward:

SAP BusinessObjects Planning and Consolidation, version for the Microsoft platform

SAP BusinessObjects Planning and Consolidation, version for SAP NetWeaver

EPM Add-In for Excel

Thank you

0

BPC NW due to:

ACCOUNT=0CHRT_ACCTS+*STR(_)+0CLIENT+*STR(_)+ZGL_ACCNT(5:10)

0
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Shihab M S Oct 21, 2016 at 06:21 AM
0

Hi,

I have got the reason,

on the bassis of this business rule the value is updated in flow F15


cfkyi.png (10.3 kB)
qhytj.png (11.0 kB)
Share
10 |10000 characters needed characters left characters exceeded
Priyanka Jagtap Oct 21, 2016 at 06:05 AM
0

Hi Shihab,

You have to analyse the reason behind this...since we dont have your system to check! Just based on transformation you wont get the answer why? Check the BW data, selections.....data cross section against which your checking. Is there any default logic running during the data load etc?

And you have tagged the question to a wrong community! It should be NW not MS!

Regards,

JP

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hii,

Can u just tell me , the user of the Busines Rule Flow_Calc

Regards

Shihab

0

Sorry...I cannot explain the use of this business rule. Better to ask your functional consultant! Thanks!. If your query is answered, please close the discussion then!

Regards,

JP

0