SAP BO Analysis Sorting - SAP BO Analysis Edition For OLAP

What is SAP Bo Analysis sorting?

In a workspace, it's attainable to sort the info in an ascending and descending order. after you organize the data in an ascending type, you have got data with smaller values at the highest. A descending type arranges data with larger value at the highest. By default, in an analysis, data is sorted during a descending order.

How to Apply Sort in a Crosstab?

In a Crosstab examination, select the row or column that you need to sort. On the toolbar, select Analyze tab at the top. To put on sort, click the arrow next to Sort. You can also right-click on any key figure or hierarchy in Row/Column tab and select Sort option → A to Z or Z to A.

sort_crosstab

When we put on a sort on Corporation code in Z to A sort order, the values will be altered in the key analysis.

apply_sort

This has a sorted value in alphanumeric sort order.

How to Reverse a Sort Order?

You can also reverse the sort order from ascending to descending and vice versa. To reverse the sort, select the other sorting order.

reverse_sort

How to Remove a Sort Filter?

It is likely to get rid of a sort in an analysis yourself or mechanically. To eliminate a sort by hand, you can right-click the member header -> Select Sort, and then click Remove sort, or right-click the Sort icon beside the sorted member's name and click Remove sort.


remove_filter

A sort is mechanically detached when one of the resulting actions is achieved −

  • When you select swapping hierarchies, eliminating a hierarchy, or adding a hierarchy results in sorts and filters being removed.
  • When you use nesting hierarchies, this removes the value sorts; though, member name sorts continue and filters are not affected.

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

SAP BO Analysis Edition For OLAP Topics