Difference between revisions of "Axis Ranking"

(→‎Axis Ranking, Filtering and Sorting)
m (Text replacement - "XLCubed" to "FluenceXL")
 
(17 intermediate revisions by 2 users not shown)
Line 1: Line 1:
−
XLCubed provides two modes of Ranking: ''Hierarchy Ranking'' and ''Axis Ranking''.
+
FluenceXL provides two modes of Ranking: '''Hierarchy Ranking''' and '''Axis Ranking'''.
  
−
The first is ‘Hierarchy mode’, and is accessed through the Advanced tab on the member selector for the relevant hierarchy. In this model, the ranking is contained within the hierarchy itself, so that if you move the hierarchy from rows to columns, the ranking is then applied on columns. The screenshot below shows a grid displaying the top 5 Products for CY2004. On the right, Geography has been added to rows, so that the Product hierarchy is nested within Geography.  
+
For further information on '''Hierarchy''' Ranking, Filtering and Sorting go to: [[Ranking, Sorting and Filtering]].
  
−
[[Image:r1.png|350px|centre]]
+
You can also view the [[Ranking, Sorting and Filtering Videos]].
  
−
As the top 5 ranking has been added to the Product Model Categories hierarchy, we now get the top 5 products for each split of the Geography hierarchy.
+
=Axis Ranking, Filtering and Sorting=
  
−
For further information on ‘Hierarchy’ Ranking, Filtering and Sorting go to: [[Ranking,_Sorting_and_Filtering]]
+
Axis Mode is an approach to Ranking, Filtering and Sorting that can be thought of as result set ranking. Here the ranking is applied to the axis, rather than the hierarchy itself.
  
 +
So, for example, if you have Geography on rows and Products on columns and then apply a top 5 ranking on rows, you get the top 5 Geographies. If you then switch Geography with Product, you will get the top 5 Products without having to re-apply the ranking.
  
−
==Axis Ranking, Filtering and Sorting==
+
Where you have two or more hierarchies on the axis, the result will be the top 5 intersections between the two hierarchies. This is shown below in contrast to [[Ranking, Sorting and Filtering|Hierarchy ranking]] which returns the top 5 members for each hierarchy.
  
−
Axis Mode is a different approach to Ranking, Filtering and Sorting, and can be thought of as result set ranking. Here the Ranking is applied to an entire axis. So for example if you apply a top 5 ranking while Geography is on rows you get the top 5 Geographies, but if you switch Geography with Product, you will get the top 5 Products without having to apply the ranking.
 
−
Where you have two hierarchies on the axis, the result will be the top 5 intersections between the two hierarchies, as shown below.
 
  
−
[[Image:r2.png|350px|centre]]
+
[[Image:Axis-Ranking-Top-5.PNG|850px|centre]]
  
−
Axis ranking is applied through XLCubed’s right-click menu, and is based from the column header, not from within a specific hierarchy.
+
==Applying Axis Ranking==
−
Right-click on the column header that you wish to rank (in our example you would right-click on CY 2004) and then select XLCubed, Apply, ranking, Top x Rows.  You can see that Top 10 and Bottom 10 appear as options – if you wish to rank any other count you select Top x Rows/ Bottom x Rows and you will be prompted to enter a figure.
 
  
−
[[Image:axis4.png|350px|centre]]
+
Axis ranking is applied through FluenceXL’s right-click menu, and is based from the column/row header, not from within a specific hierarchy.
  
−
You will notice that the first member on the right-hand hierarchy has a little red indicator in the corner – see screenshot below:
+
Right-click on the column or row header that you wish to rank by and then select '''FluenceXL >  Apply '''. Here you can select whether to sort, rank, or filter. If you select to rank Top x Rows/Bottom x Rows, you will be prompted for the number of rows to return.
  
 +
[[File:Axis-Ranking-Apply-Menu.PNG|700px|center|thumb|To rank by the numbers in the first column, right click on the Q1 FY 2015 header]]
  
−
[[Image:axis5.png|350px|centre]]
+
This will apply a ranking, limiting the number of rows returned, so an indicator appears on the first row member. You can right click on this cell and select '''FluenceXL > Axis''' which will allow you to either
 +
* '''Edit''' the applied ranking (or sort/filtering)
 +
* '''Clear all''' ranking/sorting/filtering on that axis
  
−
If you hover over this cell it displays an informational message that the rows are being ranked and that you can right-click to edit axis or clear the axis ranking.
+
[[Image:Axis-Ranking-Indicator.PNG|650px|centre]]
  
−
[[Image:axis6.png|350px|centre]]
+
The '''excluded slices''' tab allows you to remove certain members from your report (see also [[Keep Members]]).
 +
 
 +
*[[Image:axis8.png|20px|left]] Click to add an exclusion list
 +
*[[Image:axis9.png|20px|left]] Click to Clear All current exclusions
  
−
''Clear All''
+
[[File:Axis10.png|center]]
−
Use this option to clear all axis ranking options.
 
  
−
''Edit axis''
+
=See Also=
−
You will be presented with the window below showing the current ranking setting.  You can click the drop-down box to amend this if necessary. 
+
*[[Ranking, Sorting and Filtering]]
 +
*[[Keep Members]]
  
−
[[Image:axis7.png|350px|centre]]
 
  
−
The excluded slices tab allows you to remove certain members from your report. 
+
[[Category:Grid Reporting]]
−
 
+
[[Category:OLAP Operations]]
−
To add an exclusion list click [[Image:axis8.png|20px|right]]
 
−
 
 
−
To Clear All current exclusions click [[Image:axis9.png|20px|right]]
 
−
 
 
−
We will add France to our excluded slices list.  We select the Geography hierarchy and then in the Selection area choose France.  When we click OK France appears in the top half of the window  as a member to exclude.
 
−
 
 
−
[[Image:axis10.png|350px|centre]]
 
−
 
 
−
The report is refreshed and you can see that France has been removed from the report.
 
−
 
 
−
[[Image:axis11.png|350px|centre]]
 

Latest revision as of 15:51, 3 July 2023

FluenceXL provides two modes of Ranking: Hierarchy Ranking and Axis Ranking.

For further information on Hierarchy Ranking, Filtering and Sorting go to: Ranking, Sorting and Filtering.

You can also view the Ranking, Sorting and Filtering Videos.

Axis Ranking, Filtering and Sorting

Axis Mode is an approach to Ranking, Filtering and Sorting that can be thought of as result set ranking. Here the ranking is applied to the axis, rather than the hierarchy itself.

So, for example, if you have Geography on rows and Products on columns and then apply a top 5 ranking on rows, you get the top 5 Geographies. If you then switch Geography with Product, you will get the top 5 Products without having to re-apply the ranking.

Where you have two or more hierarchies on the axis, the result will be the top 5 intersections between the two hierarchies. This is shown below in contrast to Hierarchy ranking which returns the top 5 members for each hierarchy.


Axis-Ranking-Top-5.PNG

Applying Axis Ranking

Axis ranking is applied through FluenceXL’s right-click menu, and is based from the column/row header, not from within a specific hierarchy.

Right-click on the column or row header that you wish to rank by and then select FluenceXL > Apply . Here you can select whether to sort, rank, or filter. If you select to rank Top x Rows/Bottom x Rows, you will be prompted for the number of rows to return.

To rank by the numbers in the first column, right click on the Q1 FY 2015 header

This will apply a ranking, limiting the number of rows returned, so an indicator appears on the first row member. You can right click on this cell and select FluenceXL > Axis which will allow you to either

  • Edit the applied ranking (or sort/filtering)
  • Clear all ranking/sorting/filtering on that axis
Axis-Ranking-Indicator.PNG

The excluded slices tab allows you to remove certain members from your report (see also Keep Members).

  • Axis8.png
    Click to add an exclusion list
  • Axis9.png
    Click to Clear All current exclusions
Axis10.png

See Also

Retrieved from ‘https://help.fluencexl.com/index.php?title=Axis_Ranking&oldid=11189’