Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

How to store multiple hierarchies within a dimension

3 posters

Go down

How to store multiple hierarchies within a dimension Empty How to store multiple hierarchies within a dimension

Post  ian.coetzer Fri Aug 05, 2011 12:54 pm

Hi

If we have an account dimension, say DimAccount.
How can we store multiple hierarchies within this dimension - for use by a Cube etc.

Both these options only cater for one hierarchy, how can we represent multiple hierarchies?

Option 1:

DimAccount
AccountKey
AccountName
ParentAccountKey
etc.


Option 2:

DimAccount
AccountKey
AccountName
ReportingLayout
ReportingHeader
ReportingSegment1
ReportingSegment2
ReportingSegment3
etc.
ian.coetzer
ian.coetzer

Posts : 57
Join date : 2010-05-31
Age : 42
Location : South Africa

Back to top Go down

How to store multiple hierarchies within a dimension Empty Re: How to store multiple hierarchies within a dimension

Post  VHF Fri Aug 05, 2011 2:12 pm

Not sure what OLAP platform you are usinig, but SSAS will allow you to define multiple custom hierarchies on a dimension. As long as all the attributes exist in the dimension you should be able to define both the hierarchies you list.

What I have found to be tricky in SSAS is defining relatiionships between attributes--it seems a little "backwards" in how you define atribute relationships. If you don't define any attribute relationships, the default is that all attributes are dependentant directly on the dimension key. Defining attribute relationsihps helps the cube build/process more efficently and helps with building custom hierarchies.

VHF

Posts : 236
Join date : 2009-04-28
Location : Wisconsin, US

Back to top Go down

How to store multiple hierarchies within a dimension Empty Re: How to store multiple hierarchies within a dimension

Post  ngalemmo Sun Aug 07, 2011 1:21 pm

I've found GL account hierarchies can get real messy real fast... particularly if you are using them for reporting (Balance sheet, statement of ops, etc...).

A bridge is the most flexible structure and you can include a hierarchy type column to discriminate which hierarchy should be used when.
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

How to store multiple hierarchies within a dimension Empty Re: How to store multiple hierarchies within a dimension

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum