Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations 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