Print Page - (F/M)Differentiate Hierarchy and Dimension

Title: (F/M)Differentiate Hierarchy and Dimension
Post by: Taboka on 25 Jun 2007 02:45:00 AM

Hi all,

I am fairly new to Cognos and hope someone can help me differentaite between a Hierarchy and a Dimension in Framework Manager

Thank you

Title: Re: (F/M)Differentiate Hierarchy and Dimension
Post by: JGirl on 27 Jun 2007 06:05:40 AM

Hierarchies are alternative structures for viewing the same lowest level data through different rollup paths.

So:
* a hierarchy always belongs to a dimension
* a dimension always has one hierarchy
* a dimension can have multiple hierarchies if required.

For example, you might have 3 hierarchies in a date dimension:
* Hierarchy 1 "By Calendar Years"
-- Level 'Calendar Year' eg. 2007
-- Level 'Month' eg Jan-2007
-- Level 'Day' eg 01-Jan-2007

* Hierarchy 2 "By Calendar Quarters"
-- Level 'Calendar Year' eg. 2007
-- Level 'Calendar Quarter' eg. 2007Q1
-- Level 'Month' eg Jan-2007
-- Level 'Day' eg 01-Jan-2007

* Hierarchy 3 "By Fiscal Years"
-- Level 'Fiscal Year' eg. FY 06/07
-- Level 'Fiscal Quarter' eg. FY 06/07 Q3
-- Level 'Month' eg Jan-2007
-- Level 'Day' eg 01-Jan-2007

Hope this helps.

J

Title: Re: (F/M)Differentiate Hierarchy and Dimension
Post by: Taboka on 27 Jun 2007 06:57:41 AM

Thank you ,that definitely helped ;D

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Topic started by: Taboka on 25 Jun 2007 02:45:00 AM