Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
BIP Data Model - View Data - Table View, get columns order exactly like in SQL
Description
Oracle BIP Data Model has a relatively new feature to view data as a table (alternative way to XML view). Outstanding! Thanks Oracle.
Table View sorts columns in the table in it's own, uncontrollable order, like newly added to SQL columns will be at the end, and so on.
It would be nice if the columns order exactly follows SQL, all the time.
For those who managed to read to the end, here's a workaround. Write into Data Set SQL this (magic, ha-ha-ha) code: "select * from dual" and execute it (click View Data button), replace back your SQL into the Data Set, you cleared the cash, your columns now will exactly follow the SQL code order.
Use Case and Business Need
Any SQL code results preview in Table View outcomes as a table with uncontrollable columns order. For heavy query it maybe inconvenient.
Original Idea Number: 11108dde51