Sorting is different in OBIEE 10.1.3.4.0 and 10.1.3.4.2 [message #542798] |
Fri, 10 February 2012 03:53 |
|
lkolluru
Messages: 3 Registered: February 2012 Location: Hyderabad
|
Junior Member |
|
|
I have a column which is varchar(4) and has data as numbers (1,2,3, .... 31).
When i view the column data from "Answers" in OBIEE 10.1.3.4.0, the column data is shown in ascending order 1 to 31 and the query shown is "SELECT Calendar."Day of Month" saw_0 FROM "P6 Project History" ORDER BY saw_0" --- the sort is similar to integer sort.
When the same column data is viewed from "Answers" in OBIEE 10.1.3.4.2, the column data is shown as 1,10,11,12,13,14,15,16,17,18,19,2,20,21,22,23,24,25,26,27,28,29,3,30,31 and the query shown is "SELECT Calendar."Day of Month" saw_0 FROM "P6 Project History" ORDER BY saw_0" ---- Here sort is happening considering the data as individual chars for same query.
NOTE: I am using same DB and same RPD file in both OBIEE versions.
Could you please tell me if this is an expected change in 10.1.3.4.2 or is it due to some other reason.
Thanks
|
|
|
|
|
|
|
|