Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Wiki Markup
{anchor:top}
{toc: class=contents}
h2. Overview 
{styleclass: Class=topLink}[top|#top]{styleclass}
Yellowfin allows you to define drill down hierarchies for dimensions.  Hierarchies enable users to explore their data in a way that is appropriate for your business.  Yellowfin re-calculates report data as you move down a hierarchy.  Using hierarchies you can provide OLAP functionality from a relational data source.

The common areas for which hierarchies are created include:
* Geography (Region, Country, State)
* Date (Year, Quarter, Month, Week, Date).
* Organisation Structure (Division, Line of Business, Cost Centre)
* Customer (Country of Origin, Region, City, Customer).
* Product (Category, Line, Product Code)


h2. Creating a Hierarchy 
{styleclass: Class=topLink}[top|#top]{styleclass}
If you wish to add a hierarchy:
# Select the top level of your dimension hierarchy (country in the example below).  
# Click the hierarchy tab and select Yes for drill down
# You will then select the column you wish to drill to.
# As you progress down the hierarchy Yellowfin will display the drill path as information for you.
!104.png!

bq. See [View Calculated Fields] for more information on building date hierarchies using calculated fields.
bq. See [Drill Down Reportsドリルダウンレポート] for more information on using drill hierarchies in reports.
\\
\\
{horizontalrule}
{styleclass: Class=topLink}[top|#top]{styleclass}