Basic Questions-BPC

[Former Member]

Hello All,

I am very new in BPC. I have lot of questions it will be of greate help if you could give your inputs

01. in C_ACCT dimension we have one column "Ratetype" which has value of (AVG, END......and so on), each GL account has to have this field updated. my question is from where we get this value when we are loading the data from BW to BPC? if I am not wrong then we load the 0GL_ACCOUNT data to C_ACCT (as like master data in bw), and 0GL_ACCT dosent have have ratetype.

in R_ACCT we maintain this we mention this (    ENDFLOW , END, AVG) but seems we maintain here manually.

[JohnL]

Hi Priyank, most likely you'll need a conversion file (referenced in a transformation file) to populate this field. Have you reviewed this already? http://scn.sap.com/thread/2119475 http://scn.sap.com/docs/DOC-35363 https://scn.sap.com/thread/3459839 Can you use 0BAL_FLAG and 0INCST_FLAG to determine if it should be a AVG or END  ? Note: please search SCN prior to posting your questions. Thanks, John

[former_member186338]

Hi Priyank,

Please talk to finance people, they will explain you the difference between P&L and BS accounts and what rate type has to be used - AVG, END...

Vadim

[Former Member]

Hello Vadim,

Good Morning..

Ok, so i am assuming that these rate type will be updated from ECC.

if this is right, then i have other question.

we load the Trial balance from FI_GL_10 Data source to BW and then upload it to BPC ( in legal model), here from this data source we dont get the RATETYPE.

so my question is, is/are there any other data source(s) which has to be loaded to BW in order to feed the data to BPC?

Thanks

Priyank

[former_member186338]

Do you understand the difference between P&L and BS accounts?

Vadim

[Former Member]

RATETYPE will be taken from Account type Dimension.

[Former Member]

Hello,

yes, i did understnd the difference.

BS has assets and liablity and PL has Income and Expenses.

[Former Member]

Hello Gersh,

when we are loading the data from bw how RATETYPE gets updated?

[former_member186338]

PL - periodic - turnover for the period - AVG rate - average rate for the period.

BS - YTD - result at the end of the period - END rate - rate in the last day of the period.

Vadim