Results 1 for
"subsetting date time dimensions and role playing date tim..."
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
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
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
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
Dates in many dimensions
Hello, I am new to DW. Currently, I am working on a Human Resource database. There are many tables in the source systems which stores dates e.g. dates about contract start, finish, Vacations of an employee, temporary service suspension and many more.
Hello, I am new to DW. Currently, I am working on a Human Resource database. There are many tables in the source systems which stores dates e.g. dates about contract start, finish, Vacations of an employee, temporary service suspension and many more.
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
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
Time dimension - update
Hi, I was not sure if this question was for ETL or here ;-) This is the situation : I have created a DW and a cube for statistic for Paramedic events. I'm working for the governement of canada and they are using some unusual financial period (13
Hi, I was not sure if this question was for ETL or here ;-) This is the situation : I have created a DW and a cube for statistic for Paramedic events. I'm working for the governement of canada and they are using some unusual financial period (13
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
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
Dealing with empty/missing dates in dimensions
I'd like to know other people's opinions on how to deal with missing dates in dimensions, which is a situation that happens quite frequently (for example, think of birth date in a customer dimension). We all know that attributes in dimensions should not
I'd like to know other people's opinions on how to deal with missing dates in dimensions, which is a situation that happens quite frequently (for example, think of birth date in a customer dimension). We all know that attributes in dimensions should not
New user extensions for date and time related functions.
hi guys, There is some more function in new user extension related to the date and time. It contain the following functions: 1. StoreCurrentDate : This function store current system date in MM/DD/YYYY format.If you want to change the
hi guys, There is some more function in new user extension related to the date and time. It contain the following functions: 1. StoreCurrentDate : This function store current system date in MM/DD/YYYY format.If you want to change the
Date Dimensions - Muliple Calendars
Hi, We have an interesting challenge with our Date dimension. We need to carry multiple calendars - one per country, and one for the Group. When loading the FACT, we create a record per invoice for the country and a record for the group calendars. Thi
Hi, We have an interesting challenge with our Date dimension. We need to carry multiple calendars - one per country, and one for the Group. When loading the FACT, we create a record per invoice for the country and a record for the group calendars. Thi
Handling different Time Zones
I have SSAS 2008 with sql server 2005 database as a source. Currently, we store all dates in UTC time and use system generated Time dimension in the cube. Up until recently the granularity of a day was just fine for our needs. Now ( I've been doing
I have SSAS 2008 with sql server 2005 database as a source. Currently, we store all dates in UTC time and use system generated Time dimension in the cube. Up until recently the granularity of a day was just fine for our needs. Now ( I've been doing
Dynamic dimensions
What is the best way to handle dimensions that change depending on user parameters? For example, lets say you want "Months Since Inception" to be a dimension, because you want to bucket by it (i.e. 0 to 50 Months, 51 to 100 Months, etc.) but
What is the best way to handle dimensions that change depending on user parameters? For example, lets say you want "Months Since Inception" to be a dimension, because you want to bucket by it (i.e. 0 to 50 Months, 51 to 100 Months, etc.) but
Date Dimension or DateTime Field
Hi, I'm working on a project where dimensions have dates in them. An example is for a client where we have date of birth, joining date, date of death, etc. In fact i have about 6 different date columns. Now, I'm trying to find out what the best
Hi, I'm working on a project where dimensions have dates in them. An example is for a client where we have date of birth, joining date, date of death, etc. In fact i have about 6 different date columns. Now, I'm trying to find out what the best
time dimension
Hi I have to create a time dimension to cater to the reporting needs. With the current database structure which is not a dimensional model we need to create reports that are period based. How do we create a time dimension table (we need year, quarter,
Hi I have to create a time dimension to cater to the reporting needs. With the current database structure which is not a dimensional model we need to create reports that are period based. How do we create a time dimension table (we need year, quarter,
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,
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,
Store Business Hours in Time Of Day dimension?
Hello, I am building my first DataWarehouse and I got stuck on how to handle the time of day and my business hours. I am trying to evaluate response times for support cases and I have multiple time zones with different business hours. I only need to
Hello, I am building my first DataWarehouse and I got stuck on how to handle the time of day and my business hours. I am trying to evaluate response times for support cases and I have multiple time zones with different business hours. I only need to
Results 1 to 15 on 457
for "subsetting date time dimensions and role playing date tim..."
for "subsetting date time dimensions and role playing date tim..."
Active topics
Popular topics
Unanswered topics
