x

Choose the Application Paths category to edit or view the following settings.

approot

Location of Application Namespace root directory on the Web server where WebFOCUS is installed. The default location is ibi_apps, unless a different directory was specified during the installation of the WebFOCUS Client.

caster_path

Context root for the ReportCaster web application. This value and the one specified by the ReportCaster Context root parameter in the Client Selection section of the Utilities menu and the context root on the application server must be the same.

x

fochtmlurl

Alias used to locate WebFOCUS resources on the Web server.

ibif_webapp

Alias of the WebFOCUS Web application.

international_translation_directory

Location of translated files required to access the WebFOCUS client in different languages. The default location is install_drive:/ibi/ibi_html/javaassist/intl.

mrcmextractdir

Location of the Managed Reporting Change Management package. The default location is install_drive:/ibi/WebFOCUS/utilities/cm/extract.

repository_root

Location of repository content, previously known as custom_data_path. This variable is set to the parent of the worp directory, which includes Business Intelligence users, groups, and views. It can be used by Managed Reporting to locate where the basedir directory resides. Typically used in a clustered environment to point to a shared directory containing the basedir directory and worp subdirectories.

temporary_directory

Location of temporary files when running a WebFOCUS request. For example, redirected requests are written to this location. The default location is install_drive:/ibi/WebFOCUS/temp. This value and the one specified by the CGI_TEMP_DIR parameter in the General section of the Client Settings menu must be the same.

trace_location

Directory where trace files are written.

webfocus_client_root

Used to locate the WebFOCUS configuration files, such as cgivars.wfs.

webfocus_path

Path to the WFServlet servlet in the WebFOCUS application. The default value is /ibi_apps/WFServlet.

x

Choose the Security category to edit or view the following settings.x

PKIFilter.enabled

Enables the PKI filter which will extract the attribute specified in PKI_userid_source and put the value into the REMOTE_USER variable. Managed Reporting and ReportCaster must be configured to use the REMOTE_USER variable for logon separately. For more information, see Configuring Trusted Authentication. x

PKI_allow_ip

Specifies a list of IP addresses, separated by semi-colons, that will be allowed to pass the PKI filter even if there is not a valid client certificate in the request. The ReportCaster distribution server IP address must be included in this list for the ReportCaster distribution server to be able to retrieve Managed Reporting content. A sample list might look like:

127.0.0.1;127.0.0.2

If an IP address is not specified here and a client certificate is not provided, the PKI filter will return a 403 forbidden error when accessed.x

PKI_userid_source

Specifies the certificate attribute that should be retrieved into REMOTE_USER for the userid. The possible values are:

cn

The common name for the certificate. For example,

Joe.Smith.1122334455

upn

The userPrincipalName attribute from the Subject Alternate Name section of the certificate. For example,

1122334455@mil

Due to the way the UPN is encoded, you must have a copy of the Bouncy Castle Java Cryptography library within your classpath. It can be downloaded from their website at http://www.bouncycastle.org/java.html.

session_fidelity_check

When set to YES, the WebFOCUS Client verifies that the MR_COOKIE and the WF_COOKIE are associated with the correct session identifier. This additional verification step prevents potential cookie replay and cookie hijacking vulnerabilities. The default value is NO.

x

Choose the Portal category to edit or view the following setting.

portal_signon_trim_windows_domain

Removes the domain prefix and suffix from a user ID when using Windows authentication to connect to your portal environment (for example, as user IBI\john_smith). The default value is FALSE.

restrict_woas_to_ip

Specifies the IP address from which the WebFOCUS client allows a Open Portal Services request. The default value is 127.0.0.1.

use_gateway

Enables the use of the WebFOCUS Open Portal Services Gateway. The use of a gateway is required when the WebFOCUS client and the portal server are residing on two separate machines. If the WebFOCUS client and the portal server are installed on the same system, installing a gateway is not required. The default value is YES.

x

Choose the ReportCaster category to edit or view the following setting.

agent_node

ReportCaster Agent Listener node. This value and the one specified by the AGENT_NODE parameter in the ReportCaster section of the Client Settings menu must be the same.

agent_port

ReportCaster Agent Listener port. This value and the one specified by the AGENT_PORT parameter in the ReportCaster section of the Client Settings menu must be the same.

ibi_cookie_secure

When enabled, this variable restricts the exchange of cookies to only HTTPS sessions. This variable is not set by default.

ibimr_trusted_key

Represents the WebFOCUS installation time in milliseconds.

x

Choose the Cookie category to view or edit the following settings.

WF_COOKIE_EXPIRATION

Number of minutes the WebFOCUS cookie remains in effect. A value of 0 means that there will be no expiration time applied to the cookie.

This expiration time is refreshed each time a WebFOCUS report is run. WF_COOKIE is deleted when the expiration time is reached. Once WF_COOKIE is deleted, user credentials must be re-entered in order to continue using WebFOCUS.

REDIRECT_COOKIE

Prevents a redirected request that was run on one machine from being viewed from a browser on another machine. It uses a unique encrypted identifier to ensure that the person that sent the original request is the same person retrieving the output again. As of WebFOCUS Version 7 Release 6.10, REDIRECT_COOKIE is set to ON by default.

IBI_COOKIE_DOMAIN

Value of the domain field of a cookie. This value restricts where the cookie is sent. For example, if you specify a particular domain, cookies are only sent to hosts in that domain. By default, the cookie is only sent to the host from which it was generated.

IBI_COOKIE_PATH

Path(s) on the server to which the cookie will be sent. By default, WebFOCUS sets the path to the root directory ("/").

IBI_COOKIE_SECURE

When enabled, this variable restricts the exchange of cookies to only HTTPS sessions. This variable is not set by default.

x

Choose the General category to view or edit the following settings.

CGI_TEMP_DIR

Location of the temporary directory.

IBI_BACKUP_DIR

Location of the backup directory. By default, points to webfocus\backup. The conf subdirectory under backup contains a copy of cgivars.wfs with all of the default values. This is where the console retrieves the default values for cgivars.wfs when the Restore Default Values option is selected.

The administrator can change the backup directory to another location. However, the conf directory must be created under the new location.

IBI_HTML_DIR

Location of the root directory for HTML and Java language files.

IBI_CONFIG_DIR

Location of the directory containing WebFOCUS configuration files, including install.cfg, mrrealm.cfg, mradmin-config.xml, and approotConfig.xml.

Note: If you change this setting and you deploy the ibi_html.war or approot.war static content server Web applications, you may need to update their deployment descriptors with the new location of the approotConfig.xml file. For more information, see Configuring WebFOCUS in a Split Web-Tier and Application Server-Only Environment in the WebFOCUS installation manual for your platform.

EXPIRE_REPORTS

The time when reports generated by the WebFOCUS Reporting Server are to be re-executed. The expiration time is set in seconds, and the default setting is 300 seconds.

You can view a previously executed report on the browser without re-executing its request. If the request for a report you are running is the same as the one executed previously (within 300 seconds), then the browser displays the previously executed report stored in the cache when you use the Back, Reload, or the Refresh button of the browser.

You can set EXPIRE_REPORTS in the following ways:

• To ensure that the reports are re-executed, set EXPIRE_REPORTS to 1 second.
• To view the cached output of the browser without using the Back, Reload, or Refresh button, set EXPIRE_REPORTS to a large number, such as 4,000,000,000 seconds.

CACHE_CONTROL

An HTTP Header field that is used to specify how a browser should handle the caching of data in a request. Possible values are:

PRIVATE - The data in the response message is intended for only one user and should not be cached by a shared cache. This is the default value.

NO-CACHE - Browser caching is disabled. No files will be created on disk in the Temporary Internet Folder of the user.

WF_CODEPAGE

For internal use only. This setting is only for Japanese or Korean languages.

_site_profile

The following syntax enables you to include code to be executed on the WebFOCUS Reporting Server.

_site_profile=command

where:

command is any valid WebFOCUS Reporting Server syntax. The WebFOCUS Site Profile is not processed during a reporting server sign-on. It is only processed when running a procedure. Therefore, you cannot use it to record sign-on events.

_TempFileTimeout

Deletes files from the temporary directory. Files are deleted if they are older than the number of seconds specified.

LANG

This setting is applicable only when using the WebFOCUS CGI on UNIX. In order to display NLS characters on a report with Server Side Graphics, you must set this parameter to the appropriate UNIX locale encoding (for example, en_us).

WF_SIGNON_MESSAGE

Points to the HTML page that opens after a successful sign-on occurs.

IBIF_persistentamp

Turns on the persistent && feature. By default, this is set to YES. To disable, set to NO. The persistent && feature allows you to persist && variables for the duration of the browser session.

WF_AUTOSIGNON

Auto prompting of server credentials. Possible values are:

YES - Displays a dynamic server sign-on page after a failed connection to the WebFOCUS Reporting Server. YES is the default value.

NO - Disables the dynamic server sign-on page. Users will receive a message after a failed connection to the WebFOCUS Reporting Server.

PREPROMPT - Displays a dynamic server sign-on page before attempting to connect to the WebFOCUS Reporting Server for the first time.

IBIWF_language

With the Dynamic Language Switch feature, the default user interface language for a session is based on the language of the browser, or by setting the IBIWF_language=nn parameter in the URL (where nn is the ISO language abbreviation).

The WebFOCUS Client uses this default setting to control the display language when the browser language of the user is not one of the available options from the Select Language drop-down list during logon, or if no parameter is set in the URL call.

For possible values for the ISO language abbreviations, see the WebFOCUS National Language Support for International Computing manual.

CGI_PROG

Overrides the CGI/ISAPI/WFServlet client path for every redirected request.

IBIWF_sendbufsize

Defines the size of the buffer used for accumulating report content before moving it to the report cache (a temporary directory) or displaying it in the browser when using the Servlet implementation of the WebFOCUS Client. Possible values are:

blank, missing, or less than 1024 - Indicates that the WFServlet will use the current default size of 16384 bytes.

nn - Is the size in bytes of the buffer that will hold the report output when nn is greater than or equal to 1024.

IBIWF_redirect

Globally sets redirection on or off. Valid values are:

MIME - Respects the values set in the mime table. MIME is the default value.

ALWAYS - Always redirects. The report content is saved in the report cache (a temporary directory). Content is moved from memory to the report cache when it exceeds the value of IBIWF_sendbufsize. Then a second HTTP call is made from the browser to retrieve the report content for display.

NEVER - Never redirects. The report output displays in the browser immediately after the request is executed. The report content is streamed to the browser without writing anything to the report cache when the content exceeds the value stored in IBIWF_sendbufsize.

LEN - Does not redirect. If the size of the report content exceeds the value stored in IBIWF_sendbufsize, the report output is moved from memory to the report cache. Once the report output is completely accumulated in the report cache, it is sent to the browser without an additional HTTP call. This setting is useful for report formats, such as PDF, that require the CGI/WFServlet to accumulate the entire report on the middle tier in order to get the correct file size before sending it to the client.

IBIF_max_messages

Controls how many WebFOCUS Reporting Server message lines will be accumulated before WFServlet stops processing the request and displays error message 32100: "Reporting Server messages exceeded IBIF_max_messages, report retrieval aborted." Messages include –TYPE commands, &ECHO=ALL variables, and errors or warnings from a data adapter. The setting protects against the situation where the Java VM executing WFServlet runs out of memory. 20000 is the default value. IBIF_max_messages can be passed with the request, in which case it overrides the value set in the console. When debug mode is enabled in Developer Studio, a value of 50000 is passed with each request. A value of 0 indicates that no limit exists.

IBIF_excelservurl

Specifies the application server to be used to zip the file components that comprise an EXCEL 2007 file (.xlsx) as follows:

&URL_PROTOCOL//:servername/alias/IBIEXCELSERVURL

where:

URL_PROTOCOL

Is HTTP.

servername

Is the name of the application server where the WebFOCUS Client is installed.

alias

Is the context root of the WebFOCUS application. The default is ibi_apps.

IBIF_EXCELSERVURL cannot be used when Web server security is enabled. This includes Basic authentication, IWA, SSL, and third-party Security products (such as SiteMinder, Clear Trust, Oblix, WebSEAL). In these cases, the Web server security settings can prevent WebFOCUS from creating the EXCEL 2007 file. IBIF_EXCELSERVURL can be used with Basic authentication when the credentials are supplied as follows:

http://userid:password@host:port/alias/IBIEXCELSERVURL

However, this is not recommended since the password is displayed as plain text in the WebFOCUS Administration Console and the Web server logs.

Note: For more information on IBIF_excelservurl, see the Creating Reports with WebFOCUS Language manual.

IBI_RES_GOV_ADVISE

Enables the display of Resource Governor advise messages for the servers you select. When enabled, redirection is turned on for all report formats when the WebFOCUS Reporting Server returns any Resource Governor advise messages to display to the user. You can access the redirection settings by selecting Redirection Settings under the Configuration menu of the WebFOCUS Administration Console.

WF_proj_list_from_wfrs

Controls how Developer Studio loads the Projects tree and the Web Applications tree in the Project Development Environment. The default setting is NO to preserve legacy behavior. NO means that the project tree and Web application tree in the development environment are loaded with the set of applications found by WFServlet in the Web-tier application root directory. YES means that these trees are loaded with the set of applications found by the Project Development Reporting Server, except for APP MAP applications which are filtered out. Customers who want their developers to see only their own projects and applications in a shared development environment, may change this setting to YES and also do one of the following: APPLOCK the project development server (for more information, see Technical Memo 4613: Creating Private Application Views With APPLOCK 7.1 and higher) or use file system permissions on the application folders of the server.

WF_EMAIL_SERVER

Specifies the fully qualified name of an SMTP server that can be used by WebFOCUS to send e-mail messages. It is used to send links to Dashboard Mobile Favorites pages for Mobile Favorites users. It is also used by Magnify to send Notification and Reply e-mails.

SCC_NAME

Used by the WebFOCUS Developer Studio Source Control feature to identify the development environment. It is required by certain Version Control Systems such as ClearCase, CVS, and Subversion. This variable is transparent to the developers.

A value for this string must be provided if the environment will be used to source control files. Here is an example using the host name of the machine:

SCC_NAME=dev-server-1

The value needs to be unique for every WebFOCUS environment accessing the same Source Control repository, and the name should not contain spaces or any of the following special characters:

. / \ " ` ? : * < > |

Note: Avoid changing the value after files have been added to the Source Control repository. If you need to change the value, either add all files to the repository again or change the repository to be consistent with the new value.

For more information, see Managing a Project With Source Control in the Creating Reporting Applications With Developer Studio manual.

google_maps_api_version

Determines the version number of the Google Maps API. Can be an integer or decimal value. An integer value represents a stable version. The default value is 2.

google_maps_api_key

Provides access to the Google Maps API. The key is an 80+ character string that is copied from the Google site and pasted into this field. The key enables Google Maps to be embedded in customized HTML pages. To obtain a Google Maps API key, go to:

http://code.google.com/apis/maps/signup.html

x

Choose the Graph category to view or edit the following settings.

ENABLE_SSG

Setting this variable to Y (the default) enables server-side graphics. If set to N, WebFOCUS uses applets to display graphics. When set to APPLET, the graph displays in an applet in the browser window and the SET GRAPPLETONLY=ON command syntax is sent to the WebFOCUS Reporting Server.

IBIF_graphengine

Controls which graph engine to use for Server Side Graphics. Valid values are GRAPH53 and GRAPH32. GRAPH53 is the graph engine in Version 5 Release 3 and higher. GRAPH32 is the graph engine in Version 5 Release 2 and earlier, and is provided for backward compatibility because older procedures may require changes or may display differently with the GRAPH53 engine.

IBIF_graphengine can also be set in the Client Settings Graph panel located in the Configuration section of the WebFOCUS Administration Console.

IBIF_graphservurl

Configures graph image files on the Server. This is the default configuration option and is the required option on z/OS. In all other environments, JSCOM3 is the recommended configuration option.

The IBIF_graphservurl parameter has the following form:

&URL_PROTOCOL://machinename/alias/IBIGraphServlet

where:

URL_PROTOCOL is HTTP.

machinename is the name of the Web server where the WebFOCUS Client is installed.

alias is the context root of the WebFOCUS application (usually ibi_apps).

IBIF_graphservurl should not be used when Web Server security is enabled. This includes Basic authentication, IWA, SSL, and third-party Security products (such as SiteMinder, Clear Trust, Oblix, Web Seal). In these cases the Web Server security settings can prevent WebFOCUS from creating the graph. IBIF_graphservurl can be used with Basic authentication when the credentials are supplied as shown below:

http://userid:password@host:port/ibi_apps/IBIGraphServlet

However, this is not recommended because the password is displayed as plain text in the Console and the Web server logs. If Web server security is enabled, JSCOM3 should be used.

For information about using JSCOM3, see the description of the IBI_USE_JSCOM3 variable below.

IBIF_graphAgents

Specifies the number of pre-started agents available for graph processing.

SSG_EXTERNAL

Enables Server Side Graphics when using the WFServlet. This setting is recommended for large graph requests since it spawns new JVM processes for each request.

IBIJAVADIR

This setting has been superseded by IBI_USE_ JSCOM3, which is the recommended graph configuration option for the CGI/ISAPI implementation of the WebFOCUS Client. It points to the location of the JRE/JDK installation directory. It is not used by WebFOCUS Servlet.

IBIJAVACMD

This setting has been superseded by IBI_USE_ JSCOM3, which is the recommended graph configuration option for the CGI/ISAPI implementation of the WebFOCUS Client. It points to where the Java Virtual Machine (JVM) is located in order to execute Java language-based programs such as Server Side Graphics.

IBI_USE_JSCOM3

When set to YES, enables the use of JSCOM3. This setting enables the use of Server Site Graphics when the Web Server has security enabled. The CGI/ISAPI implementations of the WebFOCUS Client must use JSCOM3 if amper auto prompting is desired. To use JSCOM3:

• You must blank out the IBIF_graphservurl value (as it takes precedence when it has a value).
• IBI_USE_JSCOM3 must be set to YES.
• A JSCOM3 node must be defined and properly configured in the WebFOCUS Reporting Server ODIN.CFG file (configured by default during installation). The WebFOCUS Reporting Server must also include the following jar file in either the IBI_CLASSPATH or classpath variable:

  ...\ibi\WebFOCUS77\ibi_html\javaassist\IBIGifGraphChart.jar

The IBI_CLASSPATH is configured automatically during installation. However, the variable can be maintained either in the WebFOCUS Administration Console or in the Reporting Server Web Console. To set IBI_CLASSPATH in the WebFOCUS Administration Console, go to Special Services under Reporting Servers and modify the JSS node. To set it in the Reporting Server Web Console, Select Listeners & Special Services, then Special Services, then Configured, then JSCOM3.

For more information, see WebFOCUS Reporting Server Settings.

x

Choose the Multiple Reports category to view or edit the following settings.

IBIWF_mframename

Used to name each frame in a multi-frame report. The name of each frame will be this value followed by an index number. For example, for two frames with IBIF_mframename set to MYFRAME, the two frames will be named MYFRAME1 and MYFRAME2. MYREPORT is the default value.

IBIWF_mrcolumns

Specifies the maximum number of columns per page in multi-frame reports. 1 is the default value.

IBIWF_morder

Specifies whether the report frames in a multi-frame report should appear in the order that the columns are specified in the request or the reverse order. Valid values are FORWARD and REVERSE. FORWARD is the default value.

IBIWF_mreports

Specifies whether to create an index report, a multi-frame report, or a standard report. Valid values are OFF, INDEX, and FRAME. OFF is the default value.

IBIWF_mprefix

Specifies up to 50 characters of descriptive text that precedes a sequence number and identifies a report on a TOC. Used to create hyperlink names in index reports. For example, if the value is MyReport, the hyperlinks will be composed of the name MyReport followed by an index number starting with 1. Report is the default value. Do not use this variable if IBIWF_mreports=FRAME.

IBIWF_mrrows

Is the number of vertically stacked reports when IBIWF_mreports is set to FRAME.

IBIWF_index

Controls whether a sequence number is appended to the end of the names on the TOC when IBIWF_mreports=INDEX. ON appends a sequence number of 1 (for the first report generated) to n (for the last report generated). This value is the default. OFF omits a sequence number. Only the text specified by IBIWF_mprefix applies.

x

Choose the OLAP category to view or edit the following settings.

OLAP_DOCKED

The OLAP Control Panel is permanently displayed while running an OLAP report when set to YES. NO is the default value.

IBIF_olappos

Location of the OLAP panel (top, bottom).

x

Skin Name

Enables administrators to preview and set a new color scheme for OLAP components, such as the OLAP Control Panel.

x

Choose the On Demand Paging category to view or edit the following settings.

IBIF_odpenable

Controls display of On-Demand Paging (ODP) reports.

YES - Displays the report. Yes is the default value.

NO - Does not display the ODP report. Instead, a page with a message displays. You can specify the message text in variable IBIODP_disable_msg. If you do not, a blank line displays.

IBIODP_disable_msg

This variable contains a message, which will be displayed instead of the ODP report output when IBIF_odpenable is set to NO. A blank line is the default value.

ODP_target

Controls the action of the back-button in the Web Viewer.

ON - The Back button of the browser re-displays the first ODP page.

OFF - The Back button of the browser returns the browser to the calling page of the ODP report.

_search_begin

Opening HTML tag for highlighting text found as a result of a search in an ODP report. <u> is the default value, to underline the text.

_search_end

Closing HTML tag for highlighting text found as a result of a search in an ODP report. </u> is the default value, to underline the text.

x

Choose the Parameter Prompting category to view or edit the following settings. x

IBIF_wfdescribe

Variable for amper auto prompting for self-service reporting. Possible values are:

OFF - Turns auto prompting off. This is the default value.

XML - The XML document describing the amper variables is displayed in the browser. This setting is used internally by the WebFOCUS tools and is recommended for debugging purposes only.

XMLRUN - Only prompts for amper variables created with -DEFAULT when there is another amper variable that does not have a value assigned and, therefore, will be prompted for.

XMLPROMPT - Prompts for amper variables created with -DEFAULT and for any other amper variable that does not have a value.

Note: Managed Reporting uses a separate variable setting, which is IBIMR_prompting.

IBIF_describe_xsl_location

Specifies the location of the XSL document used to transform the XML document that describes the amper variables in the request. This variable replaces IBIF_external_xsl used in earlier releases. If the variable is blank, then the resulting document from the internal transformation is sent to the client.

IBIF_describe_xsl

Specifies the name of the XSL document used to transform the XML document that describes the amper variables in the request. A file extension is not required. This variable replaces IBIF_external_xsl used in earlier releases. If the variable is blank, then the resulting document from the internal transformation is sent to the client.

IBIF_report_xsl_location

Specifies the location of the XSL document used to transform a resulting XML report. This variable replaces IBIF_external_xsl used in earlier releases. If the variable is blank, then the resulting document from the internal transformation is sent to the client. This setting is blank by default.

IBIF_report_xsl

Specifies the name of the XSL document used to transform a resulting XML report. A file extension is not required. This variable replaces IBIF_xsl used in earlier releases. If the variable is blank, then the resulting document from the internal transformation is sent to the client. This setting is blank by default.

IBIF_describe_null

Specifies the value (_FOC_NULL or FOC_NONE) the client assigns (in -SET command) to the amper variable when the dynamic multi-select list No Selection value is selected. As of Release 7 Version 7.02, the default is _FOC_NULL. As of Release 7 Version 7.02M hotfix1, the value can be configured through Client Settings. In Release 7 Version 7.01 and earlier releases, the client always assigned the value FOC_NONE for the dynamic multi-select list No Selection value. For more information about _FOC_NULL and FOC_NONE, see Chapter 3, Coding a User Interface, in Developing Reporting Applications.

IBI_AUTOPROMPT_CGI_PROG

Overrides the client path for CGI, ISAPI, or WFServlet for WebFOCUS AUTOSIGNON feature.

x

Choose the Performance category to view or edit the following settings.

WF_OPTIMIZEIO

Enhances request processing for the WebFOCUS Reporting Server.

WF_BURST_OUTPUT

Enables the WFServlet to send simple HTML reports to the WebFOCUS Client faster. If the request is being redirected, or if it is a complex ODP or OLAP report or a report with frames, this option should be turned off.

WF_DATATRANSFER_SIZE

Sets the amount of data (in MBs) that is sent per request. For example, if the file is 6 MBs and the WF_DATATRANSFER_SIZE is 3, two requests are sent, each with half of the data.

If the variable is not specified or is equal or less than 0, 1 MB of data is sent for each request. This is used by Developer Studio when sending files to the approot directory.

x

Choose the Plugin category to view or edit the following settings.x

WFTRANSINOUT

Is a fully qualified Java class that does the transin/transout processing (processing of a request to/output returned by the WebFOCUS Reporting Server) for a plug-in for the Servlet version of the WebFOCUS Client. This class must implement the WFTransInOutInterface Java class. For example, one use of this class can be to enable data that is passed between the WebFOCUS Reporting Server and the Servlet to be parsed for bi-directionality (left/right versus right/left strings).

For more information about writing a WebFOCUS plug-in, see Developing Your Own WebFOCUS Plug-in.

WFEXT

Specifies the qualified name of a WebFOCUS plug-in class to be invoked by the WebFOCUS Servlet. By default, this variable is set to ibi.webfoc.WFEXTDefault, which is the default plug-in supplied with WebFOCUS that contains several useful functions.

x

For more information about writing a WebFOCUS plug-in, see Developing Your Own WebFOCUS Plug-in.

x

Choose the Web Services category to view or edit the following setting:

IBIWFWS_encodeOutput

Specifies whether to Base64 encode the SOAP response from the WebFOCUS web service. The default value is NO.

x

Choose the ReportCaster category to view or edit the following settings.

AGENT_NODE

ReportCaster Agent Listener node.

AGENT_PORT

ReportCaster Agent Listener port.

BKR_REPORT_DIR

FTP alias that is used to store ReportCaster files.

x

All Magnify settings are available in the Magnify section of the WebFOCUS Administration Console. For more information, see Magnify Settings.

x

Choose the WebFOCUS Quick Data category to view or edit the following settings.

quick_data_security

The type of logon that WebFOCUS Quick Data will use. Reporting Server is the default selection and requires no additional configuration.

If MR is selected and you click the drop-down menu for either the quick_data_domain_desc or quick_data_folder_desc setting, the Managed Reporting Logon opens. To select values for these settings, the Managed Reporting Logon must be validated with the User ID and Password of an MR Administrator who has the authority to see all of the Domains in the MR Repository. Both an MR Domain and Standard Reports folder must be selected in order to save these settings when MR is selected for the WebFOCUS Quick Data logon.

quick_data_domain_desc

The drop-down menu for this setting enables you to select the MR Domain that contains the Standard Reports folder used for the quick_data_folder_desc setting.

quick_data_folder_desc

The drop-down menu for this setting enables you to select the top level Standard Reports folder within the selected domain where WebFOCUS Quick Data SAFs (Structured Ad hoc Forms) can be stored. (An SAF contains a report procedure that is tied to a data source and enables users to select from a series of parameters to create a data set that can be analyzed using WebFOCUS Quick Data.)

quick_data_form_only

The Use guided ad hoc forms only check box is enabled for this setting when you select MR for the quick_data_security setting and specify a Domain for the quick_data_domain_desc setting to specify the location of Quick Data SAFs (Structured Ad hoc Forms). Selecting the check box restricts users from SAFs with ad hoc reporting tools, for example, Report Assistant. The default value for this setting (in the cgivars.wfs file) is NO and is set to YES when the check box is selected.

Note: Only one Managed Reporting Logon menu is presented per WebFOCUS Administration Console session.

x

1. You can set the _site_profile variable in the cgivars.wfs or site.wfs file. If you use the cgivars.wfs file, you can access this variable in the Configuration section of the WebFOCUS Administration Console under General settings.

   Set _site_profile as follows

   _site_profile = -INCLUDE PROFILE

   where:

   PROFILE

   Is the name of the WebFOCUS site profile. The PROFILE file name must have a .fex extension.

   For more information about _site_profile, see Editing WebFOCUS Client Custom Settings.

2. Create your profile procedure (or procedures) and place them in a directory where the WebFOCUS Reporting Server is configured to look for WebFOCUS procedures. You can place any WebFOCUS or Dialogue Manager commands in these profiles. Note that they execute after edasprof.prf and before the report procedure being sent by the WebFOCUS Client.

Note: If you want the profile to launch a WebFOCUS procedure, IBIF_ex is generally used by self-service applications and IBIF_adhocfex is used by Managed Reporting, OLAP, and Developer Studio. ReportCaster is not supported. Once you have completed these steps, the profile procedure (or procedures) automatically execute. There is no need to restart or recycle the server. The WebFOCUS Site Profile is not processed during a Reporting Server sign-on. It is only processed when running a procedure. Therefore, you cannot use it to record sign-on events.

x

1. Click Configuration and then Startup Parameters. The following image shows the Startup Parameters window.

   

2. To modify or remove Startup Parameters, perform the following steps:

   To modify a configuration setting. Select the setting (for example, ENCRYPT_WF_USER) and then click Modify. The Modify Settings window appears with the selected setting.

   

   At installation time, the parameters marked optional are not in the ibiweb.cfg file. Modifying them adds them into the file.

   To remove a setting. Select the setting (for example, ENCRYPT_WF_USER) and then click Remove Setting. Only settings marked optional can be removed and only if they have been modified (until you modify them, they are not in ibiweb.cfg). If you attempt to remove a setting that is not optional, a message displays telling you that you cannot remove the setting. Settings are removed from the ibiweb.cfg file, but not from the Console display. However, to indicate that they have been removed, the word optional next to the setting no longer appears.

   

   You can modify the setting after it has been removed and it will be added back into ibiweb.cfg.

3. Specify your changes to the ibiweb.cfg file and then click Save to save your changes.

x

The following settings may be added, modified, or deleted in the ibiweb.cfg file: x

x

DEVELOPERS = [*|dev1;dev2]

[*|dev1;dev2]

Specifies user IDs that can access quick links. This setting also controls certain Developer Studio features, such as the ability to deploy an application and write to the Web server directories. If you change this setting from an asterisk (*) to a list of developer user IDs, then these features will be available only to the specified developer user IDs. Developers can set these WebFOCUS Client credentials under the WebFOCUS Environments properties in Developer Studio.

For information about requirements for developer IDs, see the description of the IBIWFC_AUTHENTICATION parameter.

* - Signifies that any user ID is valid.

dev1;dev2 - Are user IDs that can access the resources under the Quick Links menu. In Developer Studio, these user IDs can issue application commands.

For more information about application commands, see the Developer Studio Application Development Getting Started manual.

x

ADMINISTRATORS =admin1;admin2

Admin is the default value.

For information about requirements for administrator IDs, see the description of the IBIWFC_AUTHENTICATION parameter.

admin1;admin2 are user IDs that can issue configuration commands and application commands.

x

IBIWFC_AUTHENTICATION=[NONE|EDA|EDA:EDANODE|WEB|WEBHDR:httpvariable|MR]

Optionally specifies the authentication method used to verify the administrator or developer user IDs.

where:

NONE

Is the default value, which means that no password authentication is desired.

EDA

Indicates authentication against the default WebFOCUS Reporting server. Any user IDs stored in the ADMINISTRATORS and DEVELOPERS parameters must be able to connect to the default WebFOCUS Reporting Server (IBI_REPORT_SERVER).

x

EDANODE:EDANODE

Indicates authentication against a particular WebFOCUS Reporting Server. Only one EDANODE may be listed. If an EDANODE has been specified, then any user IDs stored in the ADMINISTRATORS and DEVELOPERS parameters must be able to connect to that EDANODE.

WEB

Indicates Web server authentication. If using the WFServlet, J2EE role based security is required for the WEB setting. Any user IDs stored in the ADMINISTRATORS and DEVELOPERS parameters must be able to connect to the Web server specified in the WebFOCUS configuration.

WEBHDR:httpvariable

Indicates Web server authentication against the userid found in the HTTP variable you specify in the input box.

MR

Indicates WebFOCUS Administration Console authentication against the Managed Reporting user ID.

x

MRUSERLOG

This log should be enabled only when requested by a customer support representative. It determines whether a log file of user actions is created and, if so, how frequently:

• Off does not create a log file.
• Daily basis creates a log file on a daily basis.
• Hourly basis creates a log file on an hourly basis.

The MR User Log files are created in the location specified by the TRACE_LOCATION variable. The names of the log files have the following format:

mr_user_MMDD[_HH].log

where:

user

Is the value of the IBIMR_user variable.

MM

Is a two-digit number to indicate the month. The first month of the year is JANUARY, which is 01.

DD

Is a two-digit number to indicate the day of the month. The first day of the month has the value 01.

[_HH]

Is shown when the HOUR value of the MRUSERLOG variable is chosen. HH is a two-digit number to indicate the hour of the day using the 24-hour clock. For example, at 10:04:15.250 PM, HH is 22.

x

TRACE={ON|OFF}

Used to enable and disable tracing. This setting includes WFAPI and client connector traces (NGXXJ or JLINK) and is set automatically when you enable or disable traces using the trace options under the Diagnostics menu. Tracing can be turned on or off at any time (the Web server does not need to be restarted). Every request generates a new trace file.

ON - Turns tracing on.

OFF - Turns tracing off. It is the default value.

x

CONNECTOR_TRACE={ON|OFF}

When this setting is ON, connector traces (NGXXJ or JLINK) are enabled. This trace can also be enabled using the Client Connector trace option under the Diagnostics menu.

Also, setting TRACE=ON overrides the CONNECTOR_TRACE setting. When TRACE=ON is set, the Client Connector trace information is included within the trace file of the component (for example, WFServlet) that uses the WebFOCUS API (WFAPI) to make use of the client connector.

x

PROCEDURE_LOG={ON|OFF}

When this setting is ON, procedure traces are enabled. You use the trace panel itself to enable the procedure trace. Doing so automatically updates this variable. OFF is the default value. The procedure trace writes the output procedure sent to the WebFOCUS Reporting Server to the trace file. It contains only the packaged request and is used only for debugging purposes.

x

ENCRYPT_WF_USER={YES|NO}

Setting this variable to YES encrypts the WebFOCUS user cookie (WF_USER).

The WF_USER cookie is not encrypted by default.

x

The following describes different product behaviors when utilizing Redirect and Save Report functionality with EXCEL, EXL2K, EXL2K TEMPLATE, and Excel 2007 report formats:

• To change redirection settings or set the Save As option for EXL2K TEMPLATE reports, select the .xmh WebFOCUS Extension in the Redirection Settings panel. By default, EXL2K TEMPLATE reports that contain the ON TABLE PCHOLD FORMAT EXL2K TEMPLATE command are created with the SET WEBARCHIVE=ON command, which generates a web archive file format (.xmh).
• To open an Excel 2007 report in MS Office Excel 2003, you must have the following:
  • In your Windows environment, associate the .xlsx extension with Microsoft Office Excel.
  • Install the Microsoft Office conversion utility, which enables Excel 2003 (or earlier versions) to open Excel 2007 documents. This utility is available at the Microsoft download site.
  • Optionally, set the Save Report option for the .xlsx WebFOCUS extension in the Redirection Settings panel to yes. If the Save Report option is set to no and Microsoft Excel 2007 is not installed on the user machine, the following prompt displays:

    

    The prompt displays when the Excel 2007 content-type information associated with the report output is not recognized by an application on the end user machine. The user can click Save and save the report using an .xlsx extension. The report can then be opened from the file system once the .xlsx file type has been associated with the Microsoft Excel application.

• For the EXL2K report format,
  • If the report request contains the SET WEBARCHIVE=ON command, set the Redirect and Save Report options for the .xmh WebFOCUS extension.

    Note: In WebFOCUS 7 Release 6.10, the EXL2K Pivot format uses the SET WEBARCHIVE=ON command by default and therefore does not need to be added to the report procedure.

  • If the report request uses SET WEBARCHIVE=OFF, set the Redirect and Save Report options for the .xht WebFOCUS extension.
• For the EXL2K Pivot format, you must use one of the following settings:
  • Enable the redirection setting for the .xht WebFOCUS extension.
  • For WebFOCUS 7 Release 6.9 and earlier, add the SETWEBARCHIVE=ON command in the report procedure.

    Note: In WebFOCUS 7 Release 6.10, the EXL2K Pivot format uses the SET WEBARCHIVE=ON command by default and therefore does not need to be added to the report procedure.

  Otherwise, an error message displays with the xml file for the pivot table specifying that there are problems loading the file. You can click OK to load the report, but when accessing the pivot table in the report the following error message displays:

  The PivotTable Report is not valid.

• When using Microsoft Excel 2002 or 2003, two or more reports produced by a PCHOLD FORMAT EXL2K command cannot be opened simultaneously, when the names of the documents are the same. The name of the document is a result of processing done by the browser and Microsoft Excel, which obtains the name of the document from the report request and may produce the following message indicating that the documents cannot be opened at the same time:

  

  To create multiple workbooks in Microsoft Excel, set the Save Report option to yes for the following WebFOCUS extensions:

  • .xht for EXL2K report formats.
  • .xmh for EXL2K report requests with the SET WEBARCHIVE=ON command.
  • .xls for EXCEL report formats.

  Note: When the Save Report option is set to yes, it is recommended that you use the AS command for each request so that each report output contains an assigned name. If the AS command is not specified, the name of the report output is randomly generated.

  Setting the Save Report option to yes allows users to compare the output of multiple workbooks simultaneously. By default, a new Excel session opens in a separate Excel window. This behavior may be different for users who expect Excel to start as a Web browser plug-in. However, users can select the different view options available under the Windows menu in Microsoft Excel to see the different report outputs in the same window pane.