Start and Finish dates and role-playing dimensions

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

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

Combination of SCD2, partial snowflake, Effective and end dates in fact table

We are creating dataware housing for multitanant based systems for HR module. Requirement ?Able to report on historical data for any given data time. Active employees headcount till given date. (as of that day) Onhire and termination based on perticula

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

What kind of roleplay do you do?

Do you have experience in roleplay? If so, what kind? And if not, then what do you want to do? Personally, I never went for any of that realistic stuff. I got boring. My friend and I picked a few characters from fandoms and just played with silly,

When/How did you start vidding?

Title says it all, 'nuff said As for me, I'm not exactly sure HOW I started vidding... it seems like ages ago xD. But I'm certain, that I began vidding with Windows Movie Maker in 2005-2006. Wow, I was so excited with that crappy old program, that I

Battery Usage / Charging observations

The battery charging and battery usage seem to puzzle me. Today under controlled environment, I had the unit in operation. Charger attached. Waited until the Icon shows full Green, and battery state (under "spare parts") showed 100% AND fully