Migration to Dimensional Modeling - Testing
Hello, I migrated a relational database to dimensional modeling database. I need to test that all the information in the source system is there in the target system. One technique which can be used is... - to calculate the number of records in the

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

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
I’ve 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

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

Adherence to dimensional modeling in practice
I prefer following dimensional modeling principles especially those proposed by Kimball and most of the techniques discussed in this forum, I hear a lot of comments from colleagues and friends that dimensional principles are more bookish and no one follow

DIFFERENCE between Dimensional Modeling and Cube ?
Isnt cube part of Dimensional Modeling (Facts and Dimensions) ?

Dimensional Modeling In depth training
Hi, I am looking for Kimball Dimensional Modeling In depth training and I am based in UK. Kimball group do not have any training schedule this year in UK. Any suggestion would be appreciated.

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

Hierarchies in dimensional modeling
Hi, I have a little problem modeling hierarchies for a data mart. Lets say I'm building a datamart for students grades in a university. In this university you have units of teaching and each unit of teaching (UT) is composed of one to many

Transactional schema to dimensional modelling
I am in the process converting a transactional schema to dimensional modeling for reporting solution using business objects. I have a lot of component entities and classification entities which have a one to many relationships. When I convert them to