Web Console

Information Reports on Functions, Optimization, and Data Types

In this section:

The following new information reports, available from the Web Console, have been introduced in this release:

SQL Optimization Report. Identifies the functions that are optimized to their SQL counterparts, by adapter.
Function Parameters Report. Lists the parameters for each function, descriptions, and examples.
Data Type Report. Identifies mapping options for different data types.

Determining SQL Optimization

You can determine which functions are optimized to their SQL counterparts by adapter in the SQL Optimization Report available from the Web Console.

Top of page

Procedure: How to Display the SQL Optimization Report

Select Adapters from the main menu.
From the Information section of the ribbon, click the SQL Optimization Report button.
The Filter SQL Optimization Report page opens, as shown in the following image.
Optionally, select an Adapter Subcategory from the corresponding list box.
Optionally, select a Function Category from the corresponding list box.
Optionally, select the Show Function Description, Show DBCS Configuration, or Show Requirement on parameter value(s) check boxes.
Click Show Report.

The SQL Optimization Report is displayed, as shown in the following image.

Top of page

Determining Function Parameters

You can determine the parameters for a particular function from the Function Parameters Report available from the Web Console. The report also includes a brief description of the function.

Note: A report on System and Security Functions is available from the Access Control page and, therefore can only be viewed by users with server administrator privileges. These functions are not included in the reports available on the Adapters page.

Top of page

Procedure: How to Display the Function Parameters Report

Select Adapters from the main menu.
From the Information section of the ribbon, click the Function Parameters Report button.
The Filter Function Parameters Report page opens, as shown in the following image.
Optionally, select a Function Category from the corresponding list box.
Click Show Report.

The Filter Function Parameters Report is displayed, as shown in the following image.

Top of page

Data Type Support Report

SQL Data Type mapping options are available in a report available from the Web Console.

Top of page

Procedure: How to Access the Data Type Report

To access the Data Type Report:

Select Adapters from the main menu.
From the Troubleshooting section of the Ribbon, click the Data Types button.
The Filter Data Types Report page opens, as shown in the following image.
Select an Adapter Subcategory from the corresponding list box.
Select an Adapter from the corresponding list box.
Select a Server Data Type from the corresponding list box.
Click Show Report.

The Filter Data Types Report is displayed, as shown in the following image.

Note: You can also display the report as a PDF by selecting the Show Report in PDF check box.

Accessing Application Files Using a URL Reference

After you connect to a server with a valid user ID and password, and if you have the necessary access control privileges, you can open a file that is stored on the server and secured by the Reporting Server Access Control feature from a web session using a URL reference.

The URL reference has the following form:

http://host:port/ibi_approot/appname/myfile.ext

where:

host:port: Is the host name of the server and the port on which it listens.
appname: Is an application under ibi_approot.
myfile.ext: Is the name of the file to open and its extension. The file must be a type that a browser can open, such as a .pdf or .htm file.

For example:

http://myserver:8101/ibi_approot/baseapp/myfile.htm

Configuring Synonym Editor and Dimension View Preferences

The Web Console Preferences page includes options for configuring the Synonym Editor and Dimension Views.

To display the Preferences page, click the Web Console button and select Preferences.

The Web Console Preferences page opens, as shown in the following image.

You can configure the following preferences for the Synonym Editor:

Use application directory name with synonym: If selected, an application directory name will be used when selecting a synonym name for both referencing an existing synonym and performing a transformation with db_lookup.
Undo/Redo Limit: Specifies the maximum number of undo operations allowed in the Synonym Editor. The default value is 50.
Support extended options: If selected, the Sort and Styles buttons appear on the Synonym Editor toolbar and the Insert menus.
Default Join Type: Allows you to select the default Join type. Options are One-to-Many or One-to-One. The default is One-to-One.

In the Dimension View for virtual cubes, you can show Easy View. By default, it is not shown.

Searching for Files on the Server Using the Web Console

On the Applications page of the Web Console, you can open a page to search for files by name, description, contents, and statistics in an application directory or across the entire server.

To view the file search page, click the Search Files button on the Applications page ribbon, or right-click the Application Directories folder and select Search Files on the context menu.

The Search Files page opens, as shown in the following image.

Enter your search criteria, and click Search.

The report returned allows you to open procedures, Master Files, and displayable data in the editor.

New User Interface for File Selection

The new user interface for selecting a file has two windows, with a tree view on the left to select the server and application directory, and a list of files.

This can be seen when creating a synonym for a single file and when selecting the location to save a server object (such as data flow, process flow, or synonym), as shown in the following image.