Dimensions - To Create Based on Type or Role ?

seadog2010 at 21h09
26
Jan
2011
Dimensions - To Create Based on Type or Role ?

I'm trying to lay down some guidelines for creating new dimensions in an existing shop.

I have a mix of dimensions that are type-based and role-based. Type-based are those created because an entity (think Party) has many types (individual, organization, virtual). These types share some common attributes of Party, but each carries it's own unique set of attributes. A Party-Individual may have first name, last name, birth

Read more
Reply
About
This topic belongs to the forum

  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1858
  • Numbers of messages : 8714
  • Numbers of users : 3801
  • Numbers of points : 1672
Similar topics
Role playing Dimensions: When is it appropriate?
This issue has come up and I was curious what you would say. This stems out of differing interpretations of role playing a dimension in the Data Warehouse Toolkit. There are basically two faction where I work concerning when it is appropriate to role
Start and Finish dates and role-playing dimensions
I have a bunch of date dimensions, such as BaselineDate, TargetDate, etc... I created role-playing views over my Date dimension for each of the different types of dates. But each fact row will have a StartDateID and a FinishDateID for each (like
How to role playing dimensions in PostgreSQL
I am new in the DW/BI world but as far as I've learned, the Kimball approach is the best. I need to make use of "role playing dimensions", more specifically I need more than one date in my fact table. I've read in the Kimball's books that it can
Measures as Dimensions: Banding Approach Help
I have a standard fact table with a number measures; several of which are in the form of time (e.g., minutes) and others in the form of integers. The fact table and related dimensions are exposed to users via BusinessObjects XI v2 Web Intelligence. One of
Subsetting date/time Dimensions and Role Playing Date/Time Dimensions
Working at a client site that would like to take a Date dimension using Day as Pk for Day_dim with some day of week, week day, month, year, etc. columns. Suggestion of making more conformed dimensions from Day_dim with Week_Day_dim and Month_day_dim an
Forums from same category
See also
more_less
Informations

12 Replies For the topic :
"Dimensions - To Create Based on Type or Role ?"

This topic has been viewed 1276 times.

Last message :
26/01/2011 at 21h09 by "seadog2010"