| |
Data Dynamics Analysis Support
Started by EdwinChan at 11-29-2009 8:08 PM. Topic has 7 replies.
  
|
|
Sort Posts:
|
|
|
|
 11-29-2009, 8:08 PM
|
EdwinChan
Joined on 12-01-2006
Posts 46
|
Sort by expression did not work when using filter
|
|
|
|
|
My analysis report has just one field in row and one measure in data. I can set "sort by expression" as descending by the values in measure field. However after I add another field in filter, the sorting is not working. The data is not sorted any more. What happens?
|
|
|
|
|
Report
|
|
|
|
|
11-29-2009, 8:16 PM
|
EdwinChan
Joined on 12-01-2006
Posts 46
|
Re: Sort by expression did not work when using filter
|
|
|
|
|
|
I found that the data has sort order before data is filtered but I need it to be sorted after filter. Is there any way to do that?
|
|
|
|
|
Report
|
|
|
|
|
11-30-2009, 5:21 AM
|
GauravC
Joined on 12-11-2008
Posts 579
|
Re: Sort by expression did not work when using filter
|
|
|
|
|
|
Hello,
Can you try to set the sort expression using the layout action and see if it helps.
You may refer to the following link to get more details on SetSortOrder method:
http://www.datadynamics.com/Help/ddAnalysis/DataDynamics.Analysis.Windows.Forms~DataDynamics.Analysis.Layout.ILayoutActions~SetSortOrder.html
Thanks,
Gaurav
|
|
|
|
|
Report
|
|
|
|
|
12-02-2009, 7:10 PM
|
EdwinChan
Joined on 12-01-2006
Posts 46
|
Re: Sort by expression did not work when using filter
|
|
|
|
|
|
I suppose to allow user to sort and filter as they wish but not limited to sort and filter in a particular way (I think that is why DDA is for). Hence it will a complicated if I need to code to detect the current sorting field and then act accordingly.
Will you consider to sort records after filter? I think it is more logical to end users. The current way confuse users and make soring virtually unusable if filter is used at the same time.
|
|
|
|
|
Report
|
|
|
|
|
12-04-2009, 2:47 AM
|
GauravC
Joined on 12-11-2008
Posts 579
|
Re: Sort by expression did not work when using filter
|
|
|
|
|
|
Hello,
I have tried to replicate the issue as per the steps mentioned by you. Here are the steps:
1. Connected the windows Pivot view to a Nwind .ddacube .
2. Added one attribute to the row shelf. (Suppliers)
3. Added one measure to the Data shelf (Average Unit Price)
4. Applied sorting to the row shelf (Descending)
5. Filtered AverageUnitPrice in data shelf.
6. The sorting is still effective listing all the countries in the descending order.
Can you please let me know if I am doing anything different then you or the exact steps to replicate this issue.
Thanks,
Gaurav
|
|
|
|
|
Report
|
|
|
|
|
12-11-2009, 7:07 PM
|
EdwinChan
Joined on 12-01-2006
Posts 46
|
Re: Sort by expression did not work when using filter
|
|
|
|
|
|
Hi,
My objective is to see the top N best sales product of a particular region. Here is how I try to produce the result using NWind local cube.
- Open the sample web viewer solution
- Select NWind local cube in data source anc connect
- add Order count in Data shelf
- add Customer country in Filter shelf and select USA only
- add Product in Rows shelf
- Apply Sorting in Product (Descending by expression "Order count"
Add this point, I can see the prodcts are not actually sorted (173,276,241,386,...)
Edwin
|
|
|
|
|
Report
|
|
|
|
|
12-14-2009, 3:43 AM
|
AashishB
Joined on 12-11-2008
Posts 818
|
Re: Sort by expression did not work when using filter
|
|
|
|
|
|
Edwin,
The sort by expression is not working since you are loading an old cube. A cube may not contain the basic records, therefore sorting and heading filtering are not possible. If you load the NwindMDB- SalesProductsSuppliers instead of the NWind local cube and then perform the steps you listed above, you would notice that the Products are sorted by the Order Count.
Regards,
Aashish
|
|
|
|
|
Report
|
|
|
|
|
12-28-2009, 4:03 AM
|
Andrey - DD
Joined on 08-01-2007
Russia, Novosibirsk
Posts 671
|
Re: Sort by expression did not work when using filter
|
|
|
|
|
|
Edwin,I've reproduced this behaviour and entered Case 140868 to address it.
Thank you,
Andrey T.
|
|
|
|
|
Report
|
|
|
|
|
GrapeCity » Product Support » Data Dynamics A... » Re: Sort by expression did not work when using filter
|
|
|
|
|