Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 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
Comments
-
Agreed, output should be in the sequence of what we are adding in the data model query, it becomes tough while we have more number of columns.
Data Model being the only option to query Fusion Tables, Oracle should prioritize this this request and provide a better way to review the results.
This is also related to one of the Idea posted, it should not restrict the number of rows as well.
0