About Working With Domains and Domain Mappings

There are two types of Domains.

You can edit a Domain Member Mapping if you need to change it from the default values.

1. Navigate to the Domain that you want to edit.

   To display the Domain Mapping tab:

   • In Configuration Manager, select Manage Domain Mappings and Hierarchies in the Tasks pane, display the Domain Mappings tab, then select a Domain.

   • In FSM, select the Go to Task link for a Task that updates a Domain or Domain Member Mappings.

2. Scroll down to the Domain Member Mappings pane.
   
   Description of the illustration GUID-2A802BAB-EDE6-408C-BB94-DEDDC34E950A-default.gif
3. Click the Edit Domain Member Mappings icon.
   
   Description of the illustration GUID-A8AA263E-D604-4E5A-B71A-181CC040359D-default.gif
4. Edit the domain mapping values.

   Note:

   If you change existing values, then the records already loaded in the data warehouse are not modified and only new records are changed. Because new records are changed in this way, you must run a full load. However, if the change involves a new source member that is imported from the source, then all dimension records impacted due to that import are new. Because the dimension records are new, you need not run a full load.

You can add a Range Member Mapping to a domain for which you can specify ranges.

1. Navigate to the Domain that you want to edit.

   To display the Domain Mapping tab:

   • In Configuration Manager, select the Manage Domain Mappings and Hierarchies link in the Tasks pane, display the Domain Mappings tab, then select a banded (or ranged) Domain.

   • In FSM, select the Go to Task link for a Task that updates a banded or ranged Domain or Domain Member Mappings.

2. Scroll down to the Domain Member Mappings pane.
   
   Description of the illustration GUID-2A802BAB-EDE6-408C-BB94-DEDDC34E950A-default.gif
3. Click the Edit Domain Member Mappings icon to display the Edit Domain Member Mappings dialog.
   
   Description of the illustration GUID-38B982EC-8523-4831-B2CE-CD5F77C76BC0-default.gif
4. Click the Add Range Member Mapping (+) icon and specify values in the Range Start, Range End, and Target Domain Member - Code fields.

   Tip:

   Before you create a new range, you might first want to use the Add Warehouse Member button to first create a target Warehouse Member, which is then available as an option in the Target Domain Member - Code list. For example, you might add a Warehouse Member called 'Greater than 250,000' to map to the range 250,000 to 1,000,000.

You add Target Domain Members to extend Oracle Business Analytics Warehouse.

1. Navigate to the Domain that you want to edit.

   To display the Domain Mapping tab, do one of the following:

   • In Configuration Manager, select the Manage Domain Mappings and Hierarchies link in the Tasks pane, display the Domain Mappings tab, then select a Domain.

   • In FSM, select the Go to Task link for a Task that updates a Domain or Domain Member Mappings.

2. Scroll down to the Domain Member Mappings pane.
   
   Description of the illustration GUID-2A802BAB-EDE6-408C-BB94-DEDDC34E950A-default.gif
3. Click the Edit Domain Member Mappings icon to display the Edit Domain Member Mappings dialog,
   
   Description of the illustration GUID-46C465E7-3F2E-43F7-9923-6BAE7641A409-default.gif
4. Click Add Target Domain Member to display the Add Target Domain Member dialog, which enables you to specify a Name, Code, and optional Description.
   
   Description of the illustration GUID-04A29BFA-8A17-4B06-B788-31CFE064455C-default.gif

   For example, you might add a Warehouse Member called 'Greater than 250,000' to map to the range 250,000 to 1,000,000.

   If the Add Target Domain Member option is grayed out or not displayed, then the domain is non-extensible.

   When you click OK to return to the Edit Domain Member Mappings dialog, you can map a Source Domain to the Target Domain that you just created.

If you added a new domain member and it requires localization, you can add string localizations for Configuration Manager metadata.

1. Open a database administration tool, and connect to the Oracle Business Analytics Warehouse schema.
2. Query for the table C_DOMAIN_MEMBER_TL and the new domain member record you added in Adding a Target Domain Member.

   You can query for the new domain member record by using the query filter on the columns CREATED_BY and CREATION_DATE. Each new domain member record will have 28 rows in the C_DOMAIN_MEMBER_TL table.

3. Update the LANGUAGE_CODE column to match the localized deployment language.
   1. Identify the language code for the localized language using the following SQL:

      SELECT LANGUAGE_CODE, NLS_LANGUAGE, NLS_TERRITORY
      FROM FND_LANGUAGES_B
      WHERE INSTALLED_FLAG IN ('B', 'I');
      

   2. Update the domain member name, description, and source language code strings for the localized language using the following SQL:

      In this example, the localized language is Arabic, and the LANGUAGE_CODE is AR.

      UPDATE C_DOMAIN_MEMBER_TL
      SET DOMAIN_MEMBER_NAME = '<Arabic translated string for domain member name>', DOMAIN_MEMBER_DESCR = '<Arabic translated string for domain member description>', SRC_LANGUAGE_CODE = 'AR'
      WHERE DOMAIN_KEY = '<Domain key value for the record you want to update>'
      AND DOMAIN_MEMBER_CODE = '<Domain member code value for the record you want to update>'
      AND LANGUAGE_CODE = 'AR';
      

4. Exit the database administration tool.
5. Restart the Oracle WebLogic Server.

If you added a new domain member, you can add string localizations in the Oracle BI Repository metadata.

1. Stop the OPMN services.

   Use the command: opmnctl stopall.

2. Open a database administration tool, and connect to the Oracle Business Analytics Warehouse schema.
3. Identify the strings for the following presentation objects:
   • Subject area
   • Presentation table
   • Presentation hierarchy
   • Presentation level
   • Presentation column

   For example, for the subject area Payables Invoices - Prepayment Invoice Distributions Real Time, enter the following strings:

   String	Presentation Object
   Payables Invoices - Prepayment Invoice Distributions Real Time	Subject area
   Time	Presentation table
   Date - Year	Presentation hierarchy
   Total	Presentation level
   Year	Presentation level
   Calendar Year	Presentation column

4. For each subject area, externalize the strings for localization and generate custom names for the presentation objects:
   1. In the Oracle BI Administration Tool, right-click the subject area and select Externalize Display Names, and then select Generate Custom Names.
   2. Save your work.

   See Localizing Metadata Names in the Repository in System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.

5. Check the consistency of the repository, and remove any inconsistencies.

   See Checking the Consistency of a Repository or Business Model in Metadata Repository Builder's Guide for Oracle Business Intelligence Enterprise Edition.

6. Enter the custom name of one of the presentation objects into the table C_RPD_MSGS:

   INSERT INTO C_RPD_MSGS(MSG_ID, CREATED_BY, CREATION_DATE)
   VALUES('<CUSTOM NAME OF PRESENTATION OBJECT>', 'CUSTOM', SYSTIMESTAMP);
   COMMIT;
   

   To view the values for custom names and logical columns in the Oracle BI Administration Tool, right-click the presentation object and select Properties. The data in the Custom display name field appears in the format VALUEOF(NQ_SESSION.VALUE, where VALUE is the custom name for a presentation object, or the logical value for a presentation column. This value is the value that you need to enter in the VALUES section of the SQL statement above.

7. Enter the localized string for the presentation object in the previous step into the table C_RPD_MSGS_TL:

   INSERT INTO C_RPD_MSGS_TL(MSG_ID, MSG_TEXT, LANGUAGE_CODE, CREATED_BY, CREATION_DATE)
   VALUES('<CUSTOM NAME OF PRESENTATION OBJECT>', '<LOCALIZATION OF THE STRING'>, '<LANGUAGE CODE FOR TRANSLATED LANGUAGE>', 'CUSTOM', SYSTIMESTAMP);
   COMMIT;
   

   To identify the language code for a particular language, use the following SQL:

   SELECT LANGUAGE_CODE, NLS_LANGUAGE, NLS_TERRITORY
   FROM FND_LANGUAGES_B
   WHERE INSTALLED_FLAG IN ('B', 'I');
   

8. Enter additional details about the presentation object into the table C_RPD_MSGS_REL as indicated by the following SQL:

   INSERT INTO C_RPD_MSGS_REL(MSG_ID, MSG_NUM, MESSAGE_TYPE, CREATED_BY, CREATION_DATE)
   VALUES('<CUSTOM NAME OF PRESENTATION OBJECT>', '<TRANSLATION OF THE STRING'>, '<LANGUAGE CODE FOR TRANSLATED LANGUAGE>', 'METADATA','CUSTOM', SYSTIMESTAMP);
   COMMIT;
   

9. Repeat steps 6 through 8 for each presentation object requiring localization.
10. Validate that the physical connection of the session initialization block INIT_USER_LANGUAGE_CODE is operable:
    1. In the Oracle BI Administration Tool, select Manage, Variables, Session Initialization Block.
    2. Right-click INIT_USER_LANGUAGE_CODE.
    3. In the Properties dialog, click Edit Data Source.
    4. Click Test, and input the value for the language code. Then, click OK.

       For example, for Arabic enter 'AR'.

       The value USER_LANGUAGE_CODE = '<language code>' should be returned.

       If this value is not returned, the TNS entry for the data source is not properly configured.

11. Restart the OPMN services.
12. Verify the localized strings in Oracle BI Answers. On the login page, specify the appropriate language.

In some scenarios, you might only know what target Domain member values should be when you deploy Oracle BI Applications. For example, in Order Management or Supply Chain Analytics, UOM (Unit of Measurement) is typically not known until deployment time. You can set up a non-ranged target domain using the Sync to Source option to automatically synchronize a target domain with values from the source domain.

This process inserts new target members from the source domain, and automatically generates 1:1 mappings. This is useful for large domains with many member mappings that might otherwise take a long time to set up.

Description of the illustration GUID-2103BC25-A7F0-4371-9E74-0716A63B15E5-default.gif

Sync to Source is only available for extensible non-ranged Domains.

1. Navigate to the Domain that you want to synchronize.

   If you are in Configuration Manager, from the Tasks bar click Manage Domains and Mappings, display the Domain mappings tab, select the Domain that you want to edit, then click the Edit Domain Member Mappings icon in the Domain Member Mappings pane to display the Edit Domain Member Mappings dialog.

   If you are in FSM, when you click Go to Task for the Task that is updating a Domain, you display the Edit Domain Member Mappings dialog.

   
   Description of the illustration GUID-A8AA263E-D604-4E5A-B71A-181CC040359D-default.gif
2. Click Sync to Source.
3. At the Warning dialog, click OK.
   
   Description of the illustration GUID-AF628F4D-AD0B-439B-A67F-BF55539BE954-default.gif

   Important:

   If you click OK to continue, then you commit changes to the target Domain members, even if you do not click Save or click Save and Close on the Edit Domain Member Mappings dialog.

   Target Domain member values are generated. In the example below, the target codes for C_JOB_FAMILY are automatically synchronized with the Source member codes.

   
   Description of the illustration GUID-5644D49B-A561-40AE-9C18-BFB95FA466EE-default.gif

You can set up a target domain using the Batch Edit option to update multiple target domain members with the same value. This is useful for large domains with many member mappings that require the same value.

1. Navigate to the Domain that you want to edit.

   If you are in Configuration Manager, from the Tasks bar click Manage Domains and Mappings, display the Domain mappings tab, select the Domain that you want to edit, then click the Edit Domain Member Mappings icon in the Domain Member Mappings pane.

   If you are in FSM, click Go to Task for the Task that is updating a Domain.

   
   Description of the illustration GUID-C1E2640E-CF89-4FC4-846C-4DBF40B99FDC-default.gif
2. Ctrl + click to multi-select one or more rows in the table.
3. Select a value from the Batch Edit drop-down list.
4. Click Change to apply the value selected in the Batch Edit drop-down list to all specified members.