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

Ad Hoc Reports Against Cube or Dimensional Model
I am building a data warehouse on the Microsoft BI Platform. The architecture will include a dimensional model database residing on SQL Server 2008 that is updated nightly from a daily snapshot of a production database. The architecture will also includ

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?

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

Complex Inventory Model
I am designing an inventory model with dimensions: Product, Location, Time, and Collection Type. The relationships here are: 1. A Location is assigned Items that they can only have in stock 2. A Collection is assigned Items. 3. A Location is assigne

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

Remington Model 29
Looking for Remington Model #29 shotgun. Not real common, the 4-5 I've seen were rough shape. Would like to find one decent shape and price, no polychokes or recoil pads.

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:

Model for these charges
How would I model the following order system? Base Daily 4 x $50 | $200 Extra Hourly 5 x $25 | $125 Extra Weekly 3 x $300 | $900 Discount A | -$20 Discount B Percentage 5% of base @ $200 = -$10 Extra Option Z | $600 Extra Option Q | $100 Tax |

Handling History tables in Dimensional Model
Gurus, We are designing dimensional model for our organization. In our current OLTP system we have base tables and history tables. The table structure of history tables is mirror of base tables with addition of 3 auditing columns (Transaction Type,

Model Customer Transactions with variable tax counts and amounts
Hello, I am trying to create a dimensional model for the customer sales transaction business process for a regional grocery chain. The business requirements specify we must be able to recreate the accurate transaction level (aggregate) totals as well

User Access Control + Dimensional Model
Hi All, How can I implement an user access control along with a dimensional model? Let me take the classic sales star schema: fact_sales, dim_date, dim_store and dim_product. Also I have 100 end-users of my web application. Each user is allowed to

Data Warehouse for survey data
Hi All, Working with a company which uses Salesforce.com heavily. They have a large number of custom fields, and great volatility in them - frequently adding and deleting them when they cease being relevant (They collect survey data for their clients).