It is a bit tricky to import member descriptions (System name; EVDESCRIPTION) from flat file (.csv) to BPC 10.1.

I spend a lot of time on finding the solution how to import descriptions into BPC 10.1. This Document may help you by doing that and hopefully save you a lot of time 😉

Step 1:

Make sure that description column in your flat file is in a 2nd place otherwise report package in data manager won’t be able to import descriptions into BPC 10.1

Step 2:

In your transformation file you need to put following transformations:

EVDESCRIPTION=*COL(2)

LANGU=*STR(EN)

Unbenannt.PNG

EN stays for English

For german choose for example DE

Step 3:

Choose Report Package /CPMB/IMPORT_DESCRIPT and undertake your transformations.

Unbenannt.PNG

If you have questions on this topic you can contact me at any time.

To report this post you need to login first.

7 Comments

You must be Logged on to comment or reply to a post.

    1. Tomasz Slodkowki

      Hi,

      you have to check the tables UJA3_LANGU. It is possible that the English version has a shortcut E, for example, Polish version is L.

      The file instead EN must specify when E.

      Regards.

      (0) 
      1. Sebastian Montero

        Hello Tomasz,

        Indeed, the English Langage is an E. The thing is that I am importing the descriptions from BW and when I include the line LANGU=*STR(E). I got an error that says that Dimension Attribute doesn’t exist.

        Any idea how can I bring the Descriptions directly fromo BW?

        Regards.

        (0) 
        1. Vadim Kalinin

          You don’t need to include LANGU line when loading from BW.

          But to my mind if you have Spanish description in BW it will go to Spanish description in BPC…

          (0) 
  1. ajay 6044

    Dear Nazim,

    Very good information ,thanks a lot for your valuable share.

    My scenario:


    I am loading description from flat file(csv format)

    I have two languages like (English (E) and Japanese (J) ) how can I load both the descriptions simultaneously from one file. in one file I have both the id’s description I want to load in one stretch. please advise

    hope you understood my doubt.

    Regards,

    Ajay

    (0) 

Leave a Reply