Translation of BI objects

Use :With this an user can view the objects or reports in the required language which makes the implementation and operating Data warehouse user friendly.




Target projects:

Development and support based on SAP-BW 7.0



Description:

This document can be used for clear understanding of the functionality of Language Translation in SAP BW 7.0. In order to support BI system users who utilize the system in their first language, SAP Netweaver offers translation tools that allow us to translate the description of BI objects from their source language to target language using Translation Environment of the SAP Web Application Server (ABAP).



As we know that SAP Net weaver BI systems serves as Enterprise Data warehouse which is globally used across different time zones and using different languages.

The technique applies to BW Objects Translation as they are visible in reports to a high number of end users and also BI dataflow objects visible in Data warehouse Workbench. This technique is useful when implementing and operating an enterprise Data warehouse globally.



System settings for Language Translatio and Steps to be followed:



Language Environment setup Call transaction SLWA. On the languages tab page, choose languages.

The Translation Languages dialog box is displayed. Choose Add Languages, and select the required translation language. Choose a priority for the language. Specify a server for the language.



Now, save your settings. Add Target Language to a Client. Call transaction SLWA.

On the Languages tab page, choose Clients. Select the client to be defined.

In the Clients dialog box, enter the target languages for translation in the system.



If you want to specify the client as the translation client for all of the target languages defined in the system, choose Insert All Languages. Save your entries. If you want to create more translation clients, repeat these steps. Repeat these steps for all of the clients in which texts need translating.



Add clients to a target language Call transaction SLWA.

On the Languages tab page, choose Add Client. A dialog box appears containing all the available target languages in the system.



Select the target language. In the Clients dialog box, enter the client or clients in which texts need translating into the selected target language. Save.If you want to add more target languages to translation clients, repeat these steps.





Required Authorization: Transaction Object Value Purpose

LXE_MASTER/ SLWA/ SLWB OBJL 1 User have to create object list

LAOB 1

User need to define object types



GRAP

2

User need to create translation graphs



WRKL

1

User need to create global work list for each target language



LANG

1

User need to create target language, for setting priority



LACL

1

adding translation clients



USER

1

adding translation clients



COGA

1

Assigning Collections to a Translation Graph



COSE

1

Assigning Collections to a Translation Graph



USCO

1

Assigning Collections to a Translator



PREL

1

Releasing Object Lists/Transport Requests for Translation



A6

1

Setting object types for Automatic Distribution

A1

1

Setting up the target language



A5

1

Assigning packages





Step by step solution for Language Translation:

Create a piece list in the Data warehouse Workbench.

The piece list is basically a collection of objects to be translated.

Go to Transaction code RSA1 à Translation tab of the Data Warehouse workbench. Now create a piece list with the BW objects to be translated.

Collect the relevant objects in the Data warehouse workbench

RSA1 à Translation

E.g.: In this example, four info objects have been collected with the grouping option “Only necessary objects”.



Create a piece list for Translation In the dialog box, choose create to create piece list.

Create a piece list for Translation At the “select request type” dialog, select “Piece List”.



Create a piece list for Translation

Give the piece list a technical name (in customer namespace, starting with “Y” or “Z”) and a description. Save your piece list.



Create a piece list for Translation Assign your piece list to a package.



Create a piece list for Translation Choose continue in the Piece List Translation Dialog Box.



Create a Object List Go to transaction LXE_MASTER. In the evaluations tab, choose Object List.



Create an Object List. As shown below, in the object List dialog box, choose create option. Give description for your Object List and save. Assign the Piece List.

To include the Piece List in the Object List press “No Entries” button next to Transports (under ABAP system).



Enter the name of the Piece List you have created. If you want evaluate several piece lists, create entry for each one of them. Enter “*” as the transport type. Enter “*” as the transport status.

Save your entries. Save the Object List Parameters.



Generate the Object List. Choose “Activate”. Generate the Object List.



Schedule the background job which will generate the object list (the name of the job will be OBJLIST_xxxxx, xxxxx = number of the object list).



Editing a Work list in the Translation Environment

Once the job for generating the object list is finished, please go to the translation Environment (transaction code SE63).

In the next steps, all objects contained in the object List will be translated using a Work list.



Check your Default settings.

Go to Transaction SE63; from the Utilities Menu choose settings.

Here, it is necessary to ensure that the Source Language and Target Language settings correspond to your translation objective.



Check the specific format setting in which languages must be entered (For ex:”US English” is having Language Code “enUS” and not simply EN.) Save your settings.







Access your personal work list.

In the translation environment, from the Worklist menu, choose Standard. Enter a 4 digit work list number. If you want to reset an existing personal work list and/or a reservation number for accessing a personal work list, select the Reset Worklist / Reservation checkbox. Choose “continue”.



A) Access your personal work list using an object list. (Recommended approach).



This screen appears after having entered your work list number in the previous screen (SE63à WorklistàStandard) and choosing “continue”. Select your object list using the value help. Deactivate (all other) selections using the flag “Deactivate Selection”. Load the work list using the “Load objects” button.



B) Access Your Personal Worklist------Using a Piece List (Alternative approach for small number of objects only).



Enter your piece list using the value help (transport object or transport request). Deactivate (all other) selections using the flag “Deactivate Selection”. Load the Worklist using the “Load objects” button. Enter target Language texts for BI objects in the Worklist.



In order to translate a single object you have to double-click on it. In this simple scenario every single object will be translated individually and sequentially. If you want to translate a high amount of objects more efficiently, you may use proposal pools and automatic distribution. Please refer to the standard documentation on the translation tools for more information on these features.



Enter the equivalent text in the Target Language. Save. Set the standard quality status to “S” by clicking on the toolbox icon Choose the button Status “S”. Save the completed Work list.



Steps to be followed after changing the text for the required objects.

Transfer Texts to the M-Version of the BI Objects Using Program RSO_AFTER_TRANSLATION. Texts are only translated for objects in the A or D versions. Texts of objects in the Modified versions (M) are not translated. Therefore, a specific step is required - Otherwise, when you call the maintenance transactions in the target language, the system displays the old texts (if available) for these objects first. This program will transfer the newly translated texts to the modified version (M) of the BI objects.



Run the program RSO_AFTER_TRANSLATION.

Go to transaction SE38 and execute the program RSO_AFTER_TRANSLATION. Execute the program with the following parameters.

Request/Task: Name of the piece list.

Language Key: Source Language.

Language key: Target Language.



Verify the translation in the respective object maintenance screen.

Log on to the BI system in target language (Spanish (ES) here). Go to RSA1à Info Object maintenance in the data warehousing workbench. Find the info object for which translation is done:



Result:

Login into BI System in Source Language, here English (EN)