(Issue) import members in Dimensions in BPC 10.1; DESCRIPTION column doesn't import

[Former Member]

Hello community,

I have following ussue:

I am importing members in different dimensions like ACCOUNT, TIME, CATEGORY and so on. The import of member data in form of .csv works fine with EPM Data Manager through transformation. The only Issue is that description column of members do not import.

In Transformation I take always:

EVDESCRIPTION=EVDECRIPTION

I have also tried to take:

EVDESCRIPTION =DESCRIPTION

But in both cases descriptions don't import in dimensions.

Does someone have an idea how I can solve this problem?

Thanks you for your support!

[Former Member · Accepted solution]

Hi Nazim,

Which package did you run?

You need to run a different package to load description from flat file.

Andy

[Former Member · Accepted solution]

Hi Andy,

I tried to use the /CPMB/IMPORT_DESCRIPT but it shows an error like you can see in ScreenShot. Is that a right package? Should I write something in *CONVERSION part in transformation file?

Regards,

Nazim

[Former Member · Accepted solution]

Hi Nazim,

That is the correct package, in your transformation file you need a line for LANGU = *STR(EN) or the language you are using.

Andy

[Former Member · Accepted solution]

Hi Andy,

I use german descriptions. Where do I enter a line LANGU = *STR(EN) or may be LANGU = *STR(DE) in a transformation file.

Do I need to enter all columns in *Mapping section or only EVDESCRIPTION = *COL(2) is enough?

Sorry for so many questions, I am only a beginner in BPC.

Thanks a lot!

[Former Member · Accepted solution]

I got it 😉

Thank a lot for your help

[Former Member · Accepted solution]

Cool, glad it worked

[andrei_chirica · Accepted solution]

Hi guys,

I want to know how I can to import dimension members from CSV file. Please, give me a complete tutorial with this task.

Thank you,

Andrei

[Former Member · Accepted solution]

Hi Andrei,

here ist the Link to a full tutorial!

Cheers,

Nazim

[former_member186338]

Hi Nazim,

And what do you have in csv file? What is the full text of transformation file?

Vadim

[Former Member]

Hi Vadim,

thank you for your reply!

Lets take as example the Dimension PRODUCT. This Dimension has in .csv following Columns and a lot of members:

ID;EVDESCRIPTION;PARENTH1;KNOTEN;GEWICHSTEINHEIT;VERPACKEINHEIT

1000000;Produkt A;Hierarchie 1;;KG;KAR

10001;Produkt B;Hierarchie 1;;KG;KAR

...;...;...;...;...

I imported this .csv through transformation in data manager into BPC 10.1 in a dimension created by myself. Everything worked fine, except of 2nd column (see above) - EVDESCRIPTION.

The full text of transformation file in data manager is as follow:

*OPTIONS

FORMAT = DELIMITED

HEADER = YES

DELIMITER = ;

AMOUNTDECIMALPOINT = .

SKIP = 0

SKIPIF =

VALIDATERECORDS=YES

CREDITPOSITIVE=YES

MAXREJECTCOUNT=

ROUNDAMOUNT=

*MAPPING

ID=ID

EVDESCRIPTION=EVDESCRIPTION

PARENTH1=PARENTH1

KNOTEN=KNOTEN

GEWICHTSEINHEIT=GEWICHTSEINHEIT

VERPACKEINHEIT=VERPACKEINHEIT

*CONVERSION

I hope this information can provide more details to the issue,

[former_member210696]

Hi Nazim,

Can you try with below once -

ID=ID

EVDESCRIPTION=*COL(2)

PARENTH1=PARENTH1

KNOTEN=KNOTEN

GEWICHTSEINHEIT=GEWICHTSEINHEIT

VERPACKEINHEIT=VERPACKEINHEIT

Regards,

Ashish

[Former Member]

Hi Ashish,

no, unfortunately the description column remains empty but transformation works well without any error.

Probably it is a bug in BPC 10.1 that has to be fixed unless you or someone else have another idea 🙂

Regards,

Nazim

[former_member210696]

You mean you have tried with *COL and it is failing again?

What SP version are you on? May be you are right about this being a bug, so you may try upgrading your SP if not on latest.

Regards,

Ashish

[Former Member]

Yes, I tried with *COL, the transformation works well without any error but description column in BPC 10.1 remains empty.

I have following version:

--> EMP-Tool

Version 10.0 SP 17 .NET 4

Regards,

Nazim