Skip Headers

Oracle9iAS Discoverer Configuration Guide
Version 9.0.2

Part Number A95458-02
Go To Documentation Library
Home
Go To Product List
Solution Area
Go To Table Of Contents
Contents
Go To Index
Index

Go to previous page Go to next page

7
Editing Discoverer preferences

7.1 Editing Discoverer preferences

This chapter explains how to manage Oracle9iAS Discoverer preferences, and contains the following topics:

7.2 What are Discoverer preferences?

Discoverer preferences are settings that define the Discoverer environment and control the behavior of Discoverer Plus and Discoverer Viewer.

There are two types of Discoverer preference:

The relationship between the Discoverer system preferences and the Discoverer user preferences is shown in the diagram below:

Figure 7-1 Discoverer user preferences


Text description of discpref.gif follows.
Text description of the illustration discpref.gif

7.3 About Discoverer system preferences

Discoverer system preferences are created and set during installation. Typically you will never have to modify the Discoverer system preferences. On UNIX systems, the Discoverer system preferences are stored in a file called discwb.sh. On Windows systems, the Discoverer system preferences are stored in the Windows Registry.

For more information about Discoverer system preferences, see Section 7.9, "List of Discoverer system preferences".

7.4 About Discoverer user preferences

During Oracle9iAS installation, Discoverer uses factory supplied default values (stored in defaults.txt) to create user preferences for all Discoverer users (stored in pref.txt).

When a new user starts an Oracle9iAS Discoverer session for the first time, the settings in the pref.txt file take effect as that user's default settings.

After installation, the user preferences can be changed in a number of ways:

Notes:

7.5 How to set user preferences for all users

To set user preferences for all users:

  1. Open the pref.txt file in a text editor (to find out the location of this file, see Section A.2, "List of Discoverer file locations").

    Hint: If you are using Windows, you can open the pref.txt file in Notepad from the Windows Start menu by choosing Programs | Oracle9iAS Discoverer Server Setup | Edit Preferences.

  2. Edit the items in the pref.txt file as required.

  3. Save the file and close the text editor.

    For the changes you have made to pref.txt to take effect, you must apply the preferences.

  4. Apply the preference changes you have made, as follows:

    • on UNIX, navigate to the directory containing the applypreferences.sh file and type the following at the command prompt:

      applypreferences.sh
      
      

      To find out the location of the file, see Section A.2, "List of Discoverer file locations".

    • on Windows, from the Windows Start menu choose Programs | Oracle9iAS Discoverer Server Setup | Apply Preferences. Alternatively, type the following at the command line:

      dis51pr -apply
      
      

    Hint: If you suspect that the pref.txt file contains errors, check the error.txt file in the current directory.

7.6 How to set individual preferences for specific users

To set individual preferences for specific users:

  1. From the command prompt, navigate to the directory containing the dis51pr executable file.

    To find out the location of the file, see Section A.2, "List of Discoverer file locations".

  2. Enter a command at the command line, using the following syntax:

    dis51pr -user <user> -setpref "<pref category>" "<pref name>" <pref value> 
    -apply
    
    

    where:

    • <user> is the name of the user for which you want to set the preference value, followed by the @ symbol, followed by the name of the database

    • <pref category> is the category of the preference you want to change

    • <pref name> is the name of the preference you want to change

    • <pref value> is the value you want the preference to have

    Examples:

    • if you wanted to set the default EUL for the user jchan, you would type the following:

      dis51pr -user jchan@salesdb -setpref "Database" "DefaultEUL" "\sales"\ 
      -apply 
      

Notes:

7.7 List of Discoverer user preferences

This table shows the category, description, default value, and valid values of Discoverer user preferences.

User preference name  Category  Description  Default value  Valid values 

AppsFNDNAM 

Database 

Specifies the schema in which certain vital Oracle Applications data is stored. 

APPS 

Valid Apps foundation name 

AppsGWYUID 

Database 

Specifies the public username and password for the AOL security DLL. 

APPLSYSPUB/PUB 

Valid Apps username and password 

AvoidServerWildcardBug 

Database 

Set to 1 if running against RDBMS 7.3.2 with NLS_LANG set to Japanese_Japan.JA16SJIS to avoid certain list box appearing empty. 

0 = not running against RDBMS 7.3.2 with NLS_LANG set to Japanese_Japan

1 = running against RDBMS 7.3.2 with NLS_LANG set to Japanese_Japan 

Axis Style 

Crosstab 

Crosstab axis position. 

1 = inline

2 = outline 

BusinessAreaFastFetchLevel 

Database 

Controls the amount of pre-caching that occurs for components and items whenever a Business Area is fetched. 

CacheFlushPercentage 

Application 

Percentage of cache flushed if the cache is full. 

25 

User specified 

Cell X Gridline 

Crosstab 

Show horizontal gridlines. 

0 = no

1 = yes 

Cell X Gridline 

Table 

Show horizontal gridlines. 

0 = no

1 = yes 

Cell Y Gridline 

Crosstab 

Show vertical gridlines. 

0 = no

1 = yes 

Cell Y Gridline 

Table 

Show vertical gridlines. 

0 = no

1 = yes 

DataFormat 

Application 

Applies HTML formatting to data cells in worksheets. 

"<fontFormat fontName="Dialog" pitch="10" bold="false" italic="false" underline="false" strikethrough="false" foreground="0,0,0" background="255, 255, 255" halign="right" valign="top"></fontFormat>" 

User specified 

DefaultEUL 

Database 

Sets the EUL you want all users to connect to. Each user can override this default from the Discoverer Plus Options dialog. 

Any EUL you have created. 

Any valid EUL 

DefaultUserTypeIsApps 

Administrator 

Specifies whether Discoverer Plus and Discoverer Viewer users default to Oracle Applications.

If the Oracle Applications User check box is displayed on the Create New Connection page, this setting is used to clear (0) or select (1) the check box by default.

If the Oracle Applications User check box is not displayed on the Create New Connection page, this setting is used to set the default login type (0 for non-Oracle Apps, 1 for Oracle Apps).

For more information, see Section 14.3, "About Discoverer configuration settings for Oracle Applications"

0=No

1=Yes 

DisableAutoOuterJoinsOn
Filters 

Database 

This setting toggles the behavior of Discoverer when running queries involving an outer join with a condition (or conditions) applied.

The effect of this setting is fully explained in the Oracle9i Discoverer Administrator Administration Guide

0 = Do not disable outer joins on filters

1 = Disable outer joins on filters 

DisableAutoQuery 

Database 

If set to 0, queries do not automatically run when a worksheet opens. 

0 = on

1 = off 

DisableFanTrapDetection 

Database 

Disables detection for fan trap in user queries. 

0 = on

1 = off 

DisableMultiJoinDetection 

Database 

This setting toggles multiple join path detection when creating worksheets in Discoverer Plus.

When this setting = 1, Desktop selects all join options when creating a worksheet.

When this setting = 0 and multiple joins exist, Discoverer Plus displays the Join Folders dialog where you choose the join(s) to use for the worksheet. Note: It is recommended that Discoverer Plus users select all available joins for Discoverer to display accurate results data. 

1 = Disable multiple join detection

0 = Do not disable multiple join detection 

EnhancedAggregationStrategy 

Database 

Determines if Enhanced Data Aggregation is to be switched on and if so, what SQL generation strategy to use.

For more information about the values, see "About the EnhancedAggregationStrategy user preference setting"

0 = Off

1 = Strict Grouping Sets

2 = Optimized

3 = Cube

4 = Auto Determine 

ExcelVersion 

Application 

Specifies the version of Excel to export to.

Different versions of Excel impose different limits on the number of rows per sheet:

  • the Excel95 limit is 16384 rows per sheet

  • the Excel97 limit is 65536 rows per sheet

  • the Excel2000 limit is 65536 rows per sheet

If the limit is exceeded, Discoverer places additional rows on additional Excel sheets. 

Excel95

 

Excel95

Excel97

Excel2000 

HeadingFormat 

Application 

Applies HTML formatting to heading cells in worksheets. 

"<fontFormat fontName="Dialog" pitch="10" bold="false" italic="false" underline="false" strikethrough="false" foreground="0,0,0" background="204, 204, 204" halign="left" valign="top"></fontFormat>" 

User specified 

ItemClassDelay 

Database 

Fetch list of values for this amount of time before timing out. 

15 (seconds) 

User specified 

MaterializedViewRedirectionBehavior 

Database 

Materialized view redirection. 

0=always when available

1=always when summary data not stale

2=never 

MaxVirtualDiskMem 

Application 

Maximum amount of disk memory allowed for the data cache. 

1024000000 

User specified 

MaxVirtualHeapMem 

Application 

Maximum amount of heap memory allowed for the data cache. 

1024000000 

User specified 

NullValue 

Application 

Specifies how null values are displayed in worksheets, for example, 'NULL', 'N/A', '0'. 

NULL 

User specified 

ObjectsAlwaysAccessible 

Database 

Verify that Business Area objects and items exist in the database. 

0=verify

1=do not verify and assume that the objects and items exist 

PredictionThresholdSeconds 

Database 

Warn user if the predicted query time will exceed the number of seconds. 

60 (seconds) 

User specified 

PredictionThresholdSeconds
Enabled 

Database 

Query prediction threshold disabled (0) or enabled (1). 

0 = disabled

1 = enabled 

QPPAvgCostTimeAlgorithm 

Database 

 

 

QPPCBOEnforced 

Database 

Will use cost-based optimizer if set to 1. Will use default optimizer if set to 0. 

0 = use default optimizer

1= use cost based optimizer 

QPPCreateNewStats 

Database 

Records new statistics if set to 1. 

0 = false

1 = true 

QPPEnable 

Database 

Uses query prediction/performance (QPP) if set to 1. 

0 = false

1 = true 

QPPLoadStatsByObjectUseKey 

Database 

Records statistics for same objects first if set to 1. 

0 = false

1 = true 

QPPMaxObjectUseKey 

Database 

Affects the amount of statistics to cache in memory for query prediction. 

30 

User specified 

QPPMaxStats 

Database 

Only loads this many previous statistics. 

500 

User specified 

QPPMinActCpuTime 

Database 

Only records or uses statistics with a CPU time greater than this value. 

User specified 

QPPMinActElapsedTime 

Database 

Only records or uses statistics with an actual elapsed time greater than this value. 

User specified 

QPPMinCost 

Database 

Only records or uses statistics with a cost greater than this value. 

User specified 

QPPMinEstElapsedTime 

Database 

Only records or uses statistics with an estimated elapsed time greater than this value. 

User specified 

QPPObtainCostMethod 

Database 

 

 

QPPUseCpuTime 

Database 

Query prediction uses CPU time within its algorithm. 

0 = false

1 = true 

QueryBehavior 

Application 

Action to take after opening a workbook. 

0 = Run Query Automatically

1 = Do not Run Query

2 = Ask for Confirmation 

QuerySQLFastFetchLevel 

Database 

 

 

QueryTimeLimit 

Database 

Limit on query time in seconds. 

1800 (seconds) 

User specified 

QueryTimeLimitEnabled 

Database 

Query time limit disabled (0) or enabled (1). 

0 = disabled

1 = enabled 

RdbFastSQLOff 

Database 

 

 

Row Headings 

Table 

Display row numbers on table worksheets. 

0 = no

1 = yes 

RowFetchLimit 

Database 

The maximum number of rows fetched. 

10000 (rows) 

User specified 

RowFetchLimitEnabled 

Database 

RowFetchLimit parameter is disabled (0) or enabled (1). 

0 = disabled

1 = enabled 

RowsPerFetch 

Database 

The number of rows to fetch at once. 

100 (rows) 

User specified 

RowsPerHTML 

Session Manager 

Number of rows to display per HTML page. 

10 

User specified 

ShowDialogBitmaps 

Application 

End users see the bitmap graphics on Discoverer Plus dialogs. 

0 = off

1 = on 

ShowUserTypeChoice

 

Administrator 

Activates an end-user check box that allows users to specify whether they want to run Discoverer Plus against an Oracle Application.  

0  

0 = hide check box

1 = show check box

 

SQLTrace 

Database 

False (off).

 

0 = false

1 = true 

SummaryObjectsUseCachedAccessibility 

Database 

Controls whether to access the summary-derived objects in the cache. 

 

SummaryThreshold 

Database 

Use summary table only if it is no older than this number of days. 

30 (days)

 

User specified

or

0 = do not use summary at all 

SummaryThresholdEnabled 

Database 

If enabled (1), will use the value specified by SummaryThreshold. Otherwise, Discoverer will always use summary tables if they are available. 

0 = disabled

1 = enabled 

Timeout 

Session Manager 

Amount of time (in seconds) after which Discoverer disconnects an idle session from the database. Minimum time is 180 seconds. 

1800 

User specified 

Title 

Crosstab 

Displays titles that were created in Discoverer 3.1 worksheets. 

0 = no

1 = yes 

Title 

Table 

Displays titles that were created in Discoverer 3.1 worksheets. 

0 = no

1 = yes 

TotalsFormat 

Application 

Applies HTML formatting to cells that contain totals in worksheets. 

"<fontFormat fontName="Dialog" pitch="10" bold="false" italic="false" underline="false" strikethrough="false" foreground="0,0,0" background="255, 255, 255" halign="left" valign="top"></fontFormat>" 

User specified 

UseOptimizerHints 

Database 

Will add optimized hints to SQL if set 1. 

0 = off

1 = on 

7.7.1 About the EnhancedAggregationStrategy user preference setting

The EnhancedAggregationStrategy user preference controls how Discoverer Plus and Discoverer Viewer make use of the Oracle9i database's enhanced aggregation functionality.

The settings affect the SQL that is generated for the query, dictating whether there should be an exact match between client request (from the Discoverer Server) and the aggregation levels retrieved or whether more aggregation levels are retrieved from the database than are requested by the client (from the Discoverer Server).

The table below explains the EnhancedAggregationStrategy user preference settings in more detail

Value  Description 

Off

The generated SQL contains an ordinary GROUP BY clause. 

Strict Grouping Sets

The generated SQL contains GROUPING SET requests that exactly match the GROUPING SET requests made by the Discoverer Server. The requests that the Discoverer Server makes are determined by how the end user created the worksheet.

For example, the generated GROUP BY clause might be similar to the following:

GROUP BY GROUPING SETS( (Department, Region, Year),(Department),( ) ) 

Optimized

The generated SQL contains GROUPING SET requests with additional ROLLUP functions. The use of ROLLUP functions enables the SQL to fetch more aggregation levels than requested by the Discoverer Server. This typically enables the end user to add totals or pivot without needing to re-query the database.

For example, the generated GROUP BY clause might be similar to the following:

GROUP BY GROUPING SETS( ROLLUP(Department, Region, Year), ROLLUP(Region, Year) ) 

Cube

The generated SQL contains a Grouping Set request for a CUBE of the items requested. This is the highest pre-fetch strategy for aggregation levels from the database and should be used with caution as there may be a severe performance overhead in increased query time and resource usage.

For example, the generated GROUP BY clause might be similar to the following:

GROUP BY GROUPING SETS( CUBE(Department, Region, Year) ) 

Auto Determine

Discoverer automatically determines which of the above strategies to use (i.e. 1, 2, or 3 above). 

:

7.8 List of arguments to use with the dis51pr command line utility

You can use the following commands in conjunction with the dis51pr command line utility.

Note: To see online help on the dis51pr.exe utility, type

dis51pr -help

at the command line.

7.9 List of Discoverer system preferences

This table shows the description, default value, and valid values of Discoverer system preferences. The values of system preferences are stored in the Windows Registry (for Windows systems) or the discwb.sh file (for UNIX systems).

System preference name  Description  Default Value 

DC902_ADM_PATH 

Set during install. 

<ORACLE_HOME>\adm 

DC902_INSTANCE_NAME 

Set during install. Discoverer Server Machine name. 

machine name 

DC902_OAD_LOG 

Set during install. 

<ORACLE_HOME>\discwb902\log 

DC902_OSAGENT_PORT 

Set during install. 

14000 

DC902_SERVER_HOME 

Set during install. 

<ORACLE_HOME>\discwb902\ 

DC902_START_OAD 

Set during install. 

DC902_START_OSAGENT 

Set during install. 

DC902_START_PREFERENCES 

Set during install. 

DC902_VBROKER_HOME 

Set during install. 

<ORACLE_HOME>\vbroker 

DC902_VBROKER_JVM 

Set during install. 

Location of java executable 

DISCWB902 

Set during install. 

The Discoverer install directory <ORACLE_HOME>\... 


Go to previous page Go to next page
Oracle
Copyright © 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Solution Area
Go To Table Of Contents
Contents
Go To Index
Index