Dimension Design | MorneJNel

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 Hierarchy - Facts by various levels

Hello, I am working on a new project (with Oracle OBIEE) where most data needs to be seen by a terminal(game or cahsier). The terminals are located in different venues in various cities and states. Some terminals may just be at a city or a state level

Modeling multiple multivalued dimensions and other design questions

Hello, all. This is my first time working on a dimensional model and I have some questions regarding multivalue dimensions. I am modeling our Remedy trouble ticket process and was settling on the grain being each individual ticket. The problems come in

Slowly Changing Dimensions - Design Review (Need More Clarification)

Hello, Suppose I have following Fact and Dim table CustomerDim CustomerKey CustomerID CustomerNumber CustomerName CreditLimit - Slowly Changing, wants history IsAnnualMember - Slowly Changing, can be different from year to year or

How to design student quarterly registration fact table

I am in the process of creating a student data warehouse for a university. I want to track the student quarterly registration. I am wondering what the best way to create the fact table is. The main dimensions should be time (quarter) and student but there

Dimension Design with Multiple Data Sources (ORACLE and SQL Server)

Hi All. We have a client that is currently migrating from a legacy SQL Server (6.5) based ERP to Oracle e-Business Suite. The old legacy system was distributed in both application and database, however the application and database structure was (almost

Dimension Modeling Design challenge - Help Needed

Guys, Help me out identifying whats wrong with my model. I am able to get to the right data, but size of the fact table is arguably high and not gladly acceptable. Let me show you the picture (tip of the iceberg) Data table in transaction db is

Questionnaire for medical record entries

Good afternoon, I am currently working on a data warehouse in the health care sector and I currently facing this problem: The aim of this warehouse is to have an overview of a cancer therapy. So, I have created the following fact table

Sparse dimensions, how to handle?

I've purchased the book "The Microsoft Data Warehouse Toolkit" and have reviewed it in order to build out a data warehouse solution I am currently designing. I am stuck in a spot that I don't seem to find any examples of , or am not abl

Common elements in web design layout

Creating a website design is not a simple process. You have to know many details related to web designing to give your websites the most perfect look. Web design layouts vary with respect to the requirements and preferences. Here are a few common

Reasons to use a 3NF design over a Dimensional Model design for an EDW - Discussion

I've been dimensional modelling for well over 10 years, and strongly held the opinon that only a dimensional model would work for an EDW, however i'm now begining to think that there are certain requirements that lead to a 3NF design for an 'Enterprise

BB12 Matt Hoffman

Big Brother Cast - Matt Biography Matt Name: Matt Hoffman Age: 32 Current Residence: Elgin, Ill. Occupation: Web designer Three adjectives that describe you: Intelligent, creative and sweet-talker Favorite activities: Playing

Graphic Design Forum | GraphicsCode.net

GraphicsCode.net GraphicsCode.net specializes in graphic design and web design, providing you with free graphics, tutorials and other services. Show off your work, get feedback and request graphics. A place where you can have fun and adventures, and a