Sort by expression did not work when using filter

11-29-2009, 8:08 PM
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?

Re: Sort by expression did not work when using filter

11-29-2009, 8:16 PM
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?

Re: Sort by expression did not work when using filter

11-30-2009, 5:21 AM
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

Re: Sort by expression did not work when using filter

12-02-2009, 7:10 PM
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.

Re: Sort by expression did not work when using filter

12-04-2009, 2:47 AM
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

Re: Sort by expression did not work when using filter

12-11-2009, 7:07 PM
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

Re: Sort by expression did not work when using filter

12-14-2009, 3:43 AM
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

Re: Sort by expression did not work when using filter

12-28-2009, 4:03 AM

Edwin,

I've reproduced this behaviour and entered Case 140868 to address it.

Thank you,
Andrey T.