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

fact table as a dimension
Hi I'm presently modeling a data mart and I would like to use a fact table as a dimension for another fact table. Is it something doable and efficient or is there a better way to do that? if yes should i just create a surrogate key and link both

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,

TIME’s 2010 Top 10 Gadgets revealed
Time Magazine came up with a list for pretty much everything that happened throughout the year, but what caught our eye was the top 10 gadgets of 2010. The big winner here was Apple's iPad because, as the magazine puts it, “Apple finally managed to make

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

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

Prototype Project Schedule for BI Project
Hi All: I just wanted to send a quick note to ask if any of the users here had an example of a Project Schedule for a BI Project. I am generally curious about rules of thumb for things like validation, testing, launch, training, etc. Many

Time Dimension with Day Light Savings
I know time dimension has been adressed here in many threads but what i didnt find is dimension which takes care of the DST changes. I have a time dimension table that has 86400 rows which represent each second of the day. But my question is how do i

Time dimension - update
Hi, I was not sure if this question was for ETL or here ;-) This is the situation : I have created a DW and a cube for statistic for Paramedic events. I'm working for the governement of canada and they are using some unusual financial period (13

Cisco CCNA Security Training /IINS 640-553 Exam
download links: Trainsignal CCNA Security 640-533 Additional Password default: netbks.com

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

Employee With Multiple Jobs
Hello; I am developing an Employee Transaction Dimension such as that seen in Figure 8.2 of the "The Data Warehouse Toolkit". In my case, an employee may have multiple jobs. Some of the attributes found in the Employee Transaction Dimension

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

Time dimension confusion
Hi, first post here so I hope someone can advise on this. I'm looking to remodel time dimensions to somehow combine monthly 'periods' and weekly 'periods'. The aim being similar to a fiscal calendar where each week is allocated into a month period (e.g.

cttc.student
asalam-o-alaikum how r u sir it is really a great forum i have completed my CCNA preparation frm CTTC tariq road frm sir munsif.. bt sir i want to give the exam of ccna so dats y i want latest dumps of PASS4SURE......