Dimension Modeling Design challenge - Help Needed

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

Need help with modeling employee and degrees earned

Requirements: 1) Provide monthly employee counts that can be sliced by an employee's degree granting institution(s) and/or institutional research activity levels 2) Count new hires by their highest degree earned at time of hire and/or by terminal

Dealing with Duplicate Dimension Rows

A recent acquisition has added complexity to the Customer dimension and associated fact tables at the company I work for. The root of the problem is that we now have around 20 sources of customer and associated sales facts. We have data quality processe

Modeling help on dimension with many boolean value

Hi I'm really stuck on how to model a user need/business need Basically, we are in the healthcare and we have a software that manage the work of the paramedics in ambulances. There is a table that store all standard informations about the work of

Addresses in Customer Dimension

As part of an Orders dimensional model, I am attempting to design the Customer Dimension table. The customers have multiple sold-to addresses and multiple ship-to addresses. While the OLTP allows any Order to have any combination of sold-to and ship-to

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

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

2 sources using Dimensional Modeling Workbook

We are using Kimballs Generic Dimensional Modeling Workbook and it is really great! But now we have 2 sources to the same target and are not sure about how to document that. Anyone now about a best practice for how to document this in the Generic

Dimensional modeling on HospitalStay

a different question on The Data Warehouse Toolkit, 2nd Ed. The complete guide to Dimensional Modeling. In Chapter 13 page 265 "In a hospital stay situation, however, the diagnosis group probably should be unique to the patient because it 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

Data Vault v's Dimensional Model

Seems to be a lot of interest over at LinkedIn around the DataVault model. I wondered what the thoughts were about it. When would you use it v's a Dimensional Model or even a 3NF for a data warehouse. more info here:

Founder information needed to manage credits

Hello. I was thinking in suggestions to improve the service and a good idea came into my mind: Wound`t be nice that when we want make an operation with credits (buy a domain or whatever we can do with credits), we need to enter our founder

Anime-Island-AI GFX Contest Ends on 28th and Staff Needed!

Forum Name: Anime-Island Language: English Web Address: www.anime-island.forumotion.com Administrators: DarkPrince(Me) Moderators: None Theme: Blue Remix(Still Thinking of one) Language:English Comments: This forum is for all the anime lovers