Handling different Time Zones

Time in fact or dimension? Accumulating snapshot

I need to build an accumulating snapshot where not only do I need to track the many dates I need, but also the specific times of when things occur. Role playing and using a date dimension is not enough because it doesn't track the specific time of the day

Handling a SCD Type 2 change in a fact

Hi, I'm in the process of designing a dimensional model for a product warehouse, and a question I have is about how to handle a change of a Type 2 dimension in a related fact. I am keeping the details of each of our products in a Type 2 dimension (name

Our Zones banner request.

Nature of the creation : Banner Creation size (in pixels) : The Same size as this one With or without animation : Without animation please Background color : Blue Picture(s) link(s) : None you can make something. with your own picture Text to insert

Handling late changes to Type 2 attributes

Hi. I'm trying to find a good way to handle late changes to Type 2 attributes. Please note that I am not asking about early-arriving facts that could be handled with an inferred dimension member. Rather, I am interested in the situation where the dimensio

Counting coverages over time

Hi All, I work for a non-profit mental health org. Many of our clients get benefits from the county. These benefits last a year and then a new one is requested. They have different categories of benefit (2X1, 3A1, 3B1). I need to count the number of

Real time datawarehouse replacing operational reporting

Hi, As I was reading through articles I came across one of the advantages in real time datawarehouse that it can replace the operational reporting so there is no need for reports to go across 2 reporting DB there can be one centralised Real time DW and

Demyx Time

Have you ever heard of Demyx Time??? I SO hope you have. It is the greatest TV show EVER. (Although, it isn't on TV, so I guess it's not really a TV show...) If you don't know what it is, here's a quick descrciption. Demyx Time is a youtube show that

Time Frame & Estimate

I am new BI learner and currently studying kimball datawarehouse toolkit. I have question, How can i estimate a time frame and estimate in terms of working hours for Data Warehouse project. I know we have to go through whole Business dimensional lifecycle

Point in time reporting using ad hoc functions

Hi There Is there a BI tool that can handle the following two reporting scenarios? Please note scenarios to be preferably supported through ad hoc reports that user can build on the fly? Also, if you know how to achieve this functionality in a particular

How to enter into utlimate editor similar to FCK in explorer

Hi, There are different type of editor is using in application and it is really going to tough to identify in selenium. One user face problem in running IE but succeed in firefox. so I am going to tell you , how to write in ultimate editor through RC i

Adding smilies in more than 1 at a time

Well I've found lots of brilliant smilies I want to use but I can't because I have to manually go through all the other smilies deleting them, then I have to add the new smilies one by one, annoying right? Well I want to have an option added to add more

How long time do you sleep everyday?

how long time do you sleep everyday? I feel tired and want to sleep now,I went to bed at 23 o'clock last night.

online status time

An option where you can set the "who is online" time ... if your are inactive for 10 secunds you are already not online ... I think a setup option for this time would be great ... so users can read in a topic and be shown online on the botton of