How to store multiple hierarchies within a dimension

View previous topic View next topic Go down

How to store multiple hierarchies within a dimension

Post  ian.coetzer on 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.
avatar
ian.coetzer

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

View user profile

Back to top Go down

Re: How to store multiple hierarchies within a dimension

Post  VHF on 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

View user profile

Back to top Go down

Re: How to store multiple hierarchies within a dimension

Post  ngalemmo on 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.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: How to store multiple hierarchies within a dimension

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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