Use this dialog to set properties for the currently selected folder. For example, to change the name of a folder, or to specify whether the folder is visible to end users.
For more information, see:
"How to edit folder properties"
"What is complex folder reach through?"
The Folder Properties dialog displays the following tabs for a simple folder, for more information, see:
The Folder Properties dialog displays additional tabs for a complex folder, for more information, see:
Use this tab to configure the properties of the current folder.
For more information, see "What are folders?".
Use this field to enter a unique name for the folder. The contents of this field are displayed in the Discoverer Plus folder selection dialog. The name of the folder must be unique in the End User Layer. You cannot have two folders with the same name, even in different business areas.
Note: If you change the name of an item, this might affect the names of secondary elements (for example, joins, hierarchies, hierarchy nodes, item classes) that have the Auto generate name property set to Yes (for more information, see "About generating and updating EUL item names automatically").
Use this field to enter a brief description of the folder. The contents of this field are displayed on the description line of the Query Wizard.
Use this field to specify whether the folder is displayed to the end user in the Discoverer Plus Query Wizard. Choose Yes to display this folder. You can use this property to hide items that are not directly of value to the end user, but need to be included in the business area because of joins or calculations. Folders not visible to the end user will be displayed in Discoverer Administrator in gray to indicate their hidden status.
This field specifies the location of the source database which stores the table corresponding to the folder. To change the database, click this field to display the Choose Database dialog and select from the drop down list.
Note: This field is read-only for complex folders.
This field specifies the database user ID or owner of the table or view corresponding to the folder.
Note: This field is read-only for complex folders.
To change the owner, either type in the owner directly or click the field and then click the button to display the Choose user dialog where you can select from the list.
The Owner field can be left blank. In this case the owner property is not specified in subsequent SQL references (through Discoverer Plus) to that folder. For example, a SQL select statement could now read as follows:
select <column> from <table>
rather than:
select <column> from <owner>.<table>
This is useful as it enables you to create/maintain an EUL for which the tables or table owners are not yet available, or to which the EUL administrator does not have access. It also enables multiple users (such as Oracle Applications users) each with their own schema in an EUL, to access their schema tables when making queries in Discoverer Plus.
This field displays the name of the database object that corresponds to this folder. If a new table or view name has been chosen, it will appear here. To change the object, click this field to display the "Choose user or table/view dialog" and select from the list. You can choose an object from a different owner or a different business area.
If you select an Object name, the Database and Owner fields will also be re-populated with the database and owner values of the selected Object (irrespective of whether the Owner field was blank or not).
Note: This field is read-only for complex folders.
Use this field to place a specific optimizer hint against the folder. The hint is not visible in Discoverer Plus. For more information about how to use optimizer hints, see an appropriate release of the Oracle designing and tuning for performance documentation.
A unique name that Discoverer uses to identify EUL and workbook objects. When matching objects common to different EULs, Discoverer uses identifiers to locate objects in different EULs that refer to the same business object. For more information, see "What are identifiers?".
Warning: It is not advisable to change an identifier as it can affect the relationships between EUL objects.
Automatically save changes after each edit
Use this check box to save changes each time a field in this dialog is updated.
If the Owner field is left blank, summary tables (in Oracle Standard Edition databases) based on this folder are not allowed. If a summary folder already exists a warning message is displayed.
If the Owner field is changed, summary tables (in Oracle Standard Edition databases) based on this folder need to be refreshed. If a summary folder already exists a message is displayed advising you to refresh the summary folders based on this folder.
The Dependents tab displays two columns (Type and Name) that clarify the extent to which other objects (for example, folders, joins, items, item classes, summaries, conditions, calculations, workbooks, scheduled workbooks) are dependent on the selected folder.
For more information, see "What are folders?".
This field displays the type of item that has a dependency on the current folder. For example, folders, conditions, summaries, workbooks, scheduled workbooks.
This field displays the name of each item that has a dependency on the current folder.
This tab displays all component folders (and their items and joins) that are used by this complex folder.
For more information, see "What are complex folders?".
Use the + and - icons to expand and collapse the tree.
Note: This tab is only displayed for complex folders.
This tab displays the base folders that you can define as reach through enabled for the currently selected complex folder. If a worksheet contains items from the complex folder, Discoverer end users can add additional items from reach through enabled base folders.
For more information, see "What is complex folder reach through?".
Use the check box to enable reach through for this base folder.
Note: This tab is only displayed for complex folders.