Master data loading from BW Issue

[former_member730217]

Hello Experts,

I have created some transformation and conversion for 0GL_ACCOUNT for attr/text.

They are getting validated properly.

But when i run the package, I am getting the error on account type showing that A_ is invalid member.

How does A_ comes into picture when i am mapping ID'd to account type.

Following is the transformation file.

*MAPPING

ACCTYPE=ID

ID=*STR(A_)+ID

BW_ACCOUNT=ID

BW_CHRT_ACCTS=0CHRT_ACCTS

FIN_STMT=*IF(0INCST_FLAG=*STR(X) THEN *STR(PL); 0INCST_FLAG=*STR(Y) THEN *STR(PL); 0BAL_FLAG=*STR(X) THEN *STR(BS);ID)

RATETYPE=*IF(0INCST_FLAG=*STR(X) THEN *STR(AVG); 0INCST_FLAG=*STR(Y) THEN *STR(AVG); 0BAL_FLAG=*STR(X) THEN *STR(END);ID)

ROW_SOURCE=*NEWCOL(BW)

*CONVERSION

ACCTYPE=BW_ACCOUNT_CONV.XLS!ACCTYPE

ID=BW_ACCOUNT_CONV.XLS!CONVERSION

RATETYPE=BW_ACCOUNT_CONV.XLS!RATETYPE

FIN_STMT=BW_ACCOUNT_CONV.XLS!FIN_STMT

BW_CHRT_ACCTS=BW_ACCOUNT_CONV.XLS!BW_CHRT_ACCTS

Awaiting for kind reply.

Regards,

NJ

[RamanKorrapati]

Hi Jain,

Actually why you using options like this way? are you one BPC10 NW?

ACCTYPE=ID

ID=*STR(A_)+ID

BW_ACCOUNT=ID

BW_CHRT_ACCTS=0CHRT_ACCTS

How your loading data to ACCTYPE? from bw or they conversion rouitne?

Actually to load GL Account data no need to mentioned any bw info objects. just use below

ID=0CHRT_ACCTS+ID.

Error is here. ID=*STR(A_)+ID what is the pupose of this?

Thanks

[former_member730217]

HI Raman,

I needed that "A_" as prefix instead of 0CHRT_ACCTS as a prefix.

Now i have successfully loaded the the actual GL's using selection option.

But how to pull the text node which are maintained using some alphanumeric ways and further how to pull the hierarchy in this case.

regards,

NJ

[RamanKorrapati]

While loading attribute data itself you may be loaded text data also. have you seen bpc account dimension data. its loaded with ID and description.

for hierarchy, while loading attribute itself at set selection, hierarchy tab you need to select bw hierarchy name and below option set filters attribute Or hierarchy need to be selected.

For Options.

NODENAME=NODENAME

HIER_NAME=HIER_NAME

PARENT=PARENT

ORDER=ORDER

To prefix A_ for your gl account then you may need to use conversion file.

Thanks

[former_member730217]

while loading attr/text data...i selected hier in selection and all GL's at child level got loaded into dimension. I am facing issue loading data at parent level.

Regards,

NJ

[RamanKorrapati]

mean have you loaded hierarchy data by using hierarchy related DM Package?

[Former Member]

Hi Nilesh,

I assume you are referring to text nodes in hierarchy which you are unable to load.

For that when you are loading master data, in set selection you have to check mark the "Import text nodes selection",( in the same screen where you select hierarchy).

Let me know if this helps.

Also providing you link which tells you about how to load master data and hierarchy.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/c02d0b47-3e54-2d10-0eb7-d722b633b...

Regards,

Raman.

[former_member730217]

NO Raman ..if possible can you share ur email id..so tht we can chat and you can help me out in this issue.

[RamanKorrapati]

My details you can get from my profile.

Please  load hierarchy data by using hierarch related DM package(import master data hierarchies from bw info object)and then check later. it will loads nodes data also.

if you get any issues revert back to me.

[former_member730217]

Hello Raman,

I am facing issue while loading Master data text/attr and not hierarchy.

while loading from 0GL_ACCOUNT,  I am getting  below error :

"Member 'A_' attribute value is invalid: 'ACCTYPE' = ''."

As you can find the transformation file in the thread above.

Regards,

NJ

[RamanKorrapati]

previous reply you said it was loaded and problem with hierarchies?

as my first replys said your mappings are wrong.

use as like this.

ID=0CHRT_ACCTS+ID.

at conversion file you can use and replace chart of account by A_* prefix.

Thanks

[former_member190501]

Hi,

Can you share your conversion file of BW_ACCOUNT_CONV.XLS!ACCTYPE.

Thanks,

Raju