Track and control of dimension and fact tables

View previous topic View next topic Go down

Track and control of dimension and fact tables

Post  Oleole on Tue May 29, 2012 7:24 am

Hi !

We need an overview of all dimension and fact tables developed/under development.
An overview should:
- help us when designing new ones/alter existing in response to user needs
- help us spotting missing tables
- help us spotting dimensional modelling errors
- other use ?

Such an overview may need to be made in "layers" with different detail levels.
We can import metadata from our production DB and pivot them in excel, but there are many (metadata) information elements not residing in the DB.

I hope someone can gice some good advice and point to examples of practises / examples (typical Bus Matrix etc)

Regards Ole

Oleole

Posts : 12
Join date : 2012-02-15

View user profile

Back to top Go down

Re: Track and control of dimension and fact tables

Post  BoxesAndLines on Tue May 29, 2012 2:14 pm

Sounds like all you need is a data model. ERwin or ER-Studio will help accomplish all of your requirements.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Re: Track and control of dimension and fact tables

Post  ngalemmo on Tue May 29, 2012 3:44 pm

And some gap analysis of the model against requirements.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

I was thinking more aggregated overview

Post  Oleole on Wed May 30, 2012 1:40 am

Thanks for your comments !

I was focusing (or really "defocusing"..) on a more aggregated overview, ie along the lines of a more expanded bus-matrix.
It then would be easier to "shop" dimensions when preparing for new fact tables.
Anyone know of any examples ?

Regards Ole

Oleole

Posts : 12
Join date : 2012-02-15

View user profile

Back to top Go down

Re: Track and control of dimension and fact tables

Post  LAndrews on Wed May 30, 2012 12:56 pm


The bus matrix is a very high level view of the dimensional model - effectively it is just an inventory of the facts (rows) & dimensions (columns), showing the relationships (i.e. - what dimensions apply to each fact). It rarely has enough detail to answer some of the questions you mentioned in your original post.

It can be helpful for communication/analysis - for example, when looking at new facts, it allows you to quickly assess which ones require new dimensions compared with exisiting dimensions - this can be valuable when prioritizing development work.

In all my solutions I always include a logical data model document, which presents the dimensional model in greater detail, including hierarchies, SCD rules etc.

LAndrews

Posts : 132
Join date : 2010-05-13
Location : British Columbia, Canada

View user profile

Back to top Go down

Re: Track and control of dimension and fact tables

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