Skip to Content
0
Former Member
Aug 04, 2016 at 04:00 PM

How to load hierarchy nodes descriptions in several languages, from BW to BPC?

275 Views

Hello everyone,

I'm trying to load hierarchy nodes descriptions in both english and spanish languages.

I'm sure there's something wrong in my transformation / conversion files, because BPC only recieves the spanish descriptions for the nodes, even when I'm selecting both languages during the prompt for loading.

The same transformation file is valid for loading the base members (both languages are being loading in their descriptions).

Here you can see the transformation file and conversion file I'm using:

*OPTIONS FORMAT = DELIMITED HEADER = YES DELIMITER = ; AMOUNTDECIMALPOINT = . SKIP = 0 SKIPIF = VALIDATERECORDS=YES CREDITPOSITIVE=YES MAXREJECTCOUNT= ROUNDAMOUNT= *MAPPING ID=ID ACCTYPE=*STR(AST) *CONVERSION ID=CF_TEST.xls

EXTERNAL INTERNAL 0110219010 0110219010 0????????? *SKIP SK?? *SKIP GSK9 GSK9 GSK9??? ??? GSK9?? ?? GSK9? ?

The results while validating the transformation file (where we can see both descriptions are being read correctly for account 0110219010, while I only get spanish descriptions for the nodes):

832 ;0110219010;AST;X;;;;;;AST;SKOP;ZHL_CUENT;Valuation of Financial Assets at Fair Value Equity;Valorizacion AF fcros a VR inst patrimonio 2661 ;13;AST;;;;;;;;;0HIER_NODE;Act.Fcros a VR c/Cambios en Res Inst. Patrim.; 2662 ;14;AST;;;;;;;;;0HIER_NODE;Act.Fcros a VR con Cambios en Res. F.Mutuos; 2663 ;34;AST;;;;;;;;;0HIER_NODE;Otros activos financieros corrientes; 2664 ;21;AST;;;;;;;;;0HIER_NODE;Act.Fcros a VR con Cambios en Res., Otros; 2665 ;22;AST;;;;;;;;;0HIER_NODE;Act.Fros Disp. Vta., Instrumentos Pat.CP; 2666 ;23;AST;;;;;;;;;0HIER_NODE;Act.Fros Disp. Vta., Fondos Mutuos,Corriente; 2667 ;24;AST;;;;;;;;;0HIER_NODE;Act.Fros Disp. Vta., Otros Corrientes; 2668 ;25;AST;;;;;;;;;0HIER_NODE;Otros Activos Financieros, corriente; 2669 ;26;AST;;;;;;;;;0HIER_NODE;Activos derivados;

Any help will be much appreciated.

Thank you!