Categories
- All Categories
- Oracle Analytics Learning Hub
- 30 Oracle Analytics Sharing Center
- 19 Oracle Analytics Lounge
- 238 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 88 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Better methodology for entering SQL for Dataset within Data Model for BIP reports
Dawn Watson
Rank 3 - Community Apprentice
Business Case:
Our BIP reports require that large SQL scripts must be written to accomplish our reporting requirements since the "canned" reports are woefully insufficient.
When you open the Dataset within the DataModel there is a TINY square box in which to insert SQL code.
Our current methodology is to copy the SQL code out of that box, paste it into a proper code editor and then cut and paste the code back to that TINY box.
This is both inefficient and prone to errors.
The SQL box is completely unusable in it's current form.
Tagged:
2