Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 192411

Summary: Using expression for column member value to sort crosstab broken
Product: z_Archived Reporter: eclipse
Component: BIRTAssignee: Frank Zhang <xiong.zhang>
Status: RESOLVED FIXED QA Contact:
Severity: normal    
Priority: P3 CC: bluesoldier, eddie_xie, jianchao.li, lchen, rkanguri, zqian
Version: 2.2.0Keywords: plan
Target Milestone: 2.3.0 M4   
Hardware: PC   
OS: Windows XP   
Whiteboard:

Description eclipse CLA 2007-06-13 07:44:23 EDT 
As of 2.2RC2, the system appears to take expressions built with the expression builder as literal value strings.
Comment 1 Zhiqiang Qian CLA 2007-07-08 23:03:24 EDT 
Sorting on crosstab by expression currently is not supported, reassign to Data team to see if there's any future possibility to support this.
Comment 2 Lin Zhu CLA 2007-07-18 02:46:47 EDT 
*** Bug 193661 has been marked as a duplicate of this bug. ***
Comment 3 Jianchao Li CLA 2007-11-09 02:58:17 EST 
New feature to sort on crosstab by expression has been added.
Reassign GUI team to add corresponding UI feature.
Comment 4 Zhiqiang Qian CLA 2007-11-09 04:25:56 EST 
*** Bug 209313 has been marked as a duplicate of this bug. ***
Comment 5 Frank Zhang CLA 2007-11-11 22:01:54 EST 
Add "Expression Builder..." choice in row/column member value table so that user can input expression with it.
Fixed.
Comment 6 Xiaoying Gu CLA 2007-11-14 22:39:36 EST 
still exists.
Comment 7 Frank Zhang CLA 2007-11-14 22:40:42 EST 
Reopen it for there're something wrong in it.
Tianli, would you please help me open it ?
Comment 8 Frank Zhang CLA 2007-11-15 04:09:01 EST 
According Jianchao's advice, I did some modifications in UI.
1. Set Key combo to writable, and added a button to open expression builder.
2. In expression builder, I filtered "Available Column Bindings" in "Category". In addition, when user selects "Current Data Cube", only dimensions are shown, others such as "Measures" are hidden. That's because only expressions like dimension["dimension"]["level"] are supported.

Fixed.