Dimensional model

Rule based algorithm to convert an ER model to a dimensional model

I recently came across two white papers by Moody/Kortnik that show how to use a rule based algorithm to transform an ER model to a dimensional model. I have made the papers available on my

Operational Reporting from a Dimensional Model

Having worked with various models over the years, i'm begining to think that a multi layered data model approach is best for medium and larger corporations. (see my IM model here

Question - creating a dimensional model for facility management

Hello, folks. I'd like to ask some newbie questions. I'm starting a multidimensional model for facilities management from scratch, and I'll certainly need a SPACE dimension, since it's the grain in which all the spatial information is stored in the

Logical Dimensional Model

Is there such a thing as a logical dimensional model? If you agree, how is it different than your physical dimensional model?

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

Dimensional Model Vs Views as Structure for BOBJ Universe

I have a fairly complex data mart (multiple fact tables: 5 at the moment and several more coming; 4 shared dimensions across the 5 facts, 26 total dimensions and several bridge tables). I used standard best practices for building the Business Objects

anyone use Talend for a production dimensional model build

I'm looking at Talend as they seem to be on a roll with the recent inclusion of Data Quality and Master Data Management components into their suite. Wondering what experiences anyone has had building a standard dimensionally modelled Datamart or Data

Supplier Dimension to include Customers & Employees

We are in the process of finalising Dimensions /Facts to be used in Datawarehouse. Already finalised separate dimensions (eg Customer,Supplier,Employee) to handle requirements of Sales,Purchace and Human resourses. During designing Accounts Payable Fact

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

how to model an event log

I am trying to model the following event data: Field1 = event date, field2 = event code, field3 = location code, field4 = customer_id, fields5 to 8 are event code specific, ie.

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:

Next3 Work-in-progress

Well got to say this is really Electronic Reader out of the box, though it does have some hybrid features of a Tablet. I know what I was getting into. But no matter what I am welling to give a new startup company a try in this crowded Android Tablet marke

RP Basketball...The Road Back To World Championship 2010

Yeng Guiao is the best to coach the next National team, I hope he will include these players: the best line-up for me: Lordy Tugade James Yap Gabe Norwood Anthony Washington Kelly Williams Jared Dillinger Jimmy Alapag Jay-jay Helterbrand Asi