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

Bug 184808

Summary: Changes in cross tab data binding UI
Product: z_Archived Reporter: Aashima Goel <agoel>
Component: BIRTAssignee: xingjie he <xhe>
Status: VERIFIED FIXED QA Contact:
Severity: major    
Priority: P2 CC: cchen, rkanguri, tzhang, whe, yli
Version: 2.2.0   
Target Milestone: 2.2.0 RC2   
Hardware: PC   
OS: Windows XP   
Whiteboard:
Bug Depends on: 186500, 186971    
Bug Blocks: 167115, 187752    
Attachments:
Description Flags
Cross Tab related Data Binding UI changes in the 'Aggregate On' selection
none
cross tab aggregation UI
none
Add 'Add Aggregation' button in property editor
none
x-Tab aggregation Builder
none
See the current UI, and the expected dialog
none
changes needed in the dialog
none
something messed up the aggregation builder for crosstabs none

Description Aashima Goel CLA 2007-04-30 19:43:08 EDT
Changes are needed on the X Tab Data Binding UI.
Please see the suggested mock up for Details.

The changes in the layout are made consistent with other Data binding User Interface.
Comment 1 Aashima Goel CLA 2007-04-30 19:45:04 EDT
Created attachment 65443 [details]
Cross Tab related Data Binding UI changes in the 'Aggregate On' selection
Comment 2 Dazheng Gao CLA 2007-05-10 01:31:07 EDT
*** Bug 186287 has been marked as a duplicate of this bug. ***
Comment 3 Aashima Goel CLA 2007-05-10 14:21:51 EDT
Created attachment 66737 [details]
cross tab aggregation UI
Comment 4 Aashima Goel CLA 2007-05-10 14:37:22 EDT
Created attachment 66740 [details]
Add 'Add Aggregation' button in property editor
Comment 5 Chen Chao CLA 2007-05-14 07:46:29 EDT
CrossTab is an ExtendedItem, and it use the cube but not dataset to do column binding.Now the ExtendedItem couldn't get the cube. So we couldn't get the column binding's holder which is the CrossTab.

And we couldn't check the ExtendedItem is a CrossTab, GUI should rewrite the binding page and binding dialog in the CrossTab UI Plugin. 
Comment 6 Rima Kanguri CLA 2007-05-14 17:45:24 EDT
Are you saying UI cannot get the cubeName from ExtendedItemHandle? But I thought cubeName is returned by ExtendedItemHandle.

Can't the UI check if the Report item has dataset then show the data binding UI and if the ExtendedItemhandle has cubeName then show the cube data binding page in property editor?
Comment 7 Chen Chao CLA 2007-05-14 22:50:58 EDT
We should get cube by a common method, but not by property to get. Because we couldn't know the property of crosstab about cube, it is defined in the crosstab plugin and only used in the crosstab plugin.  
Comment 8 Wang Qiangsheng CLA 2007-05-15 00:03:02 EDT
Move to rc1 for the 186500, on which this bug depends on,  schedules to rc1.
Comment 9 Wang Qiangsheng CLA 2007-05-15 06:08:38 EDT
Moving back to rc0 for 186500 making as fixed.
Comment 10 Chen Chao CLA 2007-05-15 06:13:12 EDT
GUI couldn't get the argment list for a purticular function name. Currently
Model does not have any information of those function definitions. 
Comment 11 Rima Kanguri CLA 2007-05-16 00:43:48 EDT
Looks like dTe has some problem supporting this for cross tab. So  please hold off this change.
Comment 12 Lin Zhu CLA 2007-05-18 05:45:16 EDT
As per discussion with wenbin, the function name/argument list should be provided by Model team rather than DtE. So is there any problem for model to provide such support?
Comment 13 Rima Kanguri CLA 2007-05-18 13:05:07 EDT
Lin, 
I think i already agree that model will provide the function list, as indicated in my email.
I have put this bug on hold, based on our discussion on last weeks meeting.
That DtE cannot support complext java script expression in aggregation builder for cross tab. 

I have reassigned this bug to Aashima, to revise the UI, so we dont allow user to enter expression but only show the lsit of measures.

Comment 14 Chen Chao CLA 2007-05-21 05:45:18 EDT
We need the mockup as soon as quickly.Thanks.
Comment 15 Aashima Goel CLA 2007-05-21 18:11:28 EDT
Created attachment 68030 [details]
x-Tab aggregation Builder

Updated GUI based on above comments
Comment 16 Chen Chao CLA 2007-05-23 05:43:58 EDT
I have finished the binding page "Add Aggregation" button, Yuejie will do the last part.
Comment 17 Yuejie Chen CLA 2007-05-25 01:40:21 EDT
Fixed
Comment 18 Aashima Goel CLA 2007-05-29 18:24:40 EDT
Created attachment 69182 [details]
See the current UI, and the expected dialog

UI is not what was proposed. See the attachment
Comment 19 Aashima Goel CLA 2007-05-29 18:27:12 EDT
UI is not what was proposed.
see attachment(id=68030)in comment #15
Comment 20 Yuejie Chen CLA 2007-05-30 02:01:40 EDT
Show expression instead of measure name in combo box.
Fixed.
Comment 21 Rima Kanguri CLA 2007-05-30 14:57:39 EDT
https://bugs.eclipse.org/bugs/show_bug.cgi?id=130686
https://bugs.eclipse.org/bugs/show_bug.cgi?id=184808

The issue with both the bugs is same the UI is not implemented as mocked up.
Please refer to the attachments of this email
- Firstly UI should not show groupName, filter and expression ( its redundant ) Example when SUM function is selected there are no parameters Looks like from Xiong's comments model is returning 3 parameters for SUM, i.e expression, group, filter.
- We need to fix this, either model should be changed or UI should ignore filter, group and expression in the arguments

I am reopening both these bugs

Comment 22 Rima Kanguri CLA 2007-05-30 15:08:44 EDT
*** Bug 189758 has been marked as a duplicate of this bug. ***
Comment 23 Aashima Goel CLA 2007-05-30 15:33:07 EDT
Created attachment 69364 [details]
changes needed in the dialog

Changes that are required in the dialog has been marked explicitly in the attachment
Comment 24 Wang Qiangsheng CLA 2007-05-30 23:21:38 EDT
Remove all parameters of Sum function please.
Comment 25 xingjie he CLA 2007-05-31 01:52:29 EDT
*** Bug 189866 has been marked as a duplicate of this bug. ***
Comment 26 xingjie he CLA 2007-05-31 02:52:07 EDT
remove expr, group and filter arguments.
Comment 27 Aashima Goel CLA 2007-05-31 13:55:38 EDT
I am using may 31 build. changes have not taken effect completely:

1.expr field is still there.
2. Filter label has to be 'Filter condition'.

reopening to be fixed.
Comment 28 xingjie he CLA 2007-05-31 23:13:28 EDT
Please use June 1's build. I just check it code about remove 'expr' argument yesterday. for 'Filter label has to be 'Filter condition'' GUI will check in code today. Thanks
Comment 29 xingjie he CLA 2007-05-31 23:30:47 EDT
close it
Comment 30 Aashima Goel CLA 2007-06-01 17:49:56 EDT
Created attachment 69814 [details]
something messed up the aggregation builder for crosstabs

X Tab Aggregation Builder is all messed up. Please see the attachment
Comment 31 Aashima Goel CLA 2007-06-01 17:50:57 EDT
Reopening based on comment# 30
Comment 32 Wang Qiangsheng CLA 2007-06-02 04:36:08 EDT
Fixed already.
Comment 33 Aashima Goel CLA 2007-06-05 13:25:58 EDT
verified.
Build id: v20070604-0630