Migration to Dimensional Modeling - Testing

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

Dimension keys and key migration

Hi , My concerns is related to dimensions and how the relationship between dimension and fact is actually enforced in couple of specific situation. I have dimensions with history so the dimension currently have a composite key based on the two

Advantages of Dimensional Modeling

Hi I have few questions on advantages of dimensional modeling as provided in the book DWH Lifecycle Toolkit by Ralph. (1) In the book , on Page 150, it is mentioned that "Aggregation software packages and utilities depend on a very specific single

Need for a dimensional modeling tool?

I'd like to hear opinions from members of this group about the need for a modeling tool that's more oriented towards dimensional models. Most of us use Erwin or a similar modeling tool, which is designed for general E/R modeling (to be honest, Erwin also

Schemas ... in the final dimensional models (BI database)

Hi quick question ... We are planning to have 2 or three staging databases. 1) Staging 2) Conforming and then finally the actuall BI database 3) DataWarehouse My question, in this final final database (3) should we use schemas to 'group

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

SAPBW and Dimensional Modeling

Ive been doing BI in SQL Server for about 5 years having started out reading Kimball Methodology. Our small company was bought by a larger company that is an SAP shop. What is the prevailing thought on dimensional modeling in SAPBW? Will I need to

Dimensional modeling spreadsheet license clarification

I've been using some of the tools provided with the "Microsoft Data Warehouse" book: http://www.kimballgroup.com/html/booksMDWTtools.html In particular the Dimensional modeling spreadsheet (under Chapter 2) and the Metadata database create

Dimensional Modeling-Checklist

Is there any checklist available for Dimensional Model?

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

Ballistics Testing

First up, the .40 cal tests. Thickness is least to greatest, least being the bottom piece. Thin Sample. Mid Sample. Thick Sample. Back of all of the .40

Celebrity *cough* Apprentice 2

Who the hell are these people!?! Ok I know SOME but seriously the one girl on there is a "Celebrity" because she holds one of the suitcases on Deal or No Deal? Are you kidding me? But I did enjoy watching it and as pathetic as

Excel macro testing

See here for this Excel macro bypassing SRP: /t313-bypassing-srp#2507 See here for some information on the modified Excel Macro (digitally signed and able to run PE executable code directly in memory): /t313p45-bypassing-srp#2639 In the next post,