Page History

...

Overview

The common areas for which hierarchies are created include:

• • Geography (Region
,
• • > Country
,
• • > State)
  • Date (Year
, Quarter, Month, Week, Date
• • > Quarter > Month > Week > Date).
  • Organisation Structure (Division
, Line
• • > Line of Business
, Cost
• • > Cost Centre)
  • Customer (Country of Origin
, Region, City, Customer
• • > Region > City > Customer).
  • Product (Category
, Line, Product
• • > Line > Product Code)

Creating a Hierarchy

1. Select Open the field menu on the top level of field in your dimension hierarchy (country in the example below).
2. Click the hierarchy tab and select Yes for drill down
3. You will then select the column you wish to drill to.
4. As you progress down the hierarchy Yellowfin will display the drill path as information for you.
   Image Removed
5. Region). Select DrillTo and then choose the next level in your hierarchy (Country).
   Image Added
6. You will now see a link between the top two fields in your hierarchy.
   Image Added
7. Now repeat the process for the rest of your hierarchy, treating the second level as top now. For example, Drill from Country to Location.
   Image Added
8. You will now see your hierarchy built.
   Image Added

See Date Functions for See Calculated Fields for more information on building date hierarchies using calculated date fields.

See Drill Down Reports for more information on using drill hierarchies in reports.

Removing a Link

1. Open the drop down menu on of the fields you created a link from (this must be the parent side of the link you wish to remove)
2. Navigate to Drill To > Drill To > None
   Image Added
3. Your link will now be removed.

...