Skip Headers
Oracle® Fusion Middleware Administrator's Guide for Oracle Business Intelligence Discoverer
11g Release 1 (11.1.1)

Part Number B32519-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF

Load Wizard: Step 4 dialog

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:

"What is the Load Wizard?"

"How to create a business area using the Load Wizard"

Do you want to create joins?

Yes, create joins from:

Use this check box to create joins on items in the business area.

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.

Date hierarchies:

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.