Community
Participate
Working Groups
Please view the attached report. I have set SORT order = DESC for row["Year"] field. It does not work.
Created attachment 67142 [details] Sample report design
Assigning to Zhiqiang, to investigate which area the issue is in?
If this needs UI changes, please fix the back end and reassing to UI team with the description of hte changes required.
We should use dimension["Group3"]["Year"] as expression rather than row["Year"]. Meanwhile we consider support "data" java script object in sort, providing that expression can be finally explained as a dimension reference.
Fixed.
Does this required UI team to do any changes, Reopening the bug Lin to make sure UI is setting the value the right way Please reassign to UI team if UI change is needed.
The UI related bug 183098 has already been fixed.However, as UI still works on sort build, which is somewhat related to this bug. Reassign to UI to see if they need any further changes.
This is a typical case that why shall we need the api team to generate the right expression. Xiong, could you make sure of this?
We need to fix this bug for RC0. If you refer to the latest excel sheet, we need to maek sure Cross tab sort and feature work in RC0
Qiangsheng, Please ignore comment #4 from Lin Zhu. We had a discussion with LIn, and only binding column name can be used in SORT key. I have reassigned to UI team, to make sure we are using the correct expression syntax.
If we need ignore the comments #4, what's the right expression then?
Do you mean expression like row["Year"]?
I have fixed the bug 183098 tomorrow night, but the latest builder will be generated at today. The expression is should data["Year"], but not row["Year"].
In sort expression, we all user to use "data" script object and "dimension" script object, the latter, however, would not directly expose to user as per agreement reached this morning. So, generally, GUI will create expression like data["Year"] in sort definition. Please note that "row" script object is not supported in xtab. So any reference to "row" would be invalid.
It's the same as 186866.
It duplicate of bug 187486. *** This bug has been marked as a duplicate of bug 187486 ***
It duplicate of 183098
With the latest build - May 17 2007, SORT still fails. This bug is not duplicate of 183098 ( which is related to filter )
There are two issues here in May 17 build. (1) UI first needs to make sure the right expression is generated i.e data["Year"] is generated in SORT key instead of row["Year"] (2) Data Engine - Even if I change the expression to data["Year"] manually, it still fails.
Yes, gui generates the right expression. Assign to DTE for item 2 of Rima.(In reply to comment #19) > There are two issues here in May 17 build. > (1) UI first needs to make sure the right expression is generated i.e > data["Year"] is generated in SORT key instead of row["Year"] > > (2) Data Engine - Even if I change the expression to data["Year"] manually, it > still fails. >
Correct a tiny error in DtE which introduced by using new ICubeSortDefinition api. This bug is fixed.