Select TABLE from the drop-down list

A synonym can be created using one or more languages. If you choose multiple languages, each selected language can have its own title and description attributes. For details on multilanguage titles and descriptions, see Multilanguage Titles and Descriptions.

1. Click the Multilanguage checkbox to select languages in addition to the default logon language (the value of the SET LANGUAGE command at server startup). You get a list of available languages (the default language is not on the list).
2. Select one or more additional languages. For SAP, the WebFOCUS Reporting Server logon language is used to retrieve all languages.

On the next pane:

• Select a Find by option: Application Tree, Development Class, or Name. (These options mirror the way SAP organizes and filters its data.)

  Subsequent selections vary depending on your Find method, as described below.

• Indicate whether to retrieve objects associated with Tables, Views, or both.
• Indicate whether to retrieve objects associated with Tables, Views, CDS Structured Objects, or all object types together.

Application Tree. Choose this option, then click Next to retrieve a list of applications.

On the next pane, choose an application from the list, then click Next.

Development Class. Choose this option and type a Development Class name in the input box, or enter a string with wildcards, as needed. For example, enter: abc* or abc% to select development classes that begin with the letters abc; *abc or %abc to select those that end with the letters abc; *abc* or %abc% to select those that contain the letters abc at the beginning, middle, or end.

Click Next to display the Development Class options.

On the next pane, select a Development Class, then click Next.

Name. Choose this option and type the name of a Table in the input box, or enter a string with wildcards (* or %), as needed.

Enter a value in the Limit entry box. The default is 2000 tables. A message requesting a limit value is displayed when the list of available tables is too large to retrieve.

Click Next.

Click this checkbox if you wish to generate information about primary key and foreign key relationships in the Access File of the synonym.

An individual Master File is generated for each table. However, the relationships indicated in the Access File can be defined between any number of tables, and can reflect any number of levels of relationships among those tables.

(FOC44457) FOREIGN KEY FIELD **** CANNOT BE RESOLVED
 
(FOC44458) ONE OR MORE FIELDS OF THE FOREIGN KEY DO NOT EXIST
 
(FOC44459) MULTIPLE FOREIGN TABLES

where:

****

Is a table name.

These messages indicate that some of the foreign key relationships could not be resolved, and are, therefore, omitted during synonym creation. These messages are informational only: they should cause you no concern. In fact, the synonym is created and can be used in your requests without any problems.

Select an application directory. The default value is baseapp.

If you have tables with identical table names, assign a prefix or a suffix to distinguish them. For example, if you have identically named human resources and payroll tables, assign the prefix HR to distinguish the synonyms for the human resources tables. Note that the resulting synonym name cannot exceed 64 characters.

If all tables and views have unique names, leave the prefix and suffix fields blank.

To specify that this synonym should overwrite any earlier synonym with the same fully qualified name, select the Overwrite existing synonyms checkbox.

Select this checkbox only if the synonym is to be used by an application that connects to the WebFOCUS reporting server via ODBC.

When this option is selected, unsupported formats trigger the creation of DEFINE (virtual) fields.

There are three Special Options:

• None. Indicates that no Special Option is selected. This is the default value.
• Foreign Keys. Select this option if you wish to generate information about primary key and foreign key relationships in the Access File of the synonym.

  An individual Master File is generated for each table. However, the relationships indicated in the Access File can be defined between any number of tables and can reflect any number of levels of relationships among those tables.

  Note: During synonym creation, you may get one or more of the following messages:

  (FOC44457) FOREIGN KEY FIELD **** CANNOT BE RESOLVED
   
  (FOC44458) ONE OR MORE FIELDS OF THE FOREIGN KEY DO NOT EXIST
   
  (FOC44459) MULTIPLE FOREIGN TABLES

  where:

  ****

  Is a table name.

  These messages indicate that some of the foreign key relationships could not be resolved, and are, therefore, omitted during synonym creation. These messages are informational only and should cause you no concern. In fact, the synonym is created and can be used in your requests without any problems.

• ODBC Type Fields. Select this option only if the synonym is to be used by an application that connects to the WebFOCUS reporting server via ODBC.

When this option is selected, unsupported formats trigger the creation of DEFINE (virtual) fields.

Select an application directory. The default value is baseapp.

If you have tables with identical table names, assign a prefix or a suffix to distinguish them. For example, if you have identically named human resources and payroll tables, assign the prefix HR to distinguish the synonyms for the human resources tables. Note that the resulting synonym name cannot exceed 64 characters.

If all tables and views have unique names, leave the prefix and suffix fields blank.

This column displays the name that will be assigned to each synonym. To assign a different name, replace the displayed value.

Click the checkbox to the left of Default Synonym Name to generate synonyms for all listed tables, or check individual boxes in the same column to generate synonyms for the selected modules.

Select LDB from the drop-down list.

A synonym can be created using one or more languages. If you choose multiple languages, each selected language can have its own title and description attributes. For details on multilanguage titles and descriptions, see Multilanguage Titles and Descriptions.

1. Click the Multilanguage checkbox to select languages in addition to the default logon language (the value of the SET LANGUAGE command at server startup). You get a list of available languages (the default language is not on the list).
2. You may select one or more additional languages. For SAP, the WebFOCUS Reporting Server logon language is used to retrieve all languages.

Note: For the your language selections to be implemented, the selected languages must be installed. Also NLS must be enabled and your language selections must be consistent with your code page settings in the NLS Configuration Wizard. To access this wizard from the WebFOCUS Reporting Server browser interface menu bar, onWorkspace page, select Settings, LOCALE, Configuration Wizard. In the navigation pane, expand the General folder and click NLS. For related information, see Code Pages and Multilanguage Synonyms.

On the next pane:

• Select a Find by option: Application Tree, Development Class, or Name. (These options mirror the way SAP organizes and filters its data.)

  Subsequent selections vary depending on your Find method, as described below.

• Indicate whether to retrieve objects associated with Native LDBs or Native Dynamic LDBs. For related information, see Limitations for Logical Databases.

  In Native mode a static report is catalogued and executed.

  In Native Dynamic mode specific BAPIs are called to provide results on an LDB query.

Application Tree. Choose this option, then click Next.

On the next pane, choose an application from the list, then click Next.

Development Class. Choose this option and type a Development Class name in the input box, or enter a string with wildcards, as needed. For example, enter: abc* (or abc%) to select development classes that begin with the letters abc; *abc (or %abc) to select those that end with the letters abc; *abc* (or %abc%) to select those that contain the letters abc at the beginning, middle, or end.

Click Next to display the Development Classe(s).

On the next pane, select a Development Class, then click Next.

Name. Choose this option and type the name of a Table in the input box, or enter a string with wildcards (* or %), as needed.

Enter a value in the Limit entry box. The default is 2000 tables. A message requesting a limit value is displayed when the list of available tables is too large.

Select an application directory. The default value is baseapp.

If you have tables with identical table names, assign a prefix or a suffix to distinguish them. For example, if you have identically named human resources and payroll tables, assign the prefix HR to distinguish the synonyms for the human resources tables. Note that the resulting synonym name cannot exceed 64 characters.

If all tables and views have unique names, leave the prefix and suffix fields blank.

To specify that this synonym should overwrite any earlier synonym with the same fully qualified name, select the Overwrite existing synonyms checkbox.

This column displays the name that will be assigned to each synonym. To assign a different name, replace the displayed value.

Select the objects for which you wish to create synonyms:

• For all objects, click the checkbox to the left of the Default Synonym Names column.
• For specific objects, select the corresponding checkboxes.

Select Function Module from the drop-down list.

A synonym can be created using one or more languages. If you choose multiple languages, each selected language can have its own title and description attributes. For details on multilanguage titles and descriptions, see Multilanguage Titles and Descriptions.

1. Click the Multilanguage checkbox to select languages in addition to the default logon language (the value of the SET LANGUAGE command at server startup). You get a list of available languages (the default language is not on the list).
2. You may select one or more additional languages. For SAP, the WebFOCUS Reporting Server logon language is used to retrieve all languages.

On the next pane, select a Find by option: Application Tree, Development Class, or Name. (These options mirror the way SAP organizes and filters its data.)

Subsequent selections vary depending on your Find method, as described below.

Application Tree. Choose this option, then click Next.

On the next pane, choose an application from the list, then click Next.

Development Class. Choose this option and type a Development Class name in the input box, or enter a string with wildcards, as needed. For example, enter: abc* (or abc%) to select development classes that begin with the letters abc; *abc (or %abc) to select those that end with the letters abc; *abc* (or %abc%) to select those that contain the letters abc at the beginning, middle, or end.

Click Next to display the Development Class(es).

On the next pane, select a Development Class, then click Next.

Name. Choose this option and type the name of a Table in the input box, or enter a string with wildcards (* or %), as needed.

Enter a value in the Limit entry box. The default is 2000 tables. A message requesting a limit value is displayed when the list of available tables is too large.

Select an application directory. The default value is baseapp.

If you have tables with identical table names, assign a prefix or a suffix to distinguish them. For example, if you have identically named human resources and payroll tables, assign the prefix HR to distinguish the synonyms for the human resources tables. Note that the resulting synonym name cannot exceed 64 characters.

If all tables and views have unique names, leave the prefix and suffix fields blank.

To specify that this synonym should overwrite any earlier synonym with the same fully qualified name, select the Overwrite existing synonyms checkbox.

This column displays the name that will be assigned to each synonym. To assign a different name, replace the displayed value.

Click the checkbox to the left of Default Synonym Name to generate synonyms for all listed function modules, or check individual boxes in the same column to generate synonyms for the selected modules.

Select BAPI from the drop-down list.

A synonym can be created using one or more languages. If you choose multiple languages, each selected language can have its own title and description attributes. For details on multilanguage titles and descriptions, see Multilanguage Titles and Descriptions.

1. Click the Multilanguage checkbox to select languages in addition to the default logon language (the value of the SET LANGUAGE command at server startup). You get a list of available languages (the default language is not on the list).
2. You may select one or more additional languages. For SAP, the WebFOCUS Reporting Server logon language is used to retrieve all languages.

On the next pane, select a Find by option: Application Tree, Development Class, or Name. (These options mirror the way SAP organizes and filters its data.)

Subsequent selections vary depending on your Find method, as described below.

Application Tree. Choose this option, then click Next to retrieve a list of applications that contain BAPIs.

On the next pane, choose an application from the list, then click Next.

Development Class. Choose this option and type a Development Class name in the input box, or enter a string with wildcards, as needed. For example, enter: abc* (or abc%) to select development classes that begin with the letters abc; *abc (or %abc) to select those that end with the letters abc; *abc* (or %abc%) to select those that contain the letters abc at the beginning, middle, or end.

On the next pane, select a Development Class, then click Next.

On the next pane, choose an object type, then click Next.

Name. Choose this option and type the name of a BABI in the input box, or enter a string with wildcards (* or %), as needed.

Enter a value in the Limit entry box. The default is 2000 tables. A message requesting a limit value is displayed when the list of available BAPIs is too large to retrieve.

On the next pane, select a BABI, then click Next.

Select an application directory. The default value is baseapp.

If you have tables with identical table names, assign a prefix or a suffix to distinguish them. For example, if you have identically named human resources and payroll tables, assign the prefix HR to distinguish the synonyms for the human resources tables. Note that the resulting synonym name cannot exceed 64 characters.

If all tables and views have unique names, leave the prefix and suffix fields blank.

To specify that this synonym should overwrite any earlier synonym with the same fully qualified name, select the Overwrite existing synonyms checkbox.

This column displays the name that will be assigned to each synonym. To assign a different name, replace the displayed value.

Select the objects for which you wish to create synonyms:

• For all objects, click the checkbox to the left of the Default Synonym Names column.
• For specific objects, select the corresponding checkboxes.

Select QUERY from the drop-down list.

SAP Queries can be created under two different query areas: Standard Area (client-specific) and Global Area (cross-client). By default, queries are created under the Standard Area so no action is required.

To create queries under the Global Area, select the Cross Client Queries checkbox.

WHERE WORKSPACE EQ 'X';

To list queries for a specific Group, click the Filter checkbox and type a Group Name and/or a Query name in the input boxes provided, using the wildcard character (*) as needed.

Click to proceed to the next pane.

Select an application directory. The default value is baseapp.

If you have tables with identical table names, assign a prefix or a suffix to distinguish them. For example, if you have identically named human resources and payroll tables, assign the prefix HR to distinguish the synonyms for the human resources tables. Note that the resulting synonym name cannot exceed 64 characters.

If all tables and views have unique names, leave the prefix and suffix fields blank.

To specify that this synonym should overwrite any earlier synonym with the same fully qualified name, select the Overwrite existing synonyms checkbox.

Select the objects for which you wish to create synonyms:

• For all objects, click the checkbox to the left of the Default Table Names column.
• For specific objects, select the corresponding checkboxes.

This column displays the name that will be assigned to each synonym. To assign a different name, replace the displayed value.