Time Dim Snowflaking

View previous topic View next topic Go down

Time Dim Snowflaking

Post  Vishy on Tue Mar 06, 2012 3:45 am



How do you give unified picture here to the users ?? I need to have seperate time dim for different countries due different holidays,calenders,seasons.. etc..

Vishy

Posts : 75
Join date : 2012-02-28
Location : India

View user profile

Back to top Go down

Re: Time Dim Snowflaking

Post  gvarga on Tue Mar 06, 2012 11:28 am

You can use a multicultural Calendar dimension:
# Key ( Surrogate )
Date
Month Id
Month Name
Week Nu
Day of week etc

and

Location Id
Weekday Indicator
Holiday Indicator,
Special Event etc

The granularity of this dimension is not calendar date, but calendar date per location.

gvarga

Posts : 43
Join date : 2010-12-15

View user profile

Back to top Go down

Re: Time Dim Snowflaking

Post  Vishy on Wed Mar 07, 2012 1:17 am

I am sorry, I attached a wrong picture above.
What I meant was my tim dim for different countries are going to be vastly different due to calencar,holiday's,seasons etc they might have 5-10 attributes matching rest will be different.
If I put all these in one time dim then most of the columns will have null values for those attributes not applicable to one country.

I was thinking about creating separate time dim for each country and may have a time dim with common attributes .. but not sure on how to provide unified picture to users so that they think it only one time dimesnion working in behind.



Vishy

Posts : 75
Join date : 2012-02-28
Location : India

View user profile

Back to top Go down

Re: Time Dim Snowflaking

Post  gvarga on Wed Mar 07, 2012 3:51 am

In a dimension table you should assign a value ( e.g. n/a) instead leaving the column as null

gvarga

Posts : 43
Join date : 2010-12-15

View user profile

Back to top Go down

Re: Time Dim Snowflaking

Post  Vishy on Wed Mar 07, 2012 5:59 am

that is what I would like to know, I don't want to store NULL and at the sametime I want to give users a unifited view

Vishy

Posts : 75
Join date : 2012-02-28
Location : India

View user profile

Back to top Go down

Re: Time Dim Snowflaking

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum