I created a report in sample database with these columns in 188.8.131.52
1- C50 Region 2 D1 Office, 3 P1 Product 4 1-Revenue and 5 C1 Customer Name
Hit Results and I can see the result in this order.
If I change column order in result tab to say 1,5,2,3,4, result tab table view is updated. Now if I go back to criteria tab, column order remains the same ( 1,2,3,4,5)
This may be expected functionality in 184.108.40.206 but was not the case in 10g. This may be due to changes allowed in html layer.
Now if I go back to criteria tab and reorder columns (say 1,3,2,4,5) and then click result, result tab columns are not ordered as set here. Result tab continues to show 1,2,3,4,5
I saved the report with order 1,3,2,4,5 and log back in, order remains 1,2,3,45/ I believe if I restart presentation services, it will be come OK. The only way is to create a new report that I know now other than restarting presentation service.
Have you observed this?
If yes, what is the solution, how can result tab refresh with the order of the columns in criteria tab?
In OBI 11g,the column order in the criteria tab and the results tab are not coupled to each other.
When you create the report for the first time, both are in sync. If you need to reorder the columns, goto result tab and click on edit report, in the columns and measures section of the report, reorder the columns the way you desire.
Save the report and the report should have the columns in the order you have set.
P.S : this is not a bug !
I agree that when the report is saved, column order in 'Results' tab will be the way it will be rendered later on.
Comparing to 10g experience and otherwise 11 user experience, unsynched Criteria column sequence wrt to result column sequence is not intutive and not a good user experience.
For now my issue is clarified and thanks for your reply.