Advantages:
• Simple SQL custom calculations
• More flexible reporting (subtotals, etc.)
• Operates directly against relational data source
• Transactional view available
• Record-based selection
• More intuitive for users that know SQL
• Getting the data you want
• Analyzing your data
• Sharing your data with others
• Reduce the amount of data by using Conditions
• Create a new workbook, if necessary.
• Open the workbook that contains the data you want
Disadvantages –
• Need For Users to Know Underlying DB structures and/or SQL
• Weak security, either public or private, unless installed as part of Oracle Apps
No comments:
Post a Comment