Externalize Presentation Layer

How to Externalize Presentation Layer i.e enable translation of Presentation Layer depending on the User Logged in Language.

Following steps are using for the translation of presentation layer:-

1. Open Administration Console and right click on the Presentation Subject Area that you would like to Externalize. You would see 2 options there to externalize names and descriptions. For now let’s externalize Names alone. So, click on Externalize Display Names.

2. Once this is done go to Tools->Utilities and Click on Execute to Externalize Strings.

3. Open up this Excel file and let’s understand the structure of the csv. The first column represents Actual Names prefixed by their types of the Presentation Layer. The second column represents a list of Session variables prefixed by CN_. Remember that by default CN_ would be prefixed. The 3rd column represents the actual translation. Let’s modify this csv and let’s add one more column called language. This language would have values of Languages supported by OBI EE (abbreviations).

4. The next step is to load this CSV file into a database table.

5. Now let’s import this table into the Physical layer.

6. The first step after importing this table is to create an initialization block to initialize the LOCALE variable based on the language selected by the user in Dashboard login. To do this creates a session initialization block having the data source from a database. The database sql would have a sql like this.

Select ‘VALUEOF (NQ_SESSION.WEBLANGUAGE)'

7. The next step is to create another session initialization block which would basically create a set of session variables using a database specific sql. The sql would look like this

Select SESSION_VARIABLE, TRANSLATION from external where LANGUAGE = ‘VALUEOF (NQ_SESSION.LOCALE)’

8. Then login to Dashboards using Japanese as the language.