Store Business Hours in Time Of Day dimension?

Time Dimension vs Measures in Minutes

Hi All, I would like to design the time in a multidimensional model. The classic calendar date dimension (day, week, month, year) should be applied here. Besides that, I have a fine grain: the minute. More specifically, let's suppose I have 10.000

Kimballs design Tip#51 - Time Dimension

This tip suggests that we can eliminate the minute dimension and have a full time stamp in the fact row.I need more clarification on how this could be implemented. For instance if I need a fact to be shown with 1/2 hour split down how could I do it withou

Dimension Attributes and Fact attributes storing same data in multiple data marts??

Can data marts using BUS architecture store the same data but be called different names like DimChargeToDept and DimDepartment. All have the same attirbutes names different but same exact data and rows. I would rather they create a view for each

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,

Model available time per day in timesheet data warehouse: fact or dimension or neither?

Hi I am new to data warehousing and related subjects and as a first project I am busy analyzing our timesheet data. I would like some design ideas for the following problem: I need to compare each consultants weekly (and monthly and annual) utilization,

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

Openings for SAP Trainee in Hages Business Solutions Pvt ltd

Industry: Computers / IT Education: B.Com / B.Sc / B.Tech/B.E. / BCA / MBA/PGDM Location: Ahmedabad Experience: 0 Years Job Details Fresher - Six months class room plus on the job training, Exposure of dealing with various clients across India

Accucore ERP system for VoIP business by Speedflow Communi

Accucore ERP system for VoIP business by Speedflow Communications It is important for VoIP company to have software solution which can be used for accounting and financial analysis. Accucore is over the billing system for VoIP companies, which meet

RIM: PlayBook to come with nonremovable, 5300mAh battery Read more: RIM PlayBook tablet to come with nonremovable, 5300mAh battery

RIM (NASDAQ: RIMM) has offered additional details of the as-yet unreleased PlayBook, following reports that questioned the battery life of its initial foray in tablet market. The PlayBook will ship with a 1GHz OMAP 4430 chip and 1GB of working memory, as

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

Funny comedy joke time!

We all could use a laugh now and again, so here's where to find one when you need one. If you have something funny from your fave comic that you want to share, post it here. I'll get the ball rolling with one of my favorites, the late great Bill

What's the current time in your country?

well this is simple Just tell us what's the current time on your country everytime you log or so on It's 9:15 pm here.

Banning members from the chatbox for a time period

Hi everyone, I have this idea,when your a moderator of a chatbox on a forum,the mod can use a code to ban a member for a certain time period,instead of banning them,and having to unban them. Example: Code:/ban/{time limit for the ban}