cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Load ACCOUNT without text

Former Member
0 Kudos
420

Hi BPC Experts,

I have a problem in BPC with GL_ACCOUNT in reports and when I load data from SAP BW.

I created a report in BPC with the dimension GL_ACCOUNT view for hierarchy and description, the report show GL_ACCOUNT like IDs.

This is the Transformation File of Attr and Text what I load gl_account.

*OPTIONS

FORMAT = DELIMITED

HEADER = YES

DELIMITER = ,

AMOUNTDECIMALPOINT = .

SKIP = 0

SKIPIF =

VALIDATERECORDS=YES

CREDITPOSITIVE=YES

MAXREJECTCOUNT=

ROUNDAMOUNT=


*MAPPING

ID =  0CHRT_ACCTS+ID

ACCTYPE = *NEWCOL(AST)

CHRT_ACCTS  = 0CHRT_ACCTS

BAL_FLAG =  0BAL_FLAG

INCST_FLAG = 0INCST_FLAG

ZSCHLW = ZSCHLW

ZALTKT = ZALTKT


*CONVERSION

BPC Web Administration:

I loaded GL_ACCOUNT dimension with infoobject 0gl_account

I need to load description of 0GL_ACCOUNT to GL_ACCOUNT dimension. Something wrong am I do? What can I do?

Regards,

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Pablo,

You are using 10 or 10.1 NW?? There are lots of similar posts on scn......should have searched first..

Like...

etc...you will find many more on scn.

What are the Set selections you are giving while loading GL_ACCOUNT master data? Have you followed the standard documentation on loading master data and hierarchies?

DELIMITER = TAB!

Regards,

JP

former_member186338
Active Contributor
0 Kudos

Looks like language don't match!

Former Member
0 Kudos

hi Vadin,

I think language Spanish doesn't select, because when I run package "Import Master Data Attrib and Text InfoObj" and click in Set Selection I have pop up

Please select at least one language

Always was selected only S Español in language.

What's the solution to load text in spanish to master data?

Regards.

former_member186338
Active Contributor
0 Kudos

It will load Spanish description, but to see it you will need to select Spanish for EPM!

former_member186338
Active Contributor
0 Kudos

P.S. And use Long Text!

Former Member
0 Kudos

I select Spanish in EPM always! 

I'll try using Long Text.

former_member186338
Active Contributor
0 Kudos

On your screenshots I can see English EPM member selector and English WEB administration!

Former Member
0 Kudos

Can you check if your BW InfoObject from which you load is setup as Language dependent and if text is in language S.

Cheers.

Former Member
0 Kudos

Hi Pablo,

Please check whether the Description is uploaded properly to BW by displaying the data for G/L Accounts (Texts).

Thanks

Krishna GB