The two major pieces of functionality that were introduced in version 1.8 are sorting and paging. Sorting allows the deep sort, where all of the drilled-out members are sorted based on the criteria regardless of the position in the hierarchy, and the SortingKeepHierarchy type of sort, where the hierarchy is not broken up, and only the elements within the hierarchy are sorted. Sorting is activated by clicking on the up and down arrows in the column header (y-axis members).
Paging functionality is great for support of thin-wire clients when the potential result-sets are very large. If the result set is longer than the page size, the virtual pages are generated and the user has the benefit of only waiting for the response for the display of one page of data.
Here is the summary of the new properties introduced in version 1.8:
· SortingEnabled - when this property is set to true the grid provides sorting on the columns
· SortingKeepsHierarchy - when this property is set the bottom most XMLA result set will be sorted within the hierarchy while keeping the top-level as it is in the dimension hierarchy. If the property is not set, the whole result-set dimension hierarchy is sorted at all levels regardless of dimension structure.
· PagingEnabled - when this property is set to true the grid will be displayed in pages with rows determined by the PageSize property. Navigation bar at the bottom of the grid is used for moving between the pages
· PageSize - determines the number of rows displayed per page
|
|