I have 4n0+ columns in obiee report and sorted 4 columns only in the report.
But in order by class other unsorrted columns are also coming.
Can you please suggest why these are coming.
I guess that these are included as defulat by obiee as a performace technique.
Don't think it's a performance technique but rather than a layout consistency.
You want your analysis always returning the rows in the same order and not randomly (if the ordering for the subset of columns you decided returns multiple rows).
You don't really want the order of rows in your table to change every time you run the query. That's why Oracle adds the oder order by.