|Oracle® Fusion Middleware Administrator's Guide for Oracle Business Intelligence Discoverer
11g Release 1 (11.1.1)
Part Number B32519-02
Use this dialog to configure the joins and additional objects that Discoverer generates when data is loaded into the new business area.
For more information, see:
Do you want to create joins?
Yes, create joins from:
Use this check box to create joins on items in the business area.
Primary/foreign key constraints
Use this option to create joins on primary and foreign keys. For example, if Regions contain many Stores, the primary key Region.Region Name might be joined to the foreign key Stores.Region Name.
It is recommended that you use this option:
when primary and foreign key constraints are defined in the database
You use this option because:
it saves you having to create the joins manually
Discoverer always creates joins that are correct (that is, the master and detail relationship is specified the right way round)
Matching column names
Use this option to create joins on matching column names in the database tables. You use this option when no primary and foreign key constraints are defined, for example, if you are using a non-Oracle data source.
If you choose this option, Discoverer checks every column name of every object being loaded against every other column name. As the number of columns that are loaded increases, the amount of processing required also increases. A side effect of doing this is that the joins created must be checked after the load to make sure they are valid. The master-detail folder relationship must be verified as being the correct way round, and the join condition must be verified as being valid (that is, not created accidentally by two different columns using the same name.)
What additional objects do you want to generate?
Summaries based on folders that are created
Use this check box to use automated summary management (ASM) to create summary folders after the load process, based on folders that Discoverer creates.
ASM attempts to create a set of suitable summary folders after analyzing the table structure. Selecting this option might slightly increase duration of the business area load, but should give end users improved query performance.
Note: Do not choose this option if you are going to run ASM, or if your database space is low.
Use this check box to automatically create date hierarchies for date items.
Choose a hierarchy from the drop down list of default date hierarchy formats. The date hierarchy is applied to all date columns in the business area. Creating a date hierarchy enables end users to drill up/down through date items. For example, from years to quarters or from months to days.
Automatically generating date hierarchies inserts additional (calculated) items into the folder. An extra item is created for every date item in each node in the date hierarchy. For example a date hierarchy containing year|quarter|month|day applied to a table with three date columns, generates an additional 12 items in the folder. For more information, see "Creating and Maintaining Hierarchies".
Default aggregate on data points
Use this check box to specify a default aggregate for numeric items.
Choose an aggregate from the drop down list. The default aggregate is SUM.
List of values for items of type:
Use this check box to generate lists of values based on the types you select. This option automatically creates lists of values for each axis item of each type specified, except character items longer than 40 characters. The values are derived from the values in the database column.
Items are loaded as data points if they are DECIMALS (that is, a NUMBER data type) and have a nonzero scale. Integer numbers, all keys, and all other data types are loaded as axis items, with a default position of Top.
Axis items are usually displayed on one of the axes of a worksheet. For example, the term Monthly Profit might be an axis item in a worksheet.
The alternative term for an axis item is a dimension.
Data points are usually displayed in the body of a worksheet. For example, an amount in dollars (for example, $2,000) might be a data point item representing Monthly Profit in a worksheet.
The alternative term for a data point is a measure.
Because data points usually include the numbers that users want to analyze, they are displayed by default with aggregate functions in the center of cross tabular reports.
Axis items can have lists of values but data points cannot. Axis items appear on the page, top, or side of cross tabular worksheets by default.
The default position of an axis item or data point item in a worksheet is determined by the Discoverer manager. However, Discoverer Plus users can alter the position of axis items and datapoint items in a worksheet.
Lists of values are derived by querying the database when Discoverer users click the plus (+) symbol next to the item. Lists are dynamic and change if the values in the database change. When the plus (+) symbol is clicked, Discoverer caches the values on the client machine for performance reasons, unless the Cache list of values during each connection check box is cleared, when creating or editing an item class in the following dialogs:
Item Class Wizard: Step 4/5 dialog
Edit Item Class dialog: Options tab
If you select the Cache list of values during each connection check box and you want to display new values in a list, you must reconnect (for more information about this setting, see "Edit Item Class dialog: Options tab").
Avoid creating lists of values on items that will contain many values (for example, decimals).