Automatic Generation of an End User Layer (EUL) for Oracle Discoverer
The extensible End User Layer created by Magnitude Noetix Generator provides many key reporting benefits, including pre-defined Business Areas, folders, pre-defined joins between folders, item classes, and data drills.
Magnitude Noetix Generator for Oracle Discoverer features and benefits include:
- Integration with the Oracle E-Business Suite
Magnitude Noetix Generator for Oracle Discoverer can be administered using the Concurrent Manager to build Apps-Mode EULs that make full use of the E-Business Suite security, plus create pre-defined data drills based upon your key flexfield hierarchies.
- Indexed Columns and Item Classes
Magnitude Noetix Generator for Oracle Discoverer supports item classes by leveraging the indexed column feature of Magnitude NoetixViews, delivering quick display of unique list of values for faster data access.
- Folder and Item Descriptions
The folder and item descriptions loaded into the EUL are the same as those found in the Magnitude NoetixViews Help file, thus ensuring a consistent user experience.
- Pre-defined Joins
The Magnitude NoetixViews metadata includes pre-defined joins between views. This metadata is converted into joins between folders in the EUL, enabling users to create more sophisticated reports by including data from two or more views.
The generated EUL can be extended with additional Business Areas for access to data not available in Magnitude NoetixViews. Further, existing Business Areas can have joins between folders added to complement the pre-defined joins provided by Magnitude. The Discoverer administrator can make such changes with the assurance that they will be retained even after a regeneration of the EUL.