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

Questions about Dimension Role-Playing
On page 110 of "The Data Warehouse Toolkit (2nd Edition)" it talks about basically creating a view for each "role" the time table might represent. Seems like you would end up with an excessive number of views. The 2nd paragraph state

Too many Time Dimension Role Views?
I have a question about date fields and the time dimension. We have an Order Detail fact table that has about 10 date fields. We're not sure how best to handle these with regards to joining them to the "Time" dimension. If we strictly

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

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,

SET2/Q.1 a. Analyse the role of in-house researcher in marketing research.
Q.1 a. Analyse the role of in-house researcher in marketing research. [3 marks] b. Discuss the purpose of research report with its important characteristics and functions. [7 marks]

SET1/Q.2 a. Outline the role of different types of retailers.
Q.2 a. Outline the role of different types of retailers. (8 marks) b. What is sales forecasting? (2 marks)

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

Founder role change
My forum is currently experiencing issues regarding the founder. The forum was created by him, however he had agreed to no longer make changes to the forum. We would like to transfer the founder rights to another individual, would we be able to accomplish

Gateway to Role-Play
Forum Title: Gateway to Role-Play Choice of Category: Games and RPG Language: English Forum's Purpose: The purpose of Gateway to Role-Play is to provide a friendly, organized atmosphere where members can role-play in various genres, chat

Medieval Role-Play
Choice of the category: Games & RPG Choice of a title: Medieval Role-Play Forum address: http://www.medieval-role-play.forumotion.com/ Main language: English Forum description: Medieval Role-Play allows player to live a Medieval Life.

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

The Role-Playing Forum Review
Name of the Forum: The Role-Playing Forum Address: http://roleplayforum.betaboard.us/forum.htm Area's you wish the reviewer to review: Quick Review

Kybro the Mighty. xD
Name: Kybro. Powers: They're always changing, but they revolve around light, darkness, heat, and electricity. Appearance: Hair color: Purple. Height: Normal. Clothes: Whatever I'm wearing, plus two straps on my arms like a shoulder holster, but the