How to switch languages on sap bpc?

[Former Member]

Hi Hi

I'm using both Icelandic and English in my report.

In Dimension Library I got "account dimension" There I got ID which is the account member. Then AVDESCRIPTION witch is the English name of that ID. Then I got "IC_DESC" witch is the Icelandic translation.

I'm just wondering how I can switch languages from English to Icelandic and back.

Can I choose which languages I use when I'm creating the report?

Do you know witch is the best way to to switch languages in BPC?

Best regards

Haukur Hauksson

[Former Member]

It worked     Thank you vary much.

[Former Member]

*very

[Former Member]

Wonderful

Thanks,

Asad

[former_member186498]

Hi Haukur,

then please remember to close this thread.

Regards

     Roberto

[Former Member]

Hello Haukur,

Roberto is correct. You can create a drop down on a visible cell on your report

Let users chose English or Icelander

Than where you have EVDES to see description use EVPRO in that column with IF formula of excel

Example:

=IF(A1="English",EVDES(REFERENCE CELL CONTAINS ID),EVPRO("ID OF APPLICATION",REFERENCE CELL CONTAINS ID,"IC_DESC")

Hope  this helps.

Thanks,

Asad Ahmed

[Former Member]

In above formula cell A1 refers to your drop down selection.

[former_member186498]

Hi Haukur,

you can use excel maybe with radiobutton to choose the language and select through a test the EVDES or EVPRO for the second language.

If you want to translate also reports text automatically for each user then see please http://scn.sap.com/message/5360324

Regards

     Roberto