Data Warehouse Modeling
Hello there, Considering the case that i am assigned to work on, which is to decide on the most appropriate schema to be chosen for the Data Warehouse / Business intelligenece Project. First of all, i would like to know the available options for me,

Dimension Modeling Design challenge - Help Needed
Guys, Help me out identifying what’s wrong with my model. I am able to get to the right data, but size of the fact table is arguably high and not gladly acceptable. Let me show you the picture (tip of the iceberg) Data table in transaction db is

Beginning Data Modeling for DW
Hello, Please bear with me as these are a beginner's struggle to implement the DW the best way possible. I recently started studying about Kimball modeling. I would like to ask a few questions on common practices on modeling the DW. I need to

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

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

Some very basic question regarding overall ETL and Modeling strategy/best practices for Data warehouse project
Hi One of my client has multiple source OLTP system (due to acquisition) which stores same type of data e.g. order, sales amount etc now they might be called by different name according to source system but they mean the same e.g. one might call is

Need help with modeling employee and degrees earned
Requirements: 1) Provide monthly employee counts that can be sliced by an employee's degree granting institution(s) and/or institutional research activity levels 2) Count new hires by their highest degree earned at time of hire and/or by terminal

Many to Many modeling with SSAS
Up until recently I haven't needed to model 'many to many' relationship data in SSAS. I have found quite a good paper called "The many-to-many revolution" written by Marco Russo which goes through several different design patterns to cater for different

History tracking in a CRM data warehouse
Hi. I've been reading these forums for a while now, but registered specifically to see what kind of responses I could get to a problem we're having. I work at a company with in-house expertise in data warehousing or dimensional modeling (you folks

Building data warehouse from scratch.. Need some advice.
Hi Folks, Currently my job is to build a data warehouse. Business is using crystal reports to generate reports from the production database(ODS). Now we want to build a data warehouse and use OBIEE OR COGNOS to generate the reports from the data

Modeling Healthcare Measurements
I'm trying to figure out how to best model a DataWarehouse Star Schema structure to capture certain medical information that will answer the questions we ask. First the questions to put in some context: 1) How many distinct patients had a BMI in the

Dimensional modeling for donations with multiple designations
I'm trying to find the most appropriate design for the above topic. Transactional-wise, our system processes incoming donations. Each donation (say, someone walks in and hands you a check) may have 1 or more designations associated with it (e.g., 50%

datawarehouse modeling
I'm modeling data warehouse for some kind of helpdesk system also this si my graduate work and first project. Question i have is it possible to connect two fact tables. For example fact table Problem(FactProblem) stores informations about problems that

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

Banking Data Warehouse
Hi, I want to build a Enterprize Banking Data Model. So I want to know the basic conformed dimensions for the different subject areas of Loan Application, Payments, Customer contacts, Account Balances. Can you provide me with any documents or a standard