NoetixViews with Oracle Discoverer – Level 2

Course: NoetixViews with Oracle Discoverer – Level 2
Duration: 2 Days (9:00am – 4:30pm)
Tuition Public: $1,500 US/£800 UK
Tuition Private: $8,500 US/£4,500 UK for up to 12 students

Who Should Attend
Business analysts and related professionals, including system analysts, programmers and report developers who are familiar with NoetixViews and their use with Oracle Discoverer, and desire further competency in developing custom reports.

What You Will Learn
You’ll be instructed on creating and customizing reports using advanced calculations and conditional filters. You’ll also learn how to manage reports in workbooks, schedule reports to execute on schedule, and to export reports to be viewed and managed in other reporting applications such as Microsoft Excel.

Key learnings include:

• Review of NoetixViews for Oracle E-Business Suite solution
• Review of Oracle’s Discoverer environment
• Execute and modify existing workbooks
• Create a simple table layout worksheet
• Create a simple crosstab layout worksheet
• Manage workbooks and worksheets
• Program advanced features of Discoverer and SQL
• Navigate the Worksheet Wizard to create new worksheets
• Select Business Areas, Folders, Joins, Items
• Define the layout for TABLE or CROSSTAB worksheets
• Define Simple conditions and calculated items
• Sort order of records
• Define Totals, subtotals and exception formats
• Manage outer joins vs. inner joins and multiple folder worksheets
• Complex and nested conditions
• Parameters in conditions and calculated items
• Complex calculated items using SQL Functions
• Character String, Number, Date, Conversion and Other functions
• Multiple worksheets workbooks, sub-queries and correlated sub-queries
• Export worksheets to Excel, HTML, TXT, etc.
• Scheduling workbooks / worksheets
• Command line execution
• Graphing worksheets