Hi,
We recently migrated from Oracle 9i to 10g.We are using BOXIR2 SP3.
Users want to save their Webi Documents into CSV format only.
Previously with Oracle 9i, i guess Order by is included in the Query
So they did not have any sort issue when they tried to save into CSV format.
but with oracle 10g, when we try to save into EXCEL , all the formating.sort is carried to Excel .
But the users want to save only in CSV Format, where the sort is not carried over.
But if i include ORDER BY to the query in the custom sql - in WEBI
The sorting is carried over , when they try to save into CSV format.
Is there a way or any workaround ,so that either BO/Oracle order by clause is included/used.
Thanks
Anu
mailanuv (BOB member since 2005-11-27)