Role playing Dimensions: When is it appropriate?

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

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

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

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

Role-Playing CS field edit on actions.

It would be cool if the Role-playing Character sheet changed automatically on actions, like if user posted a post or something For banners, it could be that (One/Two) the 'One' side would decrease/increase, or 'Two' side would increase/decrease For

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)

Sparse dimensions, how to handle?

I've purchased the book "The Microsoft Data Warehouse Toolkit" and have reviewed it in order to build out a data warehouse solution I am currently designing. I am stuck in a spot that I don't seem to find any examples of , or am not abl

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

Dimension loading sources

Hi all, It's about datawarehouse dimension loading : should i load dimension from a master data management referential or from the truth of my business application. In the first case, dimension will be cleaner than in the second case but it will not

MDX(or something else) for getting history based on last dimension characteristic for SCD.

Hi everyone, I am implementing a cube and I run into a problem with slowly changing dimensions(SCD type 2). I guess it might be resolved somehow with MDX or somehow else, maybe you guys can help me to resolve it. The problem: I have SCD, say Policy wit

If you haven't noticed, I've been playing a lot of Indie games recently.

I love them! With games like Cave Story, Spelunky, VVVVVV, Audiosurf, World of Goo, Eversion, and Minecraft, I'm learning that some of the best things in life are not made or enjoyed with a butt-ton of money. All these games I've listed, you should try