I'm working on a reporting system that allows the user to arbitrarily query a set of fact tables, constraining on multiple dimension tables for each fact table. I've written a query-builder class that automatically assembles all the correct joins and subqueries based on the constraint parameters, and everything works as designed. But, I...
I'm new to modeling star schemas, fresh from reading the Data Warehouse Toolkit. I have a business process that has clients and non-clients calling into conference calls with some of our employees. My fact table, call it "Audience", will contain a measure of how long an attending person was connected to the call, and the cost of this ...
I have designed a fact table that stores the facts for a specific date dimension and an action type such as create, update or cancelled. The facts can be create and cancelled only once, but update many times. myfact --------------- date_key location_key action_type_key This will allow me to get a count for all the updates done, all t...
So I have two dimensions in my data warehouse: dim_machine ------------- machine_key machine_name machine_type dim_tool ------------ tool_key tool_name machine_type What I want to make sure of is the machine_type field in both dimensions has the same data. Should I create a third dimension to snowflake between the two or is there a...
My team is getting ready to start using SQL Server Analysis Services on our project but none of us have a lot of experience with it. What's a good screencast we can watch to get us started? ...