Design Tip #25 Modeling Issue
I have some questions related to Design Tip #25 and Design Tip #95. I have a scenario almost near to Order & Order Items scenario but with different issues. 1. We have a system that has multiple parent-child relationships between many tables, sometimes

Is it worth modeling these customers?
Let's say we have an order form. Customers fill out the online order form with their first name and last name; email address and phone number are optional. At a later point they can execute this order. At the time of execution, the customer first name

Opportunity (Funnel) Modeling
I have some questions about a process that I'm modeling in my company and need some pointers. I've attended the Dimensional Modeling class and read the book, but I'm stumped about how to solve this problem. The business requirements for the

Modeling Question - Accumulating Snapshot vs. Event Transactions
I have a business process that has 6 distinct steps from start to conclusion for each instance of the process, we'll call it a case. Each case has two employees assigned to it, 1 owner and 1 co-owner. The owner and co-owner each have different

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

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

Store Business Hours in Time Of Day dimension?
Hello, I am building my first DataWarehouse and I got stuck on how to handle the time of day and my business hours. I am trying to evaluate response times for support cases and I have multiple time zones with different business hours. I only need to

Modeling for Service related facts and dimension (for Tour Operating Company)
I am currently doing a dimensional model design for a Tour operating company. Their business is like selling hotels rooms, flights, and excursion to customers. All these are called SERVICES. Now I am designing dimension and fact table to hold bookings

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

Business keys in Fact. Is this accepted?
It is a data warehouse optimization project and a very basic data warehouse is in place. There are a couple of dimensions with only 2, 3 columns only (<30 rows) and where the Business key can be easily interpreted. Ex: Event_Type_DIM: this has 2

Business Rule Development
Looking for comments regarding structured business rule development and maintenance. Has anyone used commercial applications or used data mining techniques in extracting business rules from legacy systems.

Geospatial Modeling
Are there any resources I can reference for modeling geospatial data? In our particular case, we are modeling a pipeline as the basic "fact" where the geographic location is of particular importance. In addition we need to model the location

Business Objects with Multiple Facts and Contexts
We are finally using a dimensional model for reporting on a widespread basis. These universes have multiple fact tables. These fact tables have shared dimensions. Unfortunately, we have users now creating reports without pulling measures that would

Business Process Identification, how low should you go?
How high level or low level should the first pass at business process identification and requirements gathering be? I had a discussion today with a business member, where they thought I had not identified their business processes properly, but I would

semantic models / layers
I am looking for recources about semantic models or layers in BI. Such as the Business Objects 'universe' or microsoft's 'BISM'. Do you know any good articles, books or blogposts. Please let me know. Kind regards, Roland