Categories
Upgrade needed to Data Set Definition Window
Description
New Data Set window provides really basic functionality and must be enhanced with advanced features in absence of direct database access in cloud applications
Use Case and Business Need
Pop-up window that allows us to store query as a data set provides very basic functionality such as:
- Validates the query
- Returns any relevant error message
- Provides Explain Plan
At present, in absence of direct database access (even read-only) to Fusion database in Cloud Applications environments, creating queries for BI Publisher reports becomes a tedious tasks. Using Query Builder is not an option as many times the report requires data to be fetched from more than 10 tables, and involves multiple SELECT statements combined with each other using set operations. Sometimes, even Logical Queries fails to fulfill business requirements if it involves data from more than one subject areas with no common Fact. Also, experienced developers are habitual of writing code over designing queries.
Many enhancements can be made to Data Set definition window in case Oracle has no plan to provide even read-only access to Fusion Applications database such as:
- Make Data Set window bigger. If possible, create a new tab for it.
- Make sure that code formatting is preserved when code is entered or copy/pasted to it.
- Show line number.
- Use same color formatting to format code as being used by SQL Developer, or at least color keywords to make it easier to understand query in the data set.
- Show line number along with error message.
- Underline missing database objects while entering query.
- Show a small drop-down menu with suggestion to enter DB object, column etc. depending on the context.
- Let developer run entered query to show sample data.
Original Idea Number: 87e32a148b
Comments
-
Same
0