Contact Us
Index
Version 22.4
Version 6.0 Version 5.14 Version 5.13 Version 5.12 Version 5.11 Version 6.1 Version 6.2 Version 6.3 Version 6.4 Version 20.1 Version 20.2 Version 20.3 Version 21.2 Version 22.1 Version 22.3 Version 23.1 Version 23.2 Version 23.3 Version 23.4 Version 24.1 Version 24.2 Version 24.3 Version 24.4 Version 25.2
Contact Us
Antivirus Software
New Release Notification
User Profile
Responsibility Selection
Excel Not Ready Error
Add-In Load Error
Multiple Instances
License Key Errors
Combine Text
Last Refreshed By
Last Refreshed Time
Split Text
Snapshot
Upgrade Workbook
Shared Templates Drive
Drive Types
Dropbox
File Server
Oracle E-Business Suite Database
Navigator
Create a File
Delete a File
Edit a File
Open a File
Common Options
Custom Drill Columns
Journal Custom Columns
Journal Attachment Custom Columns
Subledger Custom Columns
Subledger SLA Custom Columns
Add a Custom Drilldown Column
System Administrator Options
System Administrator License Key
System Administrator User Permissions
System Administrator User Options
System Administrator Product Options
System Administrator Delimiter Options
System Administrator Configuration Options
System Administrator Server Information
Wands Responsibility Profile Option
Payroll Drilldown Responsibility
Custom Options
Active Data Guard Support
Report Wizard
Design Layout
Add Columns
Add Rows
Report Wizard Output
Discover Segment Values
Discover Level
Discover Period Names
Discover Segment Properties
Discover Child Ranges
Expand and Explode
Expand Segment Values
Expand Segment Value Hierarchy
Expand Account Combination
Explode Segment Values
Explode Account Combination
Explode Segment Value Hierarchy
List of Values – Create
Account Combination Enabled
Account Combination End Date
Account Combination Start Date
Account Type
Daily Rate
Enabled Flag
Functional Currency
Get Average Balance
Get Average Balance Summary
Get Balance
Descriptive Flexfield Criteria
Segment Combination Criteria
Get Balance Options
Get Balance Summary
Multiple Ledgers
Historical Rate
Ledger Name
Ledger Set
Next Segment Value
Parent Flag
Period Average Rate
Period End Date
Period End Rate
Period Name
Period Name By Date
Period Offset
Period Start Date
Period Status
Previous Segment Value
Segment Description
Segment DFF
Segment End Date
Segment Group
Segment Level
Segment Start Date
Drill Criteria Sheets
Drill Criteria – Balance
Drill Criteria – Journal Extract
Drill Criteria – Average Balance
Drill Using a Saved Template
Drill to Journal or Subledger
Analyze Balances
View Transaction R12
Support All Ledgers
Edit Template Layout
Save Template Layout
Manage Templates
Other Tools
Manage Criteria Templates
Hide Zeros
Import FSG
Configuration Sheet
Audit Get Balance
GL Wand User Options
Open Existing Report
Create Report
Execute Report
Run Report Order
Insert a Run Report Function
Run Report Filter
Modify a Run Report Function
Drill On Function
Drill to Saved Template
Refresh Mode
Refresh Reports Wand Functions
Parameter List
Report Editor
Template Manager
Clean Template
Show List of Values
Create List of Values
Audit Run Report
Report Usage Statistics
Reports Wand User Options
Report Definition
Create
Bind Variables
Bind Variable Errors
Custom SQL List of Values
Filters
SQL Errors
Edit
Security
Mass Administration
Import
Import All to Excel
Import Selected to Excel
Process
Process All
Process Single
Upgrade
Upgrade Version 4 Report Definitions
Fixing Duplicate Bind Variables
Upgrade Version 4 Templates
Upgrade Reports Wand Administrator Templates
insights
Generate Report Definitions
Create insights Tables
Search Report Definitions
Add Columns
Key Flexfield Label Integration
Advanced insights
Angles for Oracle
Import Angles for Oracle Report Definitions to Excel
Refresh Angles for Oracle Security Manager
Essays
Search Answers
Create Join Definition
Discoverer Converter
Convert using Discoverer Plus (.xml) Export
Export Workbook .xml From Discover Plus
Using the Discoverer Converter
Assign Reports
Refresh List
PL/SQL Stored Procedures
Reports Wand Database Package
Create a Stored Procedure
Assign a Stored Procedure
Exception Handling
Convert Get Balance
Load Budget
AutoPost Budget Wand Journals
Creating New Account Combinations
Budget Wand Requests
Budget Wand Messages
Budget Report Wizard
Budget Wand User Options
AutoPost Journal Wand Journals
Journal Wand Requests
Journal Wand Messages
Journal Wand User Options
Source Report
Named Ranges
Parameters
Drilldowns
Email
Advanced Options
Load and Validation
Execution
Create Schedule
Running the Scheduler
SMTP Email Settings

Create Join Definition

Use the Create Join Definition Wizard to help build a report definition, by joining two or more Angles for Oracle (previously NoetixViews) views together. This wizard works similar to the Create Report Definition Wizard with addition of two stages specific to Angles for Oracle views.

Click the Create Join Definition button. This will launch the wizard to guide you through the process.

Please see the Create Report Definition Wizard section for assistance with the Program Information, Bind Variables, Filters and Request Groups stages.

Once the program information has been populated you can select your primary Angles for Oracle view. Once the view has been selected, the description and essay information for the view will be displayed. This help insure the Angles for Oracle view selected best meets the report requirements.

Select the columns required for your report definition from the primary Angles for Oracle view. The primary Angles for Oracle view will always be at the first item of the available views panel on the left. If no fields from the primary Angles for Oracle view are selected you will be unable to continue and an error message will be displayed. Columns from the primary Angles for Oracle view should form the basis and overwhelming majority of columns selected to build this report definition.

All other Angles for Oracle views available for selection have a join defined with the primary Angles for Oracle view. Joins are defined using the Angles for Oracle Z$ Columns. Select the additional column that may be of interest from one of these Angles for Oracle views. An option exists to generate the SQL with user friendly column names.

User friendly column names – Not all columns can be generated with user friendly column names. Descriptive flex fields, A$ and Z$ columns are an example.

The SQL will be automatically generated. This does not mean the SQL can not be modified at this point. You may want to change some of the column aliases, update joins or create bind variables.

Column ambiguously defined – It is possible that a user friendly generated column name could conflict with another column from a different Angles for Oracle view. If you select “Invoice Number” from two different views. This causes a SQL exception, “ORA-00918: column ambiguously defined”. Simply modify one of the column aliases in the SQL stage or remove the unnecessary column from the Columns stage to continue.

Continue with the Bind Variables, Filters and Request Group stages as per the Create Report Definition Wizard.

Finally Click finish to automatically create the Report Defintion.

When joining Angles for Oracle views data may become skewed and it’s imperative the administrator understands the impact of the join used and how it works. No outer joins are implemented, and administrators can update the SQL generated to use outer joins in the SQL stage of the wizard should they wish. Joining multiple Angles for Oracle views will also impact performance.