1 Introduction

The CMN_PROFILE_ENTERPRISE table contains values that control the behavior of all enterprises in the Argus Insight application.

You can update many of these values by modifying the Profile Switches in the List Maintenance tab on the ADMINISTRATION TOOLS page in Argus Insight.

Other values you can access and update only through direct SQL statements.

In addition to the CMN_PROFILE_ENTERPRISE table, the CMN_PROFILE_GLOBAL table contains values that control the behavior of Argus Insight. For more information about the modifying the profile global switches, see the Oracle Argus Insight CMN Profile Global Table Guide.

1.1 Internal Use Rows

During the initial Factory Data load when the database is created, the system creates several Internal Use rows. As the name implies, these rows of values are for Argus Insight internal use only.

Do not modify any values in the internal use rows.

1.2 About the Columns in the CMN_PROFILE_ENTERPRISE Table

Each profile switch described in this guide includes the following information:

• Section — Lists the name of the section within the CMN_PROFILE_ENTERPRISE table that has the profile switch. The sections are as follows:

  • SYSTEM

  • DATABASE

  • BOXI (for BusinessObjects XI)

  • COGNOS8

• Key — Lists the unique name for the profile switch.

• Company Defined — Indicates the method you can use to modify the profile switch:

  • 0 = Indicates you can modify this profile switch only by issuing direct SQL statements. You should modify these profile switches with assistance from Oracle Support.

  • 1 = Indicates you can modify this profile switch either by using the options in the List Maintenance tab in the Argus Insight application or by issuing direct SQL statements.

• Name — Lists the name of the profile switch as displayed in the List Maintenance tab in the Argus Insight application.

• Default Value — Lists the default value, if defined.

• Description — Provides more information about the function of the profile switch.

1.3 Examples of Modifying the CMN_PROFILE_ENTERPRISE Table

This section provides sample SQL for how to update and insert values in the CMN_PROFILE_ENTERPRISE table in the database.

Note that values, as specified, are case sensitive.

Updating an Existing Value

To update an existing value in the CMN_PROFILE_ENTERPRISE table:

UPDATE CMN_PROFILE_ENTERPRISE set value = '10'
WHERE section = 'DATABASE' AND key = 'ABC' AND ENTERPRISE_ID = 2;
commit;

Inserting a New Row of Values

To insert a new row of values into the CMN_PROFILE_ENTERPRISE table:

INSERT into CMN_PROFILE_ENTERPRISE (section, key, company_defined, name, value, description, enterprise_id)
values ('DATABASE', 'ABC', '0', 'ABC', '10', 'ABC_DEF_XYZ', 2);
commit;