In this section:
This section describes new Web Console features.
In this section:
The following new information reports, available from the Web Console, have been introduced in this release:
You can determine which functions are optimized to their SQL counterparts by adapter in the SQL Optimization Report available from the Web Console.
The Filter SQL Optimization Report page opens, as shown in the following image.
The SQL Optimization Report is displayed, as shown in the following image.
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.
The Filter Function Parameters Report page opens, as shown in the following image.
The Filter Function Parameters Report is displayed, as shown in the following image.
SQL Data Type mapping options are available in a report available from the Web Console.
To access the Data Type Report:
The Filter Data Types Report page opens, as shown in the following image.
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.
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:
Is the host name of the server and the port on which it listens.
Is an application under ibi_approot.
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.
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:
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.
Specifies the maximum number of undo operations allowed in the Synonym Editor. The default value is 50.
If selected, the Sort and Styles buttons appear on the Synonym Editor toolbar and the Insert menus.
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.
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.
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.