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,

Haunted Call Center
This is a compilation of stories from different employees working in the call center where I used to work. Our office was located in a building that was converted from a warehouse to two story office building situated in Cebu City, Philippines. I was at

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

INTERVAL TIME SUM COLUMN
Hello, In my data warehouse I have a fact table that joins with calendar table on BETWEEN clause ( calendar.date between myfact.startdate and myfact.enddate ). In calendar date I have a record for each day. I need to sum a fact table column in my

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

Iraq May Join WTO by End-2011
Iraq May Join WTO by End-2011 (Voice of Iraq) - 23/11/2009 Reuters: U.S. official said that Iraq could join the WTO by the end of 2011, if diligently sought for membership, which may help reconstruction efforts, through enhanced trade and investment

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

Point in time reporting using ad hoc BI capability
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

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

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

1 Dimension used multiple times in 1 fact table?
Hello, I have a dimension used to store several types of 'bands' like monthly income bands, available income bands, risk bands, settlement bands etc. If I leave out all the lineage columns this is what the dimension looks like: DimBandID BandType

Wondershare Time Freeze [Free offer is time limited]
I found this rollback software from another website,and i checked its official site. Easy switch between virtual environment and actual system: With Wondershare Time Freeze, you don't need to reboot computer to go back to the actual system. Just exit

JOIN TERUS DAPAT CEK
Rakan-rakan internet Semoga anda semua ceria dan bahagia Sekarang terlalu banyak program yang mengajak kita menjana pendapatan dengan pendapaftaran yg serendah RM10.00 sahaja HINGGALAH yang besar termasuk juga program MLM dsbnya. .... CERITA SEBENA

Mounts & Time calculation
Basic of Indian Palmistry Mounts on Palm and Time Calculation This figure describes mounts on palms, positions of mounts, time calculation of lines according to indian palmistry for beginners so that they can try to read their own

Real time datawarehousing
Hey, There is a lot of buzz going on regarding real time datawarehousing. But how do you actually do this ? How can you implement conformed dimensions and conformed facts in real time ? How can you consolidate data real time ? Vendors promise