Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Time Dim Snowflaking

2 posters

Go down

Time Dim Snowflaking Empty Time Dim Snowflaking

Post  Vishy Tue Mar 06, 2012 3:45 am

Time Dim Snowflaking C:\Documents and Settings\E20017242\Desktop\time

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

Back to top Go down

Time Dim Snowflaking Empty Re: Time Dim Snowflaking

Post  gvarga 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

Back to top Go down

Time Dim Snowflaking Empty Re: Time Dim Snowflaking

Post  Vishy 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

Back to top Go down

Time Dim Snowflaking Empty Re: Time Dim Snowflaking

Post  gvarga 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

Back to top Go down

Time Dim Snowflaking Empty Re: Time Dim Snowflaking

Post  Vishy 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

Back to top Go down

Time Dim Snowflaking Empty Re: Time Dim Snowflaking

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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