In this example, the PARALLEL hint overrides the degree of parallelism specified in the emp definition.Įxample 6: CONNECT BY Clause in a custom folder definition SELECT /*+ FULL(scott_emp) PARALLEL (scott_emp, 5) In this example, the (SELECT AVG (SAL) FROM EMP) subquery is included in the folder definition.Įxample 5: Optimizer hint in a custom folder definition The result set is the union of all employees with a column named COMPANY1 to show which company they are from.Įxample 4: Subquery in a custom folder definition SELECT 'COMPANY1' COMPANY, ENAME, SAL FROM 'COMPANY2' COMPANY, ENAME, SAL FROM this example, HQ and REGIONA are database links for remote databases. SELECT BRAND FROM this example, PRODUCT is a table in another database, and DATABASELINK is the database link to the other database.Įxample 3: Set Operator in a custom folder definition The underlying table or view to which the synonym points, can be switched without changing the custom folder definition in Discoverer, provided the column names of the table or view to which the synonym points, do not change.Įxample 2: Database link in a custom folder definition In this example, PROD is a synonym that points to the product table. "Example 8: Using a custom folder to improve LOV performance"Įxample 1: Synonyms in a custom folder definition "Example 7: Column Expression in a custom folder definition" "Example 6: CONNECT BY Clause in a custom folder definition" "Example 5: Optimizer hint in a custom folder definition" "Example 4: Subquery in a custom folder definition" "Example 3: Set Operator in a custom folder definition" "Example 2: Database link in a custom folder definition"
"Example 1: Synonyms in a custom folder definition" This section consists of the following examples: Folders that exist in the EUL but which are not currently assigned to a business area are referred to as orphan folders. You can remove a folder from all business areas without deleting it from the EUL. Note that a folder has a single definition, regardless of the number of business areas to which you assign it. Items in a folder can be used in summary folders and to define hierarchies.ĭiscoverer end users work with folders within the context of business areas.Īs the Discoverer Manager, you can assign a folder to one or more business areas. Folders can include items, calculated items, joins, conditions, item classes, and hierarchies. Even in Discoverer Administrator, there is very little difference in the behavior of these different types of folders. Whether a folder is simple, custom, or complex is only important to the Discoverer manager. To the Discoverer end user, the type of a particular folder is immaterial. Simple folders, which contain items based on columns in a single database table or viewĬomplex folders, which can contain items based on columns from multiple database tables or viewsĬustom folders, which are based on SQL statements As the Discoverer manager, it is your responsibility to create suitable folders to enable Discoverer end users to access the information they need. Discoverer end users select items from one or more folders to get information from the database. A Discoverer folder represents a group of related items.
Jaikoz creating additonal folders windows#
The visual concept of a folder in Discoverer is analogous to a directory in Windows where folders are the containers and items are the files held in the folders. "How to validate folders in a business area"Ī Discoverer folder is a representation of result set data. "How to re-order folders in a business area" "How to remove an orphaned folder from the EUL" "How to view orphaned folders in the EUL"
"How to assign a folder to multiple business areas" "How to assign folders to a business area" "How to delete folders from a business area"
"How to edit a custom folder's SQL statement" "How to create simple folders from the database" "What rules and restrictions apply when you use complex folder reach through?" "How to define a complex folder to enable reach through to the base folders" "About sharing folders across business areas"
This chapter explains how you create and maintain folders using Discoverer Administrator, and contains the following topics: 11/165 6 Creating and Maintaining Folders
0 kommentar(er)
