Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Integrating Additional Data > Creating New Tables >

Creating a Profile Table Using Domain Values

This section describes how to create new profile tables. A profile table is a table that holds all possible combinations of specific multistate columns. You can create an unlimited number of profile tables, containing all possible combinations of domains and their values or the cross-product of the contents of IA_DOMAINS.

A profile table is built with the help of two prepackaged tables—the Domains table and the Profile Specifications table.

• The Domains table. IA_DOMAINS, stores predefined values for columns that can only hold certain values, as shown in Table 28.
• The Profile Specifications table. IA_PROFILE_SPECS, is used to join to the Domains table to generate all the possible combinations of values you may want to use in a profile table, as shown in Table 29.

  Table 28. Join IA_DOMAINS

  Domain Name	Domain Position	Domain Value	Domain Flag	Language Code
  REGN	0	Not Performed	Y	E
  REGN	1	Started	N	E
  REGN	2	Completed	N	E
  RESEARCH	0	Not Performed	Y	E
  RESEARCH	1	Started	N	E

You can create profile tables using the already loaded data in IA_DOMAINS and IA_PROFILE_SPECS. For this purpose, Siebel Customer-Centric Enterprise Warehouse includes a Business Component mapplet, which you can replicate and configure for every profile table you want to build. The Business Component joins up to ten instances of the IA_DOMAINS table to IA_PROFILE_SPECS using the DOMAIN_NAME column.

NOTE:  You can build a profile table with a maximum of ten domains, if the first domain holds no more than three values and the other nine hold no more than ten each. If you build a profile table with fewer than ten domains, each domain can hold a maximum of ten values.

To build a new profile table using IA_DOMAINS and IA_PROFILE_SPECS

1. In PowerCenter Designer, open the Siebel Business Analytics folder.
2. Select Tools > Mapplet Designer.
3. Open Mapplets folder, and drag and drop MPLT_BCZ_PROFILE mapplet into Mapplet Designer.
4. Double-click the SQ_PROFILE Source Qualifier to open the Edit Transformations window.
5. Click the Properties tab, and then click the down arrow to access the SQL statement.
6. Edit the SQL statement by entering your new profile table name (for example, IA_SALES_PROFILE) in the PROFILE_NAME column and the Domain Names that comprise it in the DOMAIN_NAME_* columns.
7. Select Generate SQL, and then click OK.
8. Validate and save your changes to the repository.

   NOTE:  Fact tables in Siebel Enterprise Sales Analytics and Siebel Enterprise Contact Center Analytics contain foreign keys to profile tables. For all other tables that do not contain a profile key, use one of the dimension key extension columns packaged in the table.