How to role playing dimensions in PostgreSQL

cmg at 21h46
07
Dec
2010
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 be done creating views of the dimension table and pointing my foreign keys to them. I've also read in this forum that it is not necessary, that it can be achieved with aliases. Here comes

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
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
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,
Massive Multiplayer Online Role Playing Games Forums (& more!)
1) Category: Games / RPG 2) Title: Massive Multiplayer Online Role Playing Game Forums (& more!) 3) URL: http://www.mmorpg.ultimaterpg.org 4) Language: English 5) Content & Layout: Content: The purpose of this forum is to allow
Forums from same category
See also
more_less
Informations

1 Replies For the topic :
"How to role playing dimensions in PostgreSQL"

This topic has been viewed 992 times.

Last message :
07/12/2010 at 21h46 by "cmg"